One thing that can be useful is to check which tables are big. If it's
logging table, try disabling RCPatrolling (or upgrading to 1.32 so it
doesn't log autopatrol actions). If it's revision table, upgrading might
help with actor table migration and then you just set it to "write new/read
new" so it writes on the normalized tables. Same goes for change_tag table.
HTH
Best
On Thu, Dec 27, 2018 at 11:19 PM Brian Wolff <bawolff(a)gmail.com> wrote:
I agree with John, it would be interesting to know the
sizes of the various
tables. While 1 GB is a relatively small limit for a DB, its still a lot of
space for a small wiki (I think you can find how big different tables are
via
https://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tab…
).
As others have said, the object cache table can generally be purged quite
regularly if its becoming too big, if its repeatedly growing too fast,
figuring out what types of keys (keyname) are taking up most of the room
can be suggestive of what config changes could be made (Of course, best
config change would be to use a different cache backend)
The other table that is commonly large is the text table. If this is big,
it can be compressed. First and foremost by putting $wgCompressRevisions =
true; in LocalSettings.php (which will make all newly saved pages
compressed). You can also run compressOld.php in maintenance to compress
old revisions (This script can concat old pages which optimizes compression
better then what $wgCompressRevisions can do by itself, so it makes sense
to run it even if you started with $wgCompressRevisions = true from the get
go). See
https://www.mediawiki.org/wiki/Manual:CompressOld.php for more
info (Generally it is a good idea to take a backup before messing with old
revisions)
--
Brian
On Thu, Dec 27, 2018 at 6:52 PM John <phoenixoverride(a)gmail.com> wrote:
Might also look at what is using your space and
see if it can be
optimized.
On Thu, Dec 27, 2018 at 12:51 PM Brett Langston <
brett.langston(a)tiscali.co.uk> wrote:
> Thanks for the suggestions. By deleting the cache tables, and the
oldest
entries
from the logging table, I've been able to reduce the size to
below
1GB and get back control of the wiki for now. It
looks like I need to
find
> an ISP with more hosting space in the longer term though.
>
> Cheers,
>
> Brett
>
>
>
>
> -----Original Message-----
> From: MediaWiki-l <mediawiki-l-bounces(a)lists.wikimedia.org> On Behalf
Of
Brett
Langston
Sent: 27 December 2018 10:12
To: 'MediaWiki announcements and site admin list' <
mediawiki-l(a)lists.wikimedia.org>
Subject: [MediaWiki-l] Database exceeds size limit
Hi everyone,
I'm using MW version 1.29.2 on a shared hosting server (PHP 7.2.13 and
MySQL 5.5.60). I've inadvertently exceeded the ISP's 1GB size limit of
the
> database, with the result that I can't make any further changes. The
wiki
> is still up and running, but I can't
edit or delete content, no users
can
log in,
and none of the PHP scripts will run from the maintenance shell
extension. Because it's a shared hosting server, I don't have direct
shell
> access to run PHP scripts.
>
> My ISP has suggested that I reduce the size of the database using
MySQL,
so I can
get it back under the threshold limit, and 'unfreeze'
everything.
In theory I should be able to delete unwanted old
versions of pages in
the
usual way to free up space.
Using MySQL I've emptied the archive table (only 256 kb), but I need to
be
able to clear another 10 Mb or so without
corrupting the database. What
else can I delete safely to avoid crashing the wiki?
Thanks for any suggestions,
Brett
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l