Hi. Sorry for me English... I have: Intel(R) Core(TM)2 CPU [email protected] 1Gb RAM Linux 2.6.22-hardened PHP 5.2.5 MySQL 5.0 nginx/0.5.26 ~30000 articles ~1000 visitors every day memcached 1.2.1
I updated mediawiki from 1.12 to 1.16 and get some trouble. When I open category with a large number of articles(>3000), mysql is loaded at 99.9%. It lasts 30-40 seconds. mysql> SHOW PROCESSLIST; +--------+----------+-----------+--------+---------+------ +---------------------- +------------------------------------------------------------------------------------------------------ + | Id | User | Host | db | Command | Time | State | Info | +--------+----------+-----------+--------+---------+------ +---------------------- +------------------------------------------------------------------------------------------------------ + | 118227 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST | | 118582 | wikiuser | localhost | wikidb | Query | 11 | Copying to tmp table | SELECT /* CategoryViewer::doCategoryQuery 127.0.0.1 */ page_title,page_namespace,page_len,page_is_r | | 118583 | wikiuser | localhost | wikidb | Query | 10 | Locked | UPDATE /* 127.0.0.1 */ `hzg_page` SET page_counter = page_counter + 1 WHERE page_id = 8093 | | 118584 | wikiuser | localhost | wikidb | Query | 9 | Locked | SELECT /* LinkCache::addLinkObj 127.0.0.1 */ page_id,page_len,page_is_redirect FROM `hzg_page` WH | | 118585 | wikiuser | localhost | wikidb | Query | 8 | Locked | SELECT /* Revision::fetchFromConds 127.0.0.1 */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comme | | 118591 | wikiuser | localhost | wikidb | Query | 7 | Locked | SELECT /* LinkCache::addLinkObj */ page_id,page_len,page_is_redirect FROM `hzg_page` WHERE page_ | | 118596 | wikiuser | localhost | wikidb | Query | 2 | Locked | SELECT /* LinkCache::addLinkObj */ page_id,page_len,page_is_redirect FROM `hzg_page` WHERE page_ | +--------+----------+-----------+--------+---------+------ +---------------------- +-------------------------------------------------------------------------- At this time, mediawiki returns a 504 error. And for other jobs mediawiki work very slow... Can you tell me please what's wrong with my mysql/mediawiki configuration? _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
