Last modified: 2009-09-13 18:07:59 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T22622, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 20622 - Special:Statistics unacceptably slow (on first load)
Special:Statistics unacceptably slow (on first load)
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
1.16.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-09-13 07:47 UTC by Niklas Laxström
Modified: 2009-09-13 18:07 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Niklas Laxström 2009-09-13 07:47:52 UTC
Takes about 30 seconds in the first load. 30 seconds is near our deployment limit (currently increased to 45s), and over the development limit (20s) we use at translatewiki.net.

Subsequent views take a few seconds. The only slow part in it is the query for active users:
1252827223.73: SQL: SELECT /* SiteStatsUpdate::cacheUpdate Nike */  COUNT( DISTINCT rc_user_text )  FROM `bw_recentchanges`  WHERE (rc_user != 0) AND rc_bot = '0' AND (rc_log_type != 'newusers' OR rc_log_type IS NULL)  LIMIT 1  
1252827226.36: SQL: UPDATE /* SiteStatsUpdate::cacheUpdate Nike */  `bw_site_stats` SET ss_active_users = '1671' WHERE ss_row_id = '1'

Why is it cached, but still counted and re-cached on every view? Also note that we do keep quite a long history for recent changes.
Comment 1 Domas Mituzas 2009-09-13 08:01:36 UTC
is it happening with $wgMiserMode too? :)))
Comment 2 Niklas Laxström 2009-09-13 08:10:24 UTC
(In reply to comment #1)
> is it happening with $wgMiserMode too? :)))

No:
		# Set active user count
		if( !$wgMiserMode ) {
			$dbw = wfGetDB( DB_MASTER );
			SiteStatsUpdate::cacheUpdate( $dbw );
		}

Comment 3 Domas Mituzas 2009-09-13 08:32:23 UTC
hehehe! :)
Comment 4 Aaron Schulz 2009-09-13 18:07:59 UTC
Fixed in r56271 - should be daily now.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links