User "Reedy" posted a comment on MediaWiki.r87292. Full URL: http://www.mediawiki.org/wiki/Special:Code/MediaWiki/87292#c17789 Commit summary:
* (bug 20468) User::invalidateCache throws 1205: Lock wait timeout exceeded Severly limit the number of calls that actually update the database (for no gain!). Leaving stuff that needs to update memcached Still, there's probably quite a lot of these calls which are still superfluous Comment: Nope. I hacked up a quick C# app to do some aggregation stats against a list of log files, which gaves stats per file and then a total like the below. These were for April <pre> Totals: Deadlock total count:8703 Lock wait timeout total count:145821 Dupe entry total count:994 User::invalidateCache 137454 Block::purgeExpired 5734 Article::updateCategoryCounts 4972 SiteStatsUpdate::doUpdate 3595 GlobalUsage::insertLinks 689 Title::invalidateCache 624 FlaggedRevision::insertOn 568 Job::pop 484 User::addToDatabase 356 Block::delete 127 Block::insert 108 LinksUpdate::incrTableUpdate 106 LinksUpdate::invalidatePages 100 ...SNIP... Total number of errors: 147809 </pre> _______________________________________________ MediaWiki-CodeReview mailing list mediawiki-coderev...@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-codereview