hello, i have a question and need your help. i have built up an Amazon autoblog using wordpress. i checked my MySQL database usage for the autoblog,it is very high about 826MB. what cause this situation and how to reduce the usage of database? thank you.
If there is a lot of data in there being autoblogged, you aren't going to be able to reduce that size. How many posts have been made?
hello, there are thousands posts.i already disable and delete the plugins for autoblog but the MySQL database usage still high and no change.the hosting provider told me that i must resolved this issue unless my hosting account will be suspended.
Oh, how cool... Follow the link in my signature. I specifically wrote the (free) TIEtools plugin to manage this. It will expire old posts, expire the images (but keep the posts), handle your log files and spot (simple) duplicates. Runs automatically on wp-cron, so you just fire and forget. I use it on all my sites with news feeds or other automated stuff - works a treat (of course, since I wrote it for what I needed). I would also suggest installing the "Optimize database after deleting revisions" plugin by CAGE Web Design (also free, on WP.org). Run an optimisation every few days to keep things clean and tidy on the DB side. Oh, and set your trash days to 1 (http://codex.wordpress.org/Editing_wp-config.php#Empty_Trash), so the old posts get thrown out every couple of days. Hope it helps!!
Please do let me know if it's useful. About 800 downloads (in the old and new versions) and it's only had one rating on WP, so I don't even know if site owners think it's worthwhile. Would appreciate any thoughts.
I would also recommend you to use a cache system (there should be such plugins for wordpress). This will heavily reduce the number of database calls (reducing the mysql server load) and it will also increase the page loading speed of your site.