Site Shut Down Due CPU Seconds Overage From Slow MySQL queries
-
I have my site hosted with SiteGround. On Friday they shut my site down due to an overage on my CPU seconds. After reading on the net I see this is a common issue with them. They restored my site and gave me instructions on how to fix the issue. I do not have a high traffic site. I optimized my site, use WP smush for images and use their Supercacher plugin.
Well it happened again today. They say it is because of slow MySQL queries being generated for my account. They have given me a list of example queries but I cannot make heads or tails out of it. I am not technical and have no idea how to fix this issue. I understand a plugin could be to blame. Could someone please look at my queries and see if there is any clue in there as to what the problem is?
=== TOP 10 of 13 (total) Slow Queries for the past 24 hours ========== 1. Executed 19h 42m 30s ago for 11.804435 sec on Database --> lisascr4_wp561 Date: 2016-05-22 19:15:51 Query_time: 11.804435 Rows_examined: 1: Rows_sent 0 Lock_time: 0.000101 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 DELETE FROM <code>xcq_options</code> WHERE <code>option_name</code> = 'photocrati_cache_tracker'; ------------------------------------------------------------------------------------------------- 2. Executed 19h 42m 30s ago for 11.538856 sec on Database --> lisascr4_wp561 Date: 2016-05-22 19:15:51 Query_time: 11.538856 Rows_examined: 0: Rows_sent 0 Lock_time: 0.061236 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 SELECT option_value FROM xcq_options WHERE option_name = '_wp_session_f4d4eae6a0be3cf965ec6ddbadd9afbb' LIMIT 1; ------------------------------------------------------------------------------------------------- 3. Executed 5h 56m 38s ago for 2.928881 sec on Database --> lisascr4_wp561 Date: 2016-05-23 09:01:43 Query_time: 2.928881 Rows_examined: 38: Rows_sent 0 Lock_time: 0.000068 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 UPDATE <code>xcq_postmeta</code> SET <code>meta_value</code> = '1464012100:1' WHERE <code>post_id</code> = 9702 AND <code>meta_key</code> = '_edit_lock'; ------------------------------------------------------------------------------------------------- 4. Executed 5h 56m 38s ago for 2.80052 sec on Database --> Unknown (NOT FOUND / DELETED) Date: 2016-05-23 09:01:43 Query_time: 2.800520 Rows_examined: 1: Rows_sent 0 Lock_time: 0.000082 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 UPDATE xcq_redirects SET count = count + 1 WHERE id = 578; ------------------------------------------------------------------------------------------------ 5. Executed 5h 56m 38s ago for 2.660464 sec on Database --> lisascr4_wp561 Date: 2016-05-23 09:01:43 Query_time: 2.660464 Rows_examined: 1: Rows_sent 0 Lock_time: 0.000084 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 UPDATE <code>xcq_options</code> SET <code>option_value</code> = '1' WHERE <code>option_name</code> = 'ninja_forms_load_deprecated'; ------------------------------------------------------------------------------------------------ 6. Executed 5h 56m 38s ago for 2.574145 sec on Database --> lisascr4_wp561 Date: 2016-05-23 09:01:43 Query_time: 2.574145 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050195 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 SELECT option_value FROM xcq_options WHERE option_name = '_wp_session_6aa62d06f0f60c7b4ea08a00506e2d5f' LIMIT 1; ------------------------------------------------------------------------------------------------ 7. Executed 11h 33m 9s ago for 1.753048 sec on Database --> lisascr4_wp561 Date: 2016-05-23 03:25:12 Query_time: 1.753048 Rows_examined: 1: Rows_sent 0 Lock_time: 0.050922 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 SELECT id, code FROM xcq_snippets WHERE active=1 AND (scope=0 OR scope=2); ------------------------------------------------------------------------------------------------ 8. Executed 3h 58m 10s ago for 1.559251 sec on Database --> lisascr4_wp561 Date: 2016-05-23 11:00:11 Query_time: 1.559251 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050147 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 SELECT option_value FROM xcq_options WHERE option_name = '_wp_session_f0d9fb74341be8e2a6ae8f2b2c5e1de2' LIMIT 1; ------------------------------------------------------------------------------------------------ 9. Executed 3h 58m 10s ago for 1.362466 sec on Database --> lisascr4_wp561 Date: 2016-05-23 11:00:11 Query_time: 1.362466 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050314 # Schema: lisascr4_wp561 Last_errno: 0 Killed: 0 SELECT option_value FROM xcq_options WHERE option_name = '_wp_session_f5f86c99d71aca1ee0acd754a1e30f00' LIMIT 1; ------------------------------------------------------------------------------------------------ 10. Executed 19h 42m 29s ago for 1.293205 sec on Database --> lisascr4_wp561 Date: 2016-05-22 19:15:52 Query_time: 1.293205 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000334
My site is https://www.LisasCreativeDesigns.com . They have temporarily activated my site and told me to hire a developer. I have never had this issue before. The only thing I did was to import my other wordpress site into this one within the past month. Both of which were hosted on my same account. Site #2 was located in a subdirectory. I am not sure if that caused this issue.
Thanks.
- The topic ‘Site Shut Down Due CPU Seconds Overage From Slow MySQL queries’ is closed to new replies.