Old data still visible

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.