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(a)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(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l