Reset & Index

The Reset & Index page provides data management and maintenance tools. Access it at WB Plugins > Statistics > Reset & Index.

Overview

This page allows administrators to:

• Clear cached statistics data
• Rebuild activity indexes
• Reset specific data types
• Optimize database tables

Cache Management

Clear All Caches

Removes all cached statistics: transient cache cleared, object cache purged (if available), forces fresh calculations on next view.

When to use: Statistics seem outdated, after bulk user operations, after database migrations.

Clear Specific Caches

Selectively clear caches:

Data Reset Options

Reset Activity Log

Clear activity log entries with options: All logs (complete reset), Logs older than 30/60/90 days, Logs by specific type.

Warning: This permanently deletes log data.

Reset User Statistics

Clear calculated user statistics including last login timestamps, activity counts, and engagement scores. Note: Raw activity data in BuddyPress is preserved.

Reset Group Statistics

Clear calculated group statistics including member counts cache, activity aggregations, and top contributor calculations.

Index Rebuilding

Why Rebuild Indexes

Indexes may need rebuilding when database was migrated, data appears inconsistent, after major BuddyPress changes, or performance has degraded.

Rebuild Activity Index

Re-indexes activity data for faster queries. Process runs in background with progress indicator. Duration depends on activity count (< 10,000: < 1 minute, 10,000-100,000: 1-5 minutes, > 100,000: 5-15 minutes).

Rebuild User Index

Re-calculates user statistics including login history, activity counts, and health segment assignments.

Rebuild Group Index

Re-calculates group statistics including member counts, activity totals, and contributor rankings.

Database Optimization

Optimize Tables

Runs MySQL OPTIMIZE on plugin tables to reclaim deleted space, update table statistics, and improve query performance. Runs automatically weekly via cron. Manual trigger: Click “Optimize Now”.

Table Statistics

View current table status showing rows, size, and overhead for wp_bp_stats_activity_log.

Maintenance Mode

Enable maintenance to temporarily disable statistics collection (dashboard shows cached data). Disable maintenance to re-enable collection and resume normal operation.

Import/Export

Export settings to JSON format (privacy-safe, no user data). Import settings from export file by selecting JSON file, reviewing changes, and confirming import.

Scheduled Tasks

View cron jobs: Log Cleanup (Daily, 2:00 AM), Table Optimization (Weekly, Sunday 3:00 AM), Cache Warming (Hourly). Manual trigger available for any scheduled job.

Safety Features

Destructive operations require confirmation with “Are you sure?” prompts, type confirmation for critical actions, and “cannot be undone” warnings. Backup reminder shown before major resets.