Hi.
Sorry for me English...
I have:
Intel(R) Core(TM)2 CPU 4400(a)2.00GHz
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?