I uninstalled WordPress Popular Posts plugin because it is getting slow lately. By digging to my database, I found that the table wp_popularpostsdatacache which is part of WordPress Popular Posts plugin is betting big. Currently it has 3,501,405 rows with 160.7 MiB used space.<\/p>\n
I am thinking that this cache was not purge because I am using nginx instead of apache. This happens to me on my Drupal site also. But I cannot confirm this. So, do you think this is because of nginx? If not, why it is getting bigger and bigger? It seems that the record there is not deleted.<\/p>\n
I am using using “Last 24 hours” option in Time Range option of this plugin. So I think a record of yesterday will be deleted automatically. But this is not the case.<\/p>\n
Any idea about this?<\/p>\n","protected":false},"template":"","class_list":["post-4529960","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4529960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4529960\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4529960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}