[Mediawiki-l] Cutting back on SQL queries, mainly 'objectcache' ...
Joe
me at joescove.com
Thu Mar 23 06:16:09 UTC 2006
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 at 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)]
More information about the MediaWiki-l
mailing list