My site has been throttling for the past two weeks and Bluehost kept insisting that it is an issue with my plugins or the theme I am using.
I followed their advice and some other people's advice on the web but so far, no solution is in sight.
Okay, these are the things I did:
1. Repair database
2. Disabled all plugins
3. Installed WP Super Cache
4. Installed WP Throttle plugin
5. Increase the memory on php.ini and insert "define('WP_MEMORY_LIMIT', '64M');" into the WP-config.php file
Eventually, when pressed further, they told me that my index.php page is sending to many queries, causing the high cpu usage (even though they cannot explain why it is so now and not previously).
This is Bluehost reply:
".. your user has maxed out the 15 connections but has done so by opening 14 connections to the server and then putting those connections to sleep. This effectively means that your site is opening connections, then telling those connections to wait around for further instructions while simply allowing the connections to linger and do nothing but take up space. This is often the result of a poorly programmed plugin, or a combination of plugins which will somehow result in a failure to properly close opened MySQL connections. A typical MySQL connection will not stay open longer than a fraction of a fraction of second. The fact that you have so many connections being opened and left "sleeping" is indicative of an issue in the site, and is something that you will need to troubleshoot in your code before this issue is likely to be resolved."
(see their screenshot attached)
What shall I do now? My site has been down for 2 weeks and this has been a nightmare for me.
Should I hire a php expert to resolve this? How much will I have to pay?