High CPU usage
-
hello I have problem with the plugin as my hosting provider told me website still spawns a lot of slow MySQL queries, I am providing examples bellow: 1. Executed 2h 37m 16s ago for 9.776388 sec on Database --> dbtw0iezfc7zoz Date: 2023-10-10 02:16:20 Query_time: 9.776388 Rows_examined: 10922: Rows_sent 0 Lock_time: 0.001174 Query_chars: 19137 SELECT * FROM nhr_acoofm_items WHERE 0 OR source_path LIKE "%wc-blocks-vendors-style.css" OR path LIKE "%wc-blocks-vendors-style.css" OR extra_info LIKE "%wc-blocks-vendors-style.css%" OR source_path LIKE "%wc-all-blocks-style.css" OR path LIKE "%wc- ...... path LIKE "%hiddenSidebar.min.js" OR path LIKE "%hiddenSidebar.min.js" OR extra_info LIKE "%hiddenSidebar.min.js%" OR source_path LIKE "%stickySidebarBtn.min.js" OR path LIKE "%stickySidebarBtn.min.js" OR extra_info LIKE "%stickySidebarBtn.min.js%"; ------------------------------------------------------------------------------------------------------------------- 2. Executed 2h 47m 4s ago for 9.420835 sec on Database --> dbtw0iezfc7zoz Date: 2023-10-10 02:06:32 Query_time: 9.420835 Rows_examined: 10922: Rows_sent 0 Lock_time: 0.001351 Query_chars: 19333 SELECT * FROM nhr_acoofm_items WHERE 0 OR source_path LIKE "%wc-blocks-vendors-style.css" OR path LIKE "%wc-blocks-vendors-style.css" OR extra_info LIKE "%wc-blocks-vendors-style.css%" OR source_path LIKE "%wc-all-blocks-style.css" OR path LIKE "%wc- ...... path LIKE "%hiddenSidebar.min.js" OR path LIKE "%hiddenSidebar.min.js" OR extra_info LIKE "%hiddenSidebar.min.js%" OR source_path LIKE "%stickySidebarBtn.min.js" OR path LIKE "%stickySidebarBtn.min.js" OR extra_info LIKE "%stickySidebarBtn.min.js%"; ------------------------------------------------------------------------------------------------------------------- 3. Executed 2h 7m 35s ago for 9.338537 sec on Database --> dbtw0iezfc7zoz Date: 2023-10-10 02:46:01 Query_time: 9.338537 Rows_examined: 10922: Rows_sent 3 Lock_time: 0.001312 Query_chars: 20906 SELECT * FROM nhr_acoofm_items WHERE 0 OR source_path LIKE "%wc-blocks-vendors-style.css" OR path LIKE "%wc-blocks-vendors-style.css" OR extra_info LIKE "%wc-blocks-vendors-style.css%" OR source_path LIKE "%wc-all-blocks-style.css" OR path LIKE "%wc- ...... path LIKE "%hiddenSidebar.min.js" OR path LIKE "%hiddenSidebar.min.js" OR extra_info LIKE "%hiddenSidebar.min.js%" OR source_path LIKE "%stickySidebarBtn.min.js" OR path LIKE "%stickySidebarBtn.min.js" OR extra_info LIKE "%stickySidebarBtn.min.js%"; ------------------------------------------------------------------------------------------------------------------- 4. Executed 2h 7m 33s ago for 9.235001 sec on Database --> dbtw0iezfc7zoz Date: 2023-10-10 02:46:03 Query_time: 9.235001 Rows_examined: 10922: Rows_sent 3 Lock_time: 0.001051 Query_chars: 20778 SELECT * FROM nhr_acoofm_items WHERE 0 OR source_path LIKE "%wc-blocks-vendors-style.css" OR path LIKE "%wc-blocks-vendors-style.css" OR extra_info LIKE "%wc-blocks-vendors-style.css%" OR source_path LIKE "%wc-all-blocks-style.css" OR path LIKE "%wc- ...... path LIKE "%hiddenSidebar.min.js" OR path LIKE "%hiddenSidebar.min.js" OR extra_info LIKE "%hiddenSidebar.min.js%" OR source_path LIKE "%stickySidebarBtn.min.js" OR path LIKE "%stickySidebarBtn.min.js" OR extra_info LIKE "%stickySidebarBtn.min.js%"; ------------------------------------------------------------------------------------------------------------------- 5. Executed 2h 47m 6s ago for 9.158031 sec on Database --> dbtw0iezfc7zoz Date: 2023-10-10 02:06:30 Query_time: 9.158031 Rows_examined: 10922: Rows_sent 0 Lock_time: 0.001353 Query_chars: 19461 SELECT * FROM nhr_acoofm_items WHERE 0 OR source_path LIKE "%wc-blocks-vendors-style.css" OR path LIKE "%wc-blocks-vendors-style.css" OR extra_info LIKE "%wc-blocks-vendors-style.css%" OR source_path LIKE "%wc-all-blocks-style.css" OR path LIKE "%wc- ...... path LIKE "%hiddenSidebar.min.js" OR path LIKE "%hiddenSidebar.min.js" OR extra_info LIKE "%hiddenSidebar.min.js%" OR source_path LIKE "%stickySidebarBtn.min.js" OR path LIKE "%stickySidebarBtn.min.js" OR extra_info LIKE "%stickySidebarBtn.min.js%"; ------------------------------------------------------------------------------------------------------------------- 6. Executed 2h 52m 51s ago for 8.888901 sec on Database --> dbtw0iezfc7zoz Date: 2023-10-10 02:00:45 Query_time: 8.888901 Rows_examined: 10922: Rows_sent 0 Lock_time: 0.001226 Query_chars: 19360 SELECT * FROM nhr_acoofm_items WHERE 0 OR source_path LIKE "%wc-blocks-vendors-style.css" OR path LIKE "%wc-blocks-vendors-style.css" OR extra_info LIKE "%wc-blocks-vendors-style.css%" OR source_path LIKE "%wc-all-blocks-style.css" OR path LIKE "%wc- ...... path LIKE "%hiddenSidebar.min.js" OR path LIKE "%hiddenSidebar.min.js" OR extra_info LIKE "%hiddenSidebar.min.js%" OR source_path LIKE "%stickySidebarBtn.min.js" OR path LIKE "%stickySidebarBtn.min.js" OR extra_info LIKE "%stickySidebarBtn.min.js%"; ------------------------------------------------------------------------------------------------------------------- Which combined with a spike of the access towards your website exceeded the CPU usage quota again. Please review the above provided MySQL queries and provide them to your website developer for optimization.
https://www.pazarly.com
If you can help me with that issue ?
Regards,
- The topic ‘High CPU usage’ is closed to new replies.