Is 170 mb of database is too large just for 350 posts?

I'm using wordpress and there are only about 350 posts. After cleaning all post revisions, spam comments and optimizing database, its 170 mb. When I check phpmyadmin, comment meta is 152 mb and i have 700 comments. Is it too large? How can I reduce the size?

Answers


optimizing is not cleaning, optimizing is simply rearranging the data for faster access. you need to remove redundant data from the mysql database. here are 7 mysql query to clean up your bloated database.

http://www.geckoandfly.com/12815/10-must-use-sql-queries-clean-wordpress-bloated-mysql-database/


The issue is because the SPAM comments are not deleted permanently. Delete the spam comments permanently and the comment meta table size will come down to few kbs.


Hy,

In the past I had the same problem, this article helped me: http://thecustomizewindows.com/2011/12/reduce-wp_commentmeta-table-database-size-in-wordpress/

Good luck! :)


Need Your Help

How to edit a particular line of the csv file using PHP?

php csv

I have a PHP script that allow users to upload their data. The first line of the csv file are the headers (fname, lname, age, address, email).

How to make an unboxed array of floats I can get a Ptr to

c arrays opengl haskell unboxing

I am trying to do some work with HopenGL and I need a Ptr that points to a array of floats. From what I have read uarray and storableArray seem to be the way to go, in some combination some way.