High CPU usage due to WP Statistics

Hi,

Could you please let me know which version of PHP you are running on ?

Regards

Hi DediData,

I checked and it seems the system default is PHP 5.6.32

Thank you.

Kind regards,
Daniel

Same Problem here, since last update I have problems on all sites with wp-statistics.
PHP Fatal error: Allowed memory size of 268435456 bytes exhausted … wp-statistics/includes/vendor/garetjax/phpbrowscap/src/phpbrowscap/Browscap.php on line 504
AND
Database error – .wp_statistics_search’ doesn’t exist f\xc3\xbcr Abfrage SELECT words , count(words) as count FROM wp_statistics_search WHERE words [] ” AND last_counter BETWEEN DATE_SUB(CURDATE(), INTERVAL 30 DAY) AND CURDATE() GROUP BY words order by count DESC limit 10 von do_action(‘wp_ajax_wp_statistics_get_widget_contents’), WP_Hook-]do_action, WP_Hook-]apply_filters, WP_Statistics_Ajax::get_widget_contents_callback, wp_statistics_generate_searched_phrases_postbox_content

WP Multisite running on PHP7

Guess, I must deactivate it on all sites and look for another statistic option – not good!

Hi,

We had many changes in latest version, As we convert whole the project to object oriented
Please let us do more investigations, We will have many optimizations in next version

Regards

• This reply was modified 7 years, 3 months ago by DediData.

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,

I am trying my best to solve these problems,
But coding takes time
So be patient

Could you please download this repository and replace your current plugin with this
And test again
https://github.com/wp-statistics/wp-statistics/archive/master.zip

• This reply was modified 7 years, 3 months ago by DediData.

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?

.

Hi,

Don’t worry no problem occur, replace just files

• This reply was modified 7 years, 3 months ago by DediData.

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

Hi,

No, Don’t uninstall or remove plugin through WordPress
Just use your file manager on your hosting panel or ftp
Delete old files on /wp-content/plugins/wp-statistics/
And upload files from this zip file
https://github.com/wp-statistics/wp-statistics/archive/master.zip

Thank you ??

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

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,
Sorry, I updated the source again,
Could you please re upload the new source and test again?
Thank you