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

Joe me at joescove.com
Thu Mar 23 10:34:23 UTC 2006

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;
$wgParserCacheType = CACHE_NONE;
$wgEnableParserCache = false;

And can i asume if i change...
$wgMessageCacheType = CACHE_ANYTHING;
$wgUseDatabaseMessages = true;
$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
>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...

More information about the MediaWiki-l mailing list