High CPU usage
-
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]
- The topic ‘High CPU usage’ is closed to new replies.