I have a very small wordpress site that has about 15 posts and 6 pages, all plugins disabled, everything else untouched. As soon as I connect it to the database (by entering the right info in the config.php file) it uses 100% of my server's cpu.
Things I have tested:
I have deleted the plugins from the site and deleted the posts and pages one by one, even with no content on the site it still uses 100%
I have exported the site, made a new database and imported it, connected the site to the new database - it uses 100% again.
I have made a fresh wordpress install and connected it to the database - 100%.
I have a lot of other sites on the server, the moment I disconnect this site (by removing the config.php) it goes to 2% load, there is no heavy traffic and there is no problem with anything else on the server
I tried looking at the database in phpmyadmin and running repair and optimise commands, but no effect.
I am unable to get more info about the running processes. I asked my web host guys who first said that xmlrpc.php was running a lot of processes but after I disabled (and then deleted) that file I was told that 'There are several processes running the following: index.php' which doesn't really help I think.
My next plan is to copy/paste the posts one by one into a clean install, but does anyone have any suggestions before that? I can't provide a link as I have to take the site offline as it affects the other sites on my server.