Database Statistics and Size Monitoring

Updated on 12. 6. 2025

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
What are your feelings