ZiziCache provides optional cleanup for WordPress Action Scheduler tables. It removes old log entries and completed actions to limit database growth. Cleanup runs only when enabled in configuration. What Gets Deleted actionscheduler_logs — log rows older than db_actionscheduler_logs_days days (default: 1). actionscheduler_actions — actions with status complete, canceled, or failed where last_attempt_gmt is older than...
Overview ZiziCache includes a database growth monitor that compares current table sizes with the previous snapshot and flags unusual growth. It uses information_schema.TABLES and stores a small history in WordPress options for the admin UI and REST API. What is measured Per‑table size (data + indexes) and row counts. Total database size (sum of all...
ZiziCache analyzes selected WordPress and WooCommerce tables and returns index recommendations with priority, rationale, and generated SQL. The analysis runs on demand and does not change the database unless you explicitly apply selected recommendations. Automatic Index Analysis The analysis collects: Existing indexes per table (SHOW INDEX) Table statistics: rows, data size, index size, engine,...
ZiziCache includes an advanced system for monitoring database performance, providing detailed metrics on queries, response speed, and the efficiency of database operations. NOTE: not presented yet in ZiziCache dashboard. Monitored Metrics The system automatically tracks the following key metrics: Query count: Number of database queries per page Query time: Total time taken to execute queries...
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:...
Database Table Optimization ZiziCache can optimize database tables using MySQL OPTIMIZE TABLE. Optimization is triggered manually from the Database tools or via the REST API; it is not executed automatically as part of the scheduled cleanup job. Types of Table Optimization The plugin provides two execution paths with different scopes: Standard optimization (admin quick action...
ZiziCache exposes database maintenance endpoints under /wp-json/zizi-cache/v1. All routes require authenticated admin access and a valid REST nonce. Available REST Endpoints Database-related routes: /database-statistics (GET): database info, summary, top tables, chart data /database-growth-history (GET): size history (params: days, t=1 to force refresh) /database-status (GET): summarized status (autoload size, orphaned postmeta, Action Scheduler status) /cleanup-counts...