I just recived a friendly little Email from my host saying they have:
"suspended [my account] for excessive system resource usage due to large quantities of MySQL and PHP traffic coming from the domain and creating high server loads"
Its a personal site im running, not a "traditional wiki", so i would like to turn off some Dbase queries, if possable.
Is it possable for me to turn off the following. LinkCache::addLinkObj MediaWikiBagOStuff:_doquery
I would like to omit any SQL to the 'objectcache' table for now.
Possable ? and more importantly will it help for my situation? I really like using MediaWiki and do not want to move to somthing else.
Thanks for any help... The email my host sent me is below with examples of the activity which brought me to this...
=====================================================================
Dear Customer,
One of your domains, anotherwebcom.com, has been suspended for excessive system resource usage due to large quantities of MySQL and PHP traffic coming from the domain and creating high server loads. This sort of activity cannot be tolerated in a shared hosting environment. Examples of these queries are listed below.
16 Connect name@localhost on 16 Init DB Dabse_Name 16 Query /* Database::begin */ BEGIN 16 Query SHOW PROCESSLIST 16 Query SHOW STATUS 16 Query /* LinkCache::addLinkObj */ SELECT page_id FROM `page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1 060322 16:43:07 16 Query /* Article::pageData */ SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_id = '1' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:pcache:idhash:1-0!1!0!0!!en!2' 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages' 16 Query UPDATE `page` SET page_counter = page_counter + 1 WHERE page_id = 1 16 Query /* SiteStatsUpdate::doUpdate */ SELECT * FROM `site_stats` LIMIT 1 16 Query /* SiteStatsUpdate::doUpdate */ UPDATE `site_stats` SET ss_total_views=ss_total_views+1 LIMIT 1 16 Query /* Database::immediateCommit */ COMMIT 16 Query /* Database::begin */ BEGIN 16 Query /* LinkCache::addLinkObj */ SELECT page_id FROM `page` WHERE page_namespace = '2' AND page_title = '68.142.250.163' LIMIT 1 16 Query /* User::getNewtalk */ SELECT wl_user FROM `watchlist` WHERE wl_title = '68.142.250.163' AND wl_namespace = '3' AND wl_user = '0' AND (wl_notificationtimestamp != 0) 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (page_id=rev_page) AND rev_page = '1' AND page_id = '1' AND (rev_id=page_latest) LIMIT 1 16 Query /* LinkCache::addLinkObj */ SELECT page_id FROM `page` WHERE page_namespace = '1' AND page_title = 'Main_Page' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Http://forums.anotherwebcom.com/vb/ ' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Http://forums.anotherwebcom.com/vb/_' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Http://forums.anotherwebcom.com/vb/_' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Forums' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Forums' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Forums' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Special:AWCdownloads' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:AWCdownloads' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:AWCdownloads' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Downloads' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Downloads' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Downloads' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Site_Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Site Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Programs' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Programs' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Programs' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Programs' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Programs' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Programs' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Invision Power Board (Scripts)' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Invision_Power_Board_(Scripts)' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Invision_Power_Board_(Scripts)' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:IPB Scripts' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'IPB_Scripts' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'IPB_Scripts' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:MediaWiki (Hacks Scripts Extensions)' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:MediaWiki_(Hacks_Scripts_Extensions)' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:MediaWiki_(Hacks_Scripts_Extensions)' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:MediaWiki Scripts' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'MediaWiki_Scripts' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'MediaWiki_Scripts' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:FireFox_Add-ons_and_Extensions' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:FireFox_Add-ons_and_Extensions' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:FireFox_Add-ons_and_Extensions' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:FireFox Stuff' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'FireFox_Stuff' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'FireFox_Stuff' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Site_Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Site Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Help_Using_The_Site' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Help_Using_The_Site' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Help_Using_The_Site' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Special:Recentchanges' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:Recentchanges' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:Recentchanges' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Recent Changes' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Recent_Changes' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Recent_Changes' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:What AWC Offers' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Useful Site Links' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:What AWC Offers' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Useful Site Links' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Database::immediateCommit */ COMMIT
Regards, [Hosts Name (removed by me)]
Look at http://www.mediawiki.org/wiki/Help:Configuration_settings#Reduction for *some* tips. You might be able to switch off some use of the objectcache through disabling the parser cache (this isn't all that table's used for, but on sites without memcached, it contributes a large proportion of that table).
The linkcache is quite an integral performance saver on large sites, but on smaller ones, it's a bit of a killer. I don't know of a means to switch it off at present.
It *sounds* like you're using the wrong tool for the wrong job, but I'll spare the ranting here (you can always read the mailing list archives for December 2005). Suffice it to say that MediaWiki is developed to be not *too* much of a performance bitch, but it is expected that the server(s) behind it will be able to cope with the load.
Rob Church
On 23/03/06, Joe me@joescove.com wrote:
I just recived a friendly little Email from my host saying they have:
"suspended [my account] for excessive system resource usage due to large quantities of MySQL and PHP traffic coming from the domain and creating high server loads"
Its a personal site im running, not a "traditional wiki", so i would like to turn off some Dbase queries, if possable.
Is it possable for me to turn off the following. LinkCache::addLinkObj MediaWikiBagOStuff:_doquery
I would like to omit any SQL to the 'objectcache' table for now.
Possable ? and more importantly will it help for my situation? I really like using MediaWiki and do not want to move to somthing else.
Thanks for any help... The email my host sent me is below with examples of the activity which brought me to this...
=====================================================================
Dear Customer,
One of your domains, anotherwebcom.com, has been suspended for excessive system resource usage due to large quantities of MySQL and PHP traffic coming from the domain and creating high server loads. This sort of activity cannot be tolerated in a shared hosting environment. Examples of these queries are listed below.
16 Connect name@localhost on 16 Init DB Dabse_Name 16 Query /* Database::begin */ BEGIN 16 Query SHOW PROCESSLIST 16 Query SHOW STATUS 16 Query /* LinkCache::addLinkObj */ SELECT
page_id FROM `page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1 060322 16:43:07 16 Query /* Article::pageData */ SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len FROM `page` WHERE page_id = '1' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:pcache:idhash:1-0!1!0!0!!en!2' 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages' 16 Query UPDATE `page` SET page_counter = page_counter + 1 WHERE page_id = 1 16 Query /* SiteStatsUpdate::doUpdate */ SELECT * FROM `site_stats` LIMIT 1 16 Query /* SiteStatsUpdate::doUpdate */ UPDATE `site_stats` SET ss_total_views=ss_total_views+1 LIMIT 1 16 Query /* Database::immediateCommit */ COMMIT 16 Query /* Database::begin */ BEGIN 16 Query /* LinkCache::addLinkObj */ SELECT page_id FROM `page` WHERE page_namespace = '2' AND page_title = '68.142.250.163' LIMIT 1 16 Query /* User::getNewtalk */ SELECT wl_user FROM `watchlist` WHERE wl_title = '68.142.250.163' AND wl_namespace = '3' AND wl_user = '0' AND (wl_notificationtimestamp != 0) 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (page_id=rev_page) AND rev_page = '1' AND page_id = '1' AND (rev_id=page_latest) LIMIT 1 16 Query /* LinkCache::addLinkObj */ SELECT page_id FROM `page` WHERE page_namespace = '1' AND page_title = 'Main_Page' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Http://forums.anotherwebcom.com/vb/ ' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Http://forums.anotherwebcom.com/vb/_' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Http://forums.anotherwebcom.com/vb/_' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Forums' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Forums' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Forums' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Special:AWCdownloads' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:AWCdownloads' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:AWCdownloads' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Downloads' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Downloads' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Downloads' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Site_Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Site Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Programs' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Programs' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Programs' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Programs' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Programs' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Programs' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Invision Power Board (Scripts)' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Invision_Power_Board_(Scripts)' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Invision_Power_Board_(Scripts)' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:IPB Scripts' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'IPB_Scripts' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'IPB_Scripts' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:MediaWiki (Hacks Scripts Extensions)' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:MediaWiki_(Hacks_Scripts_Extensions)' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:MediaWiki_(Hacks_Scripts_Extensions)' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:MediaWiki Scripts' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'MediaWiki_Scripts' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'MediaWiki_Scripts' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:FireFox_Add-ons_and_Extensions' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:FireFox_Add-ons_and_Extensions' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:FireFox_Add-ons_and_Extensions' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:FireFox Stuff' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'FireFox_Stuff' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'FireFox_Stuff' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Site_Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Site Map' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Site_Map' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Category:Help_Using_The_Site' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Help_Using_The_Site' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Category:Help_Using_The_Site' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Special:Recentchanges' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:Recentchanges' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Special:Recentchanges' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Recent Changes' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Recent_Changes' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Recent_Changes' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:What AWC Offers' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Useful Site Links' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:What AWC Offers' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'What_AWC_Offers' LIMIT 1 16 Query /* MediaWikiBagOStuff:_doquery */ SELECT value,exptime FROM `objectcache` WHERE keyname='Dabse_Name:messages:Useful Site Links' 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Revision::fetchRow */ SELECT page_namespace,page_title,page_latest,rev_id,rev_page,rev_text_id,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_timestamp,rev_deleted FROM `page`,`revision` WHERE (rev_id=page_latest) AND (page_id=rev_page) AND page_namespace = '8' AND page_title = 'Useful_Site_Links' LIMIT 1 16 Query /* Database::immediateCommit */ COMMIT
Regards, [Hosts Name (removed by me)]
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Rob Church wrote:
Look at http://www.mediawiki.org/wiki/Help:Configuration_settings#Reduction for *some* tips. You might be able to switch off some use of the objectcache through disabling the parser cache (this isn't all that table's used for, but on sites without memcached, it contributes a large proportion of that table).
When you say "disabling the parser cache"; do you mean changing.... $wgParserCacheType = CACHE_ANYTHING; $wgEnableParserCache = true; to $wgParserCacheType = CACHE_NONE; $wgEnableParserCache = false;
And can i asume if i change... $wgMessageCacheType = CACHE_ANYTHING; $wgUseDatabaseMessages = true; to $wgMessageCacheType = CACHE_NONE; $wgUseDatabaseMessages = false;
It would use the lang files rather then the SQL calls ? And by doing that, is the Nav Bar the only thing im gonna loose (which i can hard-code into the lang file) ?
Finaly, is there a way for MediaWiki to tell me what the server load is (i know ive seen other "sites/scripts/templets" do this) so i can stop buggin you here :-) ?
Thanks again... - joe
The linkcache is quite an integral performance saver on large sites, but on smaller ones, it's a bit of a killer. I don't know of a means to switch it off at present.
It *sounds* like you're using the wrong tool for the wrong job, but I'll spare the ranting here (you can always read the mailing list archives for December 2005). Suffice it to say that MediaWiki is developed to be not *too* much of a performance bitch, but it is expected that the server(s) behind it will be able to cope with the load.
Rob Church
On 23/03/06, Joe me@joescove.com wrote:
I just recived a friendly little Email from my host saying they have:
"suspended [my account] for excessive system resource usage due to large quantities of MySQL and PHP traffic coming from the domain and creating high server loads"
Its a personal site im running, not a "traditional wiki", so i would like to turn off some Dbase queries, if possable.
Is it possable for me to turn off the following. LinkCache::addLinkObj MediaWikiBagOStuff:_doquery
I would like to omit any SQL to the 'objectcache' table for now.
Possable ? and more importantly will it help for my situation? I really like using MediaWiki and do not want to move to somthing else.
Thanks for any help...
mediawiki-l@lists.wikimedia.org