INN / Google-Analytics-Popular-Posts

A WordPress plugin that uses Google Analytics data to determine the most popular posts on your site and display a list of popular posts via the included widget.
https://wordpress.org/plugins/ga-popular-posts/
23 stars 7 forks source link

query and mysql memory leak #79

Closed CyberCr33p closed 4 years ago

CyberCr33p commented 5 years ago

We are a webhosting provider and one of the wordpress we host (with 100.000 posts) uses this plugin.

The problem is that the MySQL memory usage keeps growing and after 1-2 days it uses more than 30-40GB of combined RAM + SWAP.

If I disable the plugin the MySQL memory usage is 5-6GB which is within the limits defined by my.cnf

I think there is a bug witch MySQL which doesn't free memory.

I think the query which cause the problem is this:

https://pastebin.com/raw/gJNSqQv9

Does someone else have similar issue with website with many posts?