On Wed, Sep 4, 2013 at 11:47 AM, roger@rogerchrisman.com wrote:

On Wed, Sep 4, 2013 at 10:54 AM, Camponez camponez@gmail.com wrote:

...

Maybe because of cache that is generated.

I notice something similar. After run "update.php" it clear the cache on the database and it went from 800M to 210M. When happened I thought I had lost some data.

Cache _in_ the database? What does MediaWiki 1.20.2 cache in the database?

At the very least localization and parser out of the box. Of course you can configure this stuff to be cached elsewhere if you'd like :)

-Chad

If you don't care about keeping old revisions and deleted revisions around (or are not obligated to keep revision around due to your wiki license), you should probably run these two scripts every so often:

https://www.mediawiki.org/wiki/Manual:DeleteArchivedRevisions.php https://www.mediawiki.org/wiki/Manual:DeleteOldRevisions.php

This can hammer down the size of your database quite a bit if you have many pages with a lot of revisions.

If you have server access, have deleted pictures, and don't care to retrieve them later, you can always permanently delete those to recover some more space.

If you have a copy of PHPMyAdmin running and you uninstalled some extensions that left some database tables with lots of leftover data you never plan to use, you can delete those to free up some more space, though I'd back up your database before doing so.

Date: Wed, 4 Sep 2013 12:18:13 -0700 From: roger@rogerchrisman.com To: mediawiki-l@lists.wikimedia.org Subject: Re: [MediaWiki-l] Database size ballooning?

Are there any maintenance scripts I should routinely run, maybe once a months?

Roger

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Hi,

in case the biggest table in your database is objectcache, you may be suffering from this issue: https://bugzilla.wikimedia.org/show_bug.cgi?id=42094 In such case a good solution is to configure your wiki to use memcache instead of database for cache. See https://www.mediawiki.org/wiki/Memcached for details.

Cheers, Zbynek

On Wed, Sep 4, 2013 at 11:13 PM, Chad innocentkiller@gmail.com wrote:

On Wed, Sep 4, 2013 at 2:09 PM, Arcane 21 arcane@live.com wrote:

...

If you have a copy of PHPMyAdmin running and you uninstalled some extensions that left some database tables with lots of leftover data you never plan to use, you can delete those to free up some more space,

though

...

I'd back up your database before doing so.

If you have a copy of PhpMyAdmin installed you should uninstall it immediately as it is a horrible security risk to any production server it is on.

-Chad _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

I fixed it.

Per Camponez's suggestion, I ran update.php on a test version of the site and that fixed the bloat there. So I ran update.php on production Teflpedia site also. It cleared the objectcache table, which had grown to 743 MB, back to zero which brings the database back down to expected size. The database is now 148 MB instead of 933 MB. I think I will routinely run update.php before backing up the database from now on and that should take care of it.

I suspect this bit in LocalSettings.php, which sets $wgMainCacheType to CACHE_DB, may have started this cache bloat building back in February 2012:

## Shared memory settings # Roger 21 Feb 2012 comments out original line below to try another value # so that 3rd badlogin will trigger ConfirmEdit captcha #$wgMainCacheType = CACHE_NONE; $wgMainCacheType = CACHE_DB; // yea! badlogin trigger works with this $wgMemCachedServers = array();

It appears that using the database as a chache works fine, as long as I clear the cache from time to time. Running update.php once a month as part of my backup routine will do the job I think. Unless someone points me at a better way.

Thank you everyone for your replies and tips!

Once again, Mediawiki-l shines.

Roger :-)

It might be useful to add that I started a thread about this in the MathJax discussion group:

https://groups.google.com/forum/#!topic/mathjax-users/ZSVVy0Gs0nY

-- Dave

On 2013-09-06 19:29, me@x2592.com wrote:

Hi,

I have set-up a wiki at http://wiki.x2592.com and installed (among other things) the MathJax extension (https://www.mediawiki.org/wiki/Extension:MathJax). (I originally tried with the Math extension, but did not manage to get it working, despite the fact that all the prerequisites seem to be met.)

MathJax is displaying Tex-encoded equations OK, but not MathML-encoded equations. The greater-than and less-than characters in MathML tags seem to be being converted to the HTML entities &ls and &gt.

I'm working with a local git checkout of the MathJax package (although the results were identical using their CDN-delivered version), and a one-week-old git checkout of MediaWiki and the extensions repository. The MW MathJax is the version available as of 7 days ago, too.

The invocation string used to call MathJax is:

http://wiki.x2592.com/MathJax/MathJax.js?config=TeX-AMS-MML_HTMLorMML

Examples of equations and other supported content can be seen on the main page of http://wiki.x2592.com, showing the problem, and the page is currently enabled for editing for anyone that feels like dabbling.

Is anyone able to help me troubleshoot this and get MathML displaying OK?

Many TIA if so, :-)

-- Dave