They said my wiki caused a MySQL server overload, and here is the example:

Most common queries xxxxxxx_wkuser:

1.Time: 15% (5907 sec)

Amount: 17% (155 queries)

Rows Examined/Sent: 0 / 8

Avg. Query Exec/Lock Time: 38 / 1 sec.

Used databases: [xxxxxxx_wk]

Query example: use xxxxxxx_wk; SELECT /* MediaWikiBagOStuff::_doquery */ value,exptime FROM `wk_objectcache` WHERE keyname='xxxxxxx_wk:messages:Userlogin/en';

2.Time: 5% (2255 sec)

Amount: 4% (38 queries)

Rows Examined/Sent: 0 / 38

Avg. Query Exec/Lock Time: 59 / 0 sec.

Used databases: [xxxxxxx_wk]

Query example: use xxxxxxx_wk; SELECT /* LinkCache::addLinkObj */ page_id FROM `wk_page` WHERE page_namespace = '0' AND page_title = 'ȬvȦ¦' LIMIT 1;

I suggest you to contact your web developer to optimize your database,
We do not have actual limit. But your database should not create many queries

My wiki is run by version 1.6.8 (because of PHP4 support) and is only accessed by myself (only 1 user) and other more than 150000 views so far were from search engine spiders, the whole database is 20M (after table optimizing it's 15M).

Strangely that, since 2 months ago pages had been too slow to load, new opened page just kept being blank for 1~2 minutes and suddenly loaded. I try to change the database name in config file (means which does not exist), the page was loaded fast and gave a mysql error for sure.

I didn't install any extensions, except some lines added to localsettings.php for authentification control, why is it so slow and gives so many queries?? I can't reopen my wiki until I solve the problem or my web host will get mad again.