Hey all,
I have a moderate blog, I post a couple times a year, comments off.
But my DB is clocking in at 885mb - which is bloody insane.
I've nuked the spam, activity logs, and I still have a ginormous DB.
How do I get this thing down to a reasonable size?
Reported on Movable Type 4.3
Hi Marcus,
Depending on how complex your templates are, movable type would run more or less complicated queries which bring the mysql usage to a certain level.
Kind Regards,
Mihai Bocsaru
----------------------------------
Daily Movable Type Consultant
Web Development
Movable Type Consulting
Six Apart Partner
http://www.pro-it-service.com/
----------------------------------
Movable Type Demo
http://www.movabletypedemo.org/
Mihai, he's worried about file size, not CPU.
Marcus, this depends on the DB engine, for example InnpDB will not shrink the size of the actual files on disk even when you get rid of data and it's not necessarily a problem. But if that's really a concern, once you have got rid of useless data (you can also check if you have backup templates that you can delete) you can optimize your database (phpMyAdmin or OPTIMIZE TABLE directly in SQL)
See: http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-storage-layout.html
Francois, I was wondering if he is referring to the size of the DB or the CPU.
I thought that if he would refer to the size, he might be aware of the fact that he must optimize his tables ;)