Hi. I have a wordpress blog with almost 65000 posts, 41500 photos and 3200 comments. Link of the site is here : http://bit.ly/hzLRFB . The problem is that my database’s size is almost 520 mb . I optimised it and deleted post revisions and orphan options. The only plugins that i have and make database registers are : seo by yoast – yet another related posts.
So in generally the size of tables is :
posts : 311,4 MB
post meta : 149,9 MB
comments : 1,2 MB
hook_list : 9,5 MB
terms : 2,2 MB
term-relationships : 7,5 MB
yarpp : 41 MB
options : 243 KB
term_taxonomy : 1,1 MB
I use Cloudflare and Cdn service together.
So sometimes i receive for instance : Database error connection … for 2-3 sec only, and i think there is problem… I have read something about patches. Is it worth trying? Please help me…
- The topic ‘Database is large. How to make it smaller’ is closed to new replies.