Cutting back on SQL queries, mainly 'objectcache' ...

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Cutting back on SQL queries, mainly 'objectcache' ...

Joe-56
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
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Cutting back on SQL queries, mainly 'objectcache' ...

Rob Church
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 <[hidden email]> 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
> [hidden email]
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Cutting back on SQL queries, mainly 'objectcache' ...

Joe-56
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 <[hidden email]> 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 mailing list
[hidden email]
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l