Does this occur with default unedited theme and no plugins activated?
Any site updates/modifications ‘recently’?
Please also review:
http://codex.ww.wp.xz.cn/Forum_Welcome#Include_as_much_information_as_possible
Thread Starter
akis
(@akis)
Thank your for your reply and sorry for the poor details.
I have deactivated the plugins and tested it using the Twenty Twelve theme but nothing changed. It looks to me like a database issue, it’s a bit weird that the CPU goes to 100% just by listing posts in wp-admin (assuming that I have blocked all other access to the server).
I’ve cleaned up wp_options as much as I could, deleted post revisions and some junk from wp_postmeta too.. but can these cause such a huge resource usage? Any ideas how to debug this on a shared hosting?
Who is the host? Some are better than others. With 10K posts and 15K tags, you’re pushing the limits of a cheap, shared host. Probably time for a VPS.