Sorry, didn’t notice you already opened your own topic. Still, part of my answer still applies.
Ok, so:
– PHP version: 5.4.45
– WordPress theme Bimber 4.2 (I think, maybe this is a problem. and updates are needed?)
– WordPress 4.8.3
– plugins and phpmyadmin wp_popularpostssummary section:
View post on imgur.com
Everything works great before update WPP 4.0.5. Now Im using old version WPP 4.0.3.
Ah, that’s it then. Other users reported some issues with the Bimber theme. The team behind this theme released an update not so long ago which seemed to fix the problem, so please upgrade your theme (and WPP as well, don’t use old versions) and if you’re still having issues let me know and I’ll gladly take a look.
Hello again,
I’m sorry that my answer took so long. I updated bimber theme to 5.2.4. It seems like everything is working now, but I have another, much worse problem. When I turn on WordPress Popular Posts, Plugin takes all the memory & cpu and it causes the server to crash after a few minutes. I installed Query Monitor and it says that:
Slow Database Queries (above 0,05s)
SELECT p.ID AS ‘id’, p.post_title AS ‘title’, p.post_date AS ‘date’, p.post_author AS ‘uid’, SUM(v.pageviews) AS ‘pageviews’
FROM wp_popularpostssummary v
LEFT JOIN wp_posts p
ON v.postid = p.ID
WHERE 1 = 1
AND p.post_type = ‘post’
AND v.view_datetime > DATE_SUB(‘2017-11-20 02:08:08’, INTERVAL 1 WEEK)
AND p.post_password = ”
AND p.post_status = ‘publish’
GROUP BY v.postid
ORDER BY pageviews DESC
LIMIT 6;
+
bimber_wpp_query_posts()
wp-content/themes/bimber/includes/plugins/wordpress-popular-posts.php:418
Theme 6 0,6562
…………………….
Slow database ‘sec’ is little, cuz i check that on night, when traffic is low. But in the day there is total failure. Please help me 🙁 my site isntt able to function without your plugin.
Hello.
My storage engine was set up to InnoDb. I did everything from here: https://github.com/cabrerahector/wordpress-popular-posts/wiki/7.-Performance
I got 150 k views daily. 2000 articles. I changed sample rate from 100 to 200. But still the same, cpu and memory is overloaded 🙁
Alright, try reducing the number of database reads the plugin does.
Also, you might want to limit the size of WPP’s tables to keep it from growing too large for your database server to handle (specially if you have been using WPP for some time now).
