DjMagra’s stuff ‘n’ stuff

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!