MySQL database getting quite large

  • I am running WP 2.6 and I noticed my database is getting quite large. I have a 100 MB database with 1&1, but I am already at 9 MB and the blog has 202 posts. I am the admin for a church website, and there will be no shortage of posts to come. Is this the normal database size for a site with 202 posts? I was looking through some of the other topics and a lot have said that is pretty large. Any help would be appreciated

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter mrcardinal

    (@mrcardinal)

    I installed WP-DBManager 2.20 on my WP site. What does it mean to empty/drop a table? Is all data lost when that is done?

    Yes the data would be lost and the data for that table would no longer be stored which would cause functionality issues as well.

    Thread Starter mrcardinal

    (@mrcardinal)

    What is the difference between dropping a table and emptying a table? Am I going to run out of space on my site once I reach 2,200 posts (considering 200 takes me to 9 MB)?

    Dropping a table means basically that you’re deleting it. Emptying it means you’d get rid of the information in the table. Getting rid of the info in the tables would mess up your install so don’t do that. As for space issues, I’m not sure exactly how it works. Probably there’s some way you can optimize the database to hold more than that or maybe there’s a reason why only 200 posts are taking up 9 MB of space. Sorry, someone who knows more about that kinda stuff will have to help you ??

    Thread Starter mrcardinal

    (@mrcardinal)

    using that plugin i downloaded- it says wp_posts in the database has 2,222 records. i read somewhere else that WP 2.6 counts revisions- is there anyway to delete those old revisions and just keep the current versions? i have made a lot of revisions to all the posts. it also says data usage is 6.1 MB and index usage is 2.1 MB. any idea what those numbers mean and which is actually being consumed in my DB? 6.1 MB or 2.1 MB?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘MySQL database getting quite large’ is closed to new replies.