Conversation
supportHi, I truncated and optimized all tables via MySQL for following tables: wp_9bt6r02gw6_statistics_events wp_9bt6r02gw6_statistics_exclusions wp_9bt6r02gw6_statistics_historical wp_9bt6r02gw6_statistics_pages wp_9bt6r02gw6_statistics_summary_totals wp_9bt6r02gw6_statistics_visitor wp_9bt6r02gw6_statistics_visitor_relationships your backend shows this, still over 270.000 old views and also referral data: In your backend system tables seems also empty: How to empty all tables. Where are the old views stored? Regards
Hi Artan, Good news: you did not miss a table. In current WP Statistics (14.x), those seven statistics_* tables are the complete set of data tables, there is no separate “visits” table anymore, so the raw views and referral rows are genuinely gone. What you are still seeing comes from the plugin’s report cache. To keep the dashboard fast, WP Statistics caches the aggregated totals as transients in your wp_options table, under option names containing wp_statistics_cache . The Overview reads those cached numbers, so they survive a raw table truncate until the cache is cleared or expires. To flush it now, run the same delete the plugin uses internally (note your table prefix): DELETE FROM wp_9bt6r02gw6_options WHERE option_name LIKE '%wp_statistics_cache%'; This removes both the cached entries and their timeout rows. Reload the WP Statistics dashboard afterward and the totals will match your now-empty tables. Two notes: If you run a persistent object cache (Redis or Memcached) or a caching plugin, flush that as well, since transients can be stored there instead of the database. For future cleanups you do not need raw SQL. WP Statistics → Optimization has purge tools, and the plugin clears this cache automatically on each update. Let me know if the totals still do not drop after clearing the cache and flushing any object cache.
Thanks it worked.
Recommended: Flushing this in the settings of the plugin would be more user friendly. Still thx.
Good to hear, thank you for pointing out. Best
Hi Artan, Good news: you did not miss a table. In current WP Statistics (14.x), those seven statistics_* tables are the complete set of data tables, there is no separate “visits” table anymore, so the raw views and referral rows are genuinely gone. What you are still seeing comes from the plugin’s report cache. To keep the dashboard fast, WP Statistics caches the aggregated totals as transients in your wp_options table, under option names containing wp_statistics_cache . The Overview reads those cached numbers, so they survive a raw table truncate until the cache is cleared or expires. To flush it now, run the same delete the plugin uses internally (note your table prefix): DELETE FROM wp_9bt6r02gw6_options WHERE option_name LIKE '%wp_statistics_cache%'; This removes both the cached entries and their timeout rows. Reload the WP Statistics dashboard afterward and the totals will match your now-empty tables. Two notes: If you run a persistent object cache (Redis or Memcached) or a caching plugin, flush that as well, since transients can be stored there instead of the database. For future cleanups you do not need raw SQL. WP Statistics → Optimization has purge tools, and the plugin clears this cache automatically on each update. Let me know if the totals still do not drop after clearing the cache and flushing any object cache.
Thanks it worked.
Recommended: Flushing this in the settings of the plugin would be more user friendly. Still thx.
Good to hear, thank you for pointing out. Best