ZiziCache provides a comprehensive overview of your database status, including detailed statistics on table sizes, growth, and overall database health.
Basic Database Information
The plugin displays the following basic information:
- Database Name: Current WordPress database
- Database Version: MySQL/MariaDB version
- Charset and Collation: Database encoding
- InnoDB Support: Availability of the InnoDB engine
- WordPress Version: Current WP version
Detailed Table Statistics
For each table, the plugin provides:
- Number of Records: Quantity of entries in the table
- Data Size: Size of the data itself
- Index Size: Space occupied by indexes
- Total Size: Combined size in MB
- Fragmentation: Amount of fragmented space
- Engine: Type of database engine (InnoDB/MyISAM)
Database Growth History
The plugin maintains a history of database size for trend analysis:
- Daily Records: Database size over time
- Size Changes: Differences between measurements
- Growth Trends: Calculation of weekly growth rate
- Growth Graphs: Visualization of changes over time
Cleanable Items Counters
Real-time counters show the amount of data available for cleaning:
- Number of post revisions
- Quantity of auto-drafts
- Posts and comments in the trash
- Spam comments
- Expired and all transients
Alerts and Notifications
The system automatically generates alerts for:
- Unusual table growth (>30% over a period)
- High amount of fragmentation
- Exceeding size limits
- Detection of performance issues