Title: Old data still visible
Last modified: May 26, 2026

---

# Old data still visible

 *  Resolved [Artan](https://wordpress.org/support/users/artankrasniqi1988/)
 * (@artankrasniqi1988)
 * [1 week, 5 days ago](https://wordpress.org/support/topic/old-data-still-visible/)
 * Hi,
 * 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:
 * ![](https://i0.wp.com/snipboard.io/Uoumkh.jpg?ssl=1)
 * In your backend system tables seems also empty:
 * ![](https://i0.wp.com/snipboard.io/U4wHsi.jpg?ssl=1)
 * How to empty all tables. Where are the old views stored?
 * Regards

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Mostafa Soufi](https://wordpress.org/support/users/mostafas1990/)
 * (@mostafas1990)
 * [1 week, 1 day ago](https://wordpress.org/support/topic/old-data-still-visible/#post-18923578)
 * 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):
 *     ```wp-block-code
       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.
 *  Thread Starter [Artan](https://wordpress.org/support/users/artankrasniqi1988/)
 * (@artankrasniqi1988)
 * [5 days, 4 hours ago](https://wordpress.org/support/topic/old-data-still-visible/#post-18926134)
 * Thanks it worked.
 *  Thread Starter [Artan](https://wordpress.org/support/users/artankrasniqi1988/)
 * (@artankrasniqi1988)
 * [5 days, 4 hours ago](https://wordpress.org/support/topic/old-data-still-visible/#post-18926141)
 * Recommended: Flushing this in the settings of the plugin would be more user friendly.
   Still thx.
 *  Plugin Author [Mostafa Soufi](https://wordpress.org/support/users/mostafas1990/)
 * (@mostafas1990)
 * [4 days, 22 hours ago](https://wordpress.org/support/topic/old-data-still-visible/#post-18926644)
 * Good to hear, thank you for pointing out.
 * Best

Viewing 4 replies - 1 through 4 (of 4 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fold-data-still-visible%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/wp-statistics/assets/icon.svg?rev=3081064)
 * [WP Statistics – Simple, privacy-friendly Google Analytics alternative](https://wordpress.org/plugins/wp-statistics/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-statistics/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-statistics/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-statistics/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-statistics/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-statistics/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Mostafa Soufi](https://wordpress.org/support/users/mostafas1990/)
 * Last activity: [4 days, 22 hours ago](https://wordpress.org/support/topic/old-data-still-visible/#post-18926644)
 * Status: resolved