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