[devtalk] mediawiki - database - text table

[joseph-harris]

I am going round in ever decreasing circles trying to find 
where a great chunk of hosting space is being used. The 
figures show around 350MB in the database, and that sort of 
figure in the wiki _text table. I have a forum in the db 
too, but no use of it yet, and no indication of taking much 
space.

This is what mediawiki says on its db layout 'The text table 
holds the wikitext of the individual page revisions.' Which 
seems clear, but there is no sign of that text.

I expected to find the text content of the 8000+ lines 
available through MySQLAdmin. But nothing seems to get me to 
the text content. The space used is quite ridiculous for the 
actual content, but I can proabbly only discover the culprit 
by seeing the text content via the db.

If I click the text edit symbol I get a table that needs 
filling in with Field [old_id, old_text, old_flags]; type; 
function; null; and value, with just the id value filled.

Even so my glance down the space used by the  lines 
indicates individual sizes that cannot add to 350MB or so. I 
had found porn links on the main page, but no appearance of 
interference anywhere else - though I may not know where to 
look!

I have no hair left to tear out, so any suggestions will be 
welcome ;-).

Joseph
Joseph Harris  -  Debt Control Man
author: Control Your Debt Crisis on Your Own Terms
blog: http://debtcontrolman.wordpress.com
site: http://www.controlyourdebtcrisis.co.uk
wiki: http://www.controlyourdebtcrisis.co.uk/debtwiki/
ezine: 
debtcrisisnews-subscribe at lists.controlyourdebtcrisis.co.uk