I’ve just been evaluating disk space usage for this blog, and The Dublin Blog and was wondering where the hell all my disk space was going to. Turns out that a plugin that I was using on both wp-shortstat was the culprit, gathering loads of data that I hardly ever use into my databases. Apparently, it’s a known bug in the script, and a newer version has been coded to use about half as much disk space.

There is also a method of shrinking current disk usage by about half if you’re interested:

UPDATE ‘wp_ss_stats’ SET ‘language’ = ‘’ WHERE ‘language’ = ‘empty’
UPDATE ‘wp_ss_stats’ SET ‘browser’ = ‘’ WHERE ‘browser’ = ‘Indeterminable’
UPDATE ‘wp_ss_stats’ SET ‘version’ = ‘’ WHERE ‘version’ = ‘Indeterminable’
UPDATE ‘wp_ss_stats’ SET ‘platform’ = ‘’ WHERE ‘platform’ = ‘Indeterminable’
ALTER TABLE ‘wp_ss_stats’ CHANGE ‘country’ ‘country’ CHAR( 2 ) NOT NULL
ALTER TABLE ‘wp_ss_stats’ DROP ‘user_agent’

Personally, I just found it easier to empty the tables as I hardly ever use the stats anyways and I’ve now got a whole load more space to boot!