I'm having a terrible issue that it's making me mad for almost two weeks.
Since one month, one of my sites was having more and more CPU and RAM load, so i moved that domain to another server to leave it lonely and make it more comfortable. But what was just simple overload, it transformed in a dramatically high load, and i tried three dedicated servers.
It's not the cache plugin, it's not the theme, i found that the CPU usage raised to 100% when after installing a fresh wordpress installation, i restored the database.
Just when i upload the posts table and make the permalinks options for htaccess, is when i felt the high load in the server.
I don't know if this has anything to do with some permalinks configuration that it's incompatible after recovering the database in a new installation.
If i'm using the predetermined configuracion, like http://www.site.com/?p=123
the server is fine
But if i use the configuration i used since always for that blog, that is
the server gets crazy and gets a lot of load, the CPU usage raises till 100% and the entire WordPress and server gets stuck.
I'm using the /%postname%/%category%/ configuration for SEO ranking, and i don't want to loose all the old links directed to my site if i change it.
¿Someone can help me telling me what it could be? I searched days and days, and tried everything, but couldn't find any solution.
Thanks in advance.