Danielus111

Dear,

I have the same issue as above, since recently. I tried all suggestions but it doesn’t work for me. Can you please suggest a solution? Thank you in advance. Here is the website with the issues https://www.cancertreatmentsresearch.com

Kind regards,

Thank you for your very helpful reaction. I checked and found the issue. It was no WP plugin but actually the firewall from Cloudflare causing these issues. Thanks again. Kind regards, Daniel

Dear DediData,

I upgraded to the new version, and:
– the stats in the admin page are now finally loading (I did not checked yet if there is still an impact on the CPU usage but I expect to be not much anyway since it is successfully loading)
– the widget with stats is now working again

Thank you. Keep up the good work.
(I also made a donation.)

Kind regards,
Daniel

Hi,

Now I went through various support subjects and found out that I am not the only one having this issue, i.e. more people reporting similar issues as WP Stats is trying to retrieve info in admin panel but would never stop and cause high CPU usage. So it is clear to me the plugin doesn’t work anymore in its current form and combo with current Worldpress version.

While you are trying to make it work, can you please let me know where I ca access an older versions of WP Statistics and so I can check which one was the right one?

I must say that the things got worse recently, but I think I have seen it becoming worse and worse in terms of retrieving the data in admin panel, during the past months. Maybe this piece of info fits in to the puzzle you are trying to solve.

Thanks again for all your efforts,
Daniel

Same issue here and unresolved https://www.ads-software.com/support/topic/high-cpu-usage-due-to-wp-statistics/

Hi,

Thank you. I downloaded the file again, and tested again. Same results:
– extremely slow loading of statistics in the dashboard (only part of the graphs loading the others forever loading which leads to jump in CPU usage)
– widget on the webpage still not visible as before to include the visitor/visits details

Here is an example of some slow queries prior to the point I tried to actually load the dashboard:

Slow Database Queries (above 0.05s)
Query Caller Component Rows Time
SELECT COUNT(ID)
FROM wp_ufsg_statistics_visitor
+
WP_Statistics_Admin_Pages::optimization()
wp-content/plugins/wp-statistics/includes/classes/class-wp-statistics-admin-pages.php:236
Plugin: wp-statistics 1 0.1248
SELECT COUNT(uri)
FROM wp_ufsg_statistics_pages
+
WP_Statistics_Admin_Pages::optimization()
wp-content/plugins/wp-statistics/includes/classes/class-wp-statistics-admin-pages.php:238
Plugin: wp-statistics 1 0.1122
SELECT COUNT(ID)
FROM wp_ufsg_statistics_search
+
WP_Statistics_Admin_Pages::optimization()
wp-content/plugins/wp-statistics/includes/classes/class-wp-statistics-admin-pages.php:240
Plugin: wp-statistics 1 0.1023
SELECT DISTINCT agent
FROM wp_ufsg_statistics_visitor
+
wp_statistics_ua_list()
wp-content/plugins/wp-statistics/includes/functions/functions.php:412
Plugin: wp-statistics 298 0.0753

Kind regards,
Daniel

In addition, I had a Widget showing Total nr. of views, users, Daily visitors, etc. and now that info is not visible anymore. When I go to the Widget area and try to select what I like to display (as I did in the past), the Widget connected to statistics says “There are no options for this widget.”

Kind regards,
Daniel

Hi,

I tried – followed exactly your suggestions – replaced via ftp. The outcome is the same: when I try to access anything that displays WP Stats info – everything slows down extremely and is in turn reflected in high CPU usage that finally shuts down the website.

Could it be that there is interference with other plugins I have installed?

Kind regards,
Daniel

Thank you ??

Hi,

For clarity, what I will do is:

1. go to WordPress plugins page and disable/delete
2. Add as a new plugin the zip file you shared, using WordPress plugin section

Will this lead to deleting also the data base? Or that will remain and be available once I install the zip as a new plugin?

I apologize if I am asking too much, but I am a beginner in this field and would like to make sure I do things right and do not delete the statistics from the data base following my actions.

Thanks for patience,
Daniel

Thank you. I didn’t know you are working on it. If I delete the previous WP stats version, will from the World-press plugin area, will my statistics also be deleted?

Dear DediData,

I was waiting for a reply from you … is there any chance you could advise me with what I can do to solve the large impact on the CPU usage which in turn shuts down my website?

This is the reply I received from the web-hosting support:

“I have ran an analysis for the past 24 hours on your account and noticed huge amount of slow queries and executions towards the admin-ajax.php. The only slow queries are present:

Code:
=== TOP 5 of 28 (total) Slow Queries for the past 24 hours ==========
1. Executed 1h 32m 22s ago for 7.746041 sec on Database –> cancert8_aw
Date: 2017-11-19 17:23:41 Query_time: 7.746041 Rows_examined: 1: Rows_sent 0 Lock_time: 0.000082
# Schema: cancert8_aw Last_errno: 0 Killed: 0 UPDATE wp_ufsg_statistics_pages SET count = count + 1 WHERE date = ‘2017-11-19’ AND uri = ‘/artemisia-annua-its-extract-artemisinin/’;
————————————————————————————————
2. Executed 1h 32m 22s ago for 6.586604 sec on Database –> cancert8_aw
Date: 2017-11-19 17:23:41 Query_time: 6.586604 Rows_examined: 1: Rows_sent 0 Lock_time: 0.050128
# Schema: cancert8_aw Last_errno: 0 Killed: 0 SELECT id FROM wp_ufsg_statistics_pages WHERE URI = ‘/?wordfence_logHuman=1&hid=74E8DC4987CE4E32E16D010AD1E72F0D&r=0.46206953242735726’ AND id > 0 ORDER BY date DESC;
————————————————————————————————
3. Executed 17m 39s ago for 6.152274 sec on Database –> cancert8_aw
Date: 2017-11-19 18:38:24 Query_time: 6.152274 Rows_examined: 1: Rows_sent 0 Lock_time: 0.000708
# Schema: cancert8_aw Last_errno: 0 Killed: 0 UPDATE wp_ufsg_statistics_pages SET count = count + 1 WHERE date = ‘2017-11-19’ AND uri = ‘/community/forum-to-discuss-treatment-protocols-and-drugsupplement-cocktail/’;
————————————————————————————————
4. Executed 1h 38m 28s ago for 6.028082 sec on Database –> cancert8_aw
Date: 2017-11-19 17:17:35 Query_time: 6.028082 Rows_examined: 1: Rows_sent 0 Lock_time: 0.000055
# Schema: cancert8_aw Last_errno: 0 Killed: 0 UPDATE wp_ufsg_statistics_pages SET count = count + 1 WHERE date = ‘2017-11-19’ AND uri = ‘/artemisia-annua-its-extract-artemisinin/’;
————————————————————————————————

Is there anything I can do?

Or maybe uninstall and install again the plugin? If that is one option, will I loose the historical data?

Thanks,
Daniel

Hi DediData,

I checked and it seems the system default is PHP 5.6.32

Thank you.

Kind regards,
Daniel