• 
    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.