Hello,
I’ve tried migrating from GoDaddy to several different hosting companies (Siteground, Knownhost, Cloudways) to try and get better pricing on SSL, and I get the same problem every time: CPU use goes through the roof, eventually crippling the site. It goes away when I point my DNS back to GoDaddy. Migration on Siteground and Knownhost was done by their “professional” option where they handle the migration, Cloudways by Blogvault.
My question: is this something inside of X as they say below “not well written scripts,” or is this something else? (I don’t have deep admin knowledge at all.)
Any insight greatly appreciated.
From Siteground server admin:
CAUSE OF HIGH RESOURCE CONSUMPTION:
We have conducted a detailed investigation and it turned out that your WordPress executes slow queries towards its database, which eventually hogs the server. The server tries to execute your slow queries while putting other processes in the queue until some memory is freed. While they are waiting however, they stack up and cause further problems. There can be many reasons for slow database queries, but the following 3 are the most common ones:
- Large database
- Not well written scripts
- Large number of internal links that query the database directly.
Here are some of the database queries that are slow and consume a lot of server resources:
| 3159048 | pfmentum_wp12 | localhost | pfmentum_wp12 | Query | 228 | Sending data | SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON wp_posts.ID | 0 | 0 |
| 3159265 | pfmentum_wp12 | localhost | pfmentum_wp12 | Query | 175 | Sending data | SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON wp_posts.ID | 0 | 0 |
| 3159345 | pfmentum_wp12 | localhost | pfmentum_wp12 | Query | 156 | Sending data | SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON wp_posts.ID | 0 | 0 |