{"id":10857517,"date":"2018-11-07T18:35:35","date_gmt":"2018-11-07T18:35:35","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/shrink-database\/"},"modified":"2018-11-07T18:35:35","modified_gmt":"2018-11-07T18:35:35","slug":"shrink-database","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/shrink-database\/","title":{"rendered":"Shrink database"},"content":{"rendered":"<p>Current size of your counter table wp_cpd_counter is 953.33 MB.<br \/>\n1.278.846 Total visitors<\/p>\n<p>i would like to shrink this database and &#8220;sum up&#8221; the views<br \/>\nHow do i do this?<\/p>\n<p>when i click the Collect old data<br \/>\nit generates a 60mb file under backup<\/p>\n<p>But how do i shrink this database? is there a simlpe guide? i am OK with deleting all data older than 1 month IF its summed up.<\/p>\n","protected":false},"template":"","class_list":["post-10857517","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/10857517","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\/10857517\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=10857517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}