Before doing any of this, make a backup!
First off, clean up all your posts revisions in SQL:
DELETE FROM wp_posts WHERE post_type = "revision";
Second disable the whole revision system. If space is THAT monitored, you’ll need this in your wp-config.php file:
/** Turn off Post Revisions without a plugin **/
define('WP_POST_REVISIONS', false);
/** Empty Trash Automatically **/
define('EMPTY_TRASH_DAYS', 5 );
My DB is only 17.1 megs (the other is 20) and I’ve had both blogs for a long time AND they’re well used. So you SHOULD be able to keep it under 50 just by doing that.
How many posts are we talking about? How many plugins? WHICH plugins? Some of them are less friendly to DB space than others.
You CAN split WP over DBs, but it’s not easy, so if we can avoid it…
Hey Ipstenu,
Thanks buddy..
but unfortunately, if my site is too big and can’t work this system then is there any procedure to Split WP between two or more DBs? any plugin? or something else..
I am very thankful to you. if you give me the more information.
Thanks
There is, but again, how many posts are we talking about? How many plugins? WHICH plugins? Some of them are less friendly to DB space than others.
How big ARE you, really, once you clean out revisions and such? Because THAT is a benchmark you really NEED to know before you go further. You need to sort out how much space you’re using, get a rough idea how long it takes you to use that much, and then you’ll have an idea how to scale.
http://ww.wp.xz.cn/extend/plugins/shardb/ and http://ww.wp.xz.cn/extend/plugins/hyperdb/ are the two plugins I know for this one. but BEFORE you just use ’em, you really should clean up first 🙂 It’s the same idea as throwing out everything you don’t need before you move 😉
Thanks thanks thanks alot buddy… one more and last question…
where should i paste this code in wp-config.php?
/** Turn off Post Revisions without a plugin **/
define('WP_POST_REVISIONS', false);
/** Empty Trash Automatically **/
define('EMPTY_TRASH_DAYS', 5 );
last on the page or something middle etc?
Middle. Above the section that says ‘Stop Editing Here’.
I put it right below where the debug line is.
