Right now, my Movable Type database occupies well over half a gigabyte of space on my host’s web server – 550 MB, to be exact. Obviously, 6 years of blogging with all of its comments and entries does result in a lot of data, but can it really be this much?
The thing is, not that long ago the database was only around 50 MB – 11 times smaller. A tweet by Gregor was what prompted me to look – he’s a WordPress user and the auto-save and post revision functions that have been added recently have contributed to “massive bloat fail”, in his words. And it looks like Movable Type has the same problem – here’s a pie chart to demonstrate:
That big lump of hideous green is ‘session data’, which holds a variety of things but namely auto-saves of entries and templates. That alone is taking up 500 MB of data.
The problem is that MT doesn’t seem to have a ‘clean up session data’ option anywhere, nor did a cursory Google search turn up much information about it. I’d like to know if I can get rid of it, as right now more than a quarter of my hosting plan is now set aside to this session data. I’d be also interested to hear if any WordPress users are in the same boat since it too has this problem.