ZiziCache provides a current snapshot of database size and cleanup counters, plus optional growth history collected by the monitoring task.

Basic Database Information

The statistics endpoint includes:

• Database name, host, user, and prefix
• MySQL/MariaDB version
• Charset and collation
• InnoDB availability

Detailed Table Statistics

For the largest tables (top 10 by size), the plugin returns:

• Row count
• Data size and index size
• Total size in MB
• Fragmentation in MB
• Storage engine

Database Growth History

History is stored in the zizi_cache_db_size_history option and updated by the daily zizi_cache_db_monitor task when monitoring is enabled.

• Each entry contains date, size_mb, and change_mb
• The REST endpoint can force a refresh using ?t=1
• Retention is limited (typically the last 30-60 entries)

Cleanable Items Counters

Counters are returned for:

• Post revisions, auto-drafts, and trashed posts
• Spam comments and trashed comments
• Expired transients and all transients
• Tables eligible for optimization (non‑InnoDB with fragmentation)

Alerts and Notifications

Alerts are limited to abnormal per-table growth (default threshold about 30% per day, minimum size ~5 MB). Alerts are stored in zizi_cache_db_alerts and can be emailed to configured recipients. There are no built‑in fragmentation or size‑limit alerts.