Optimized notification timestamp clearing
authorAaron Schulz <aschulz@wikimedia.org>
Wed, 12 Aug 2015 22:37:57 +0000 (15:37 -0700)
committerAaron Schulz <aschulz@wikimedia.org>
Wed, 12 Aug 2015 22:37:57 +0000 (15:37 -0700)
commita15cf051885b932bc8ad0a459a2ee3eda6190143
tree99566912037fedc9db7b271e52d76d74b1ea79d3
parent1661977583aa54f5bd8410041be0478ce045460b
Optimized notification timestamp clearing

* Hint that mariadb can avoid scanning already NULL rows since
  we want to set them all to NULL. This lets the index with the
  timestamp be used, which avoids logs of scanning for users with
  many rows. For non-parallel replication, this also avoids slave
  lag in particular.

Bug: T107923
Change-Id: I8cded5476ef6adb2f8fea57239afd6e9b2a49708
includes/User.php
includes/specials/SpecialEditWatchlist.php