Phil Boswell wrote:
Latest strangeness: everything in my watchlist (http://test.leuksman.com/index.php/Special:Watchlist) is now marked as "New".
What **is** going on over there?
Good point, that feature will run this query:
$dbw->update( 'watchlist', array( /* SET */ 'wl_notificationtimestamp' => 0 ), array( /* WHERE */ 'wl_title' => $title->getDBkey(), 'wl_namespace' => $title->getNamespace(), 'wl_user' => $this->getId() ), 'User::clearLastVisited' );
...on every logged in page view. This should be made optional, because we'll have to switch it off on Wikipedia for performance. Knowing how MySQL locks have a tendency of infecting unrelated indexes, I dare say this will be a concurrency nightmare.
-- Tim Starling