I am blogging on TechShali since May 2009. It’s more than 40 moths. Since then I have installed, activated, deactivated and deleted hundreds of plugins, and tried about a dozen themes. I have published over 1500 articles and trashed hundreds of them. Still, you can find over one thousand articles. Articles have over 3 million page views. The articles have over 2500 comments. I have blocked hundreds of spamming IP addresses. GASP is blocking hundreds of spam comments daily. About 0.2 million spam comments blocked by Akismet and I have uploaded thousands of pictures and screenshots. You can find definitely a few thousand outgoing links and over 3 dozen redirections and hundreds of URL changes.
Notwithstanding of this all, WordPress database size is only 10MB. After Gzip compression it’s only 2MB. Actually WordPress database size is MySQL database size. I have really optimized the entire database and removed most of the junk.
I am writing this post because I am interested in other user’s wordpress database size. And this is also an awareness post if you have only a hundred posts and database size is over 10MB, then there must a lot of junk.
In database there are only 14 tables and three of them are blank. Once this blog’s DB size was over 50 MB but I had published about 200 posts.
These junk databases adds extra load on your server that makes your blog’s performance dull. And it cases CPU throttling.
What is Junk in your database?
(1) You have deleted a post but the reference to that post is still in database, and all the images attached to that post still are in reference.
(2) You have deleted a plugin but the tables created by this plugin are still in the DB, many rows inserted by this plugin in wp_options is still intact. All the custom fields created by these plugins still available after deleting the plugin.