• Resolved prokreeger

    (@prokreeger)


    Hello,

    I have an issue with a high CPU load. My hosting provider said next: I checked the recent usage on your site and I see that the spikes are related to CPU Seconds. This means that there are processes which run for abnormally long on your account.

    Based on our experience this happens because of not well-optimized database queries. The log with slow MySQL queries shows this:

    1. Executed 13m 49s ago for 1.186057 sec on Database --> dbrg6unvzxv39b 
    Date: 2021-08-16 10:02:55 Query_time: 1.186057 Rows_examined: 86052: Rows_sent 0 Lock_time: 0.000063 Query_chars: 79
    INSERT <code>ne0t_spbc_firewall_data_temp</code> SELECT * FROM <code>ne0t_spbc_firewall_data</code>; 
    -------------------------------------------------------------------------------------------------------------------
     2. Executed 12h 38m 41s ago for 1.084653 sec on Database --> dbrg6unvzxv39b 
    Date: 2021-08-15 21:38:03 Query_time: 1.084653 Rows_examined: 85306: Rows_sent 0 Lock_time: 0.000120 Query_chars: 79
    INSERT <code>ne0t_spbc_firewall_data_temp</code> SELECT * FROM <code>ne0t_spbc_firewall_data</code>;

    Additionally, the php_errorlog file in the public_html folder of your account has the following entries:

    [07-Aug-2021 12:49:52 UTC] WordPress-Datenbank-Fehler Table 'dbrg6unvzxv39b.ne0t_cleantalk_sfw' doesn't exist für Abfrage SELECT
    				network, mask, status, source
    				FROM ne0t_cleantalk_sfw
    				WHERE network IN (1107296256,1115684864,1119879168,1121976320,1123024896,1123549184,1123614720,1123631104,1123631616,1123631744,1123631808,1123631824,1123631825)
    				AND	network = 1123631825 & mask 
    				AND 4044  
    				ORDER BY status DESC von require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/cleantalk-spam-protect/cleantalk.php'), apbct_sfw__check, Cleantalk\Common\Firewall->run, Cleantalk\ApbctWP\Firewall\SFW->check, Cleantalk\ApbctWP\DB->fetch_all

    According to the entries from the Slow queries log and php_errorlog, the queries are related to the “Security & Malware scan by CleanTalk” plugin.

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘High CPU usage’ is closed to new replies.