[Mediawiki-l] Cutting back on SQL queries, mainly 'objectcache' ...
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 :-) ?
>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
>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.
>>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