[Mediawiki-l] Cutting back on SQL queries, mainly 'objectcache' ...

Rob Church robchur at gmail.com
Thu Mar 23 07:18:59 UTC 2006


Look at http://www.mediawiki.org/wiki/Help:Configuration_settings#Reduction
for *some* tips. You might be able to switch off some use of the
objectcache through disabling the parser cache (this isn't all that
table's used for, but on sites without memcached, it contributes a
large proportion of that table).

The linkcache is quite an integral performance saver on large sites,
but on smaller ones, it's a bit of a killer. I don't know of a means
to switch it off at present.

It *sounds* like you're using the wrong tool for the wrong job, but
I'll spare the ranting here (you can always read the mailing list
archives for December 2005). Suffice it to say that MediaWiki is
developed to be not *too* much of a performance bitch, but it is
expected that the server(s) behind it will be able to cope with the
load.


Rob Church

On 23/03/06, Joe <me at 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 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)]
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>



More information about the MediaWiki-l mailing list