The WordPress Action Scheduler can quickly increase the size of your database by storing a large number of logs and completed actions. ZiziCache provides specialized tools for cleaning these tables. What Action Scheduler Cleans The plugin automatically cleans the following tables: actionscheduler_logs – logs older than the set number of days actionscheduler_actions – completed, canceled,...
Advanced Database Growth Monitoring ZiziCache includes an advanced database growth monitoring system that automatically detects unusual size changes and alerts administrators to potential issues. This proactive monitoring helps prevent database bloat and performance degradation before they impact your website. Automated Anomaly Detection The monitoring system tracks these critical metrics: Individual Table Sizes – Monitor growth...
ZiziCache analyzes your database and provides intelligent recommendations for creating database indexes, which can significantly improve query performance. Automatic Index Analysis The plugin analyzes the following aspects of the database: Existing indexes: An overview of current indexes Table statistics: Number of records, data size, and index size Recommended indexes: Proposals for new indexes for optimization...
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 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...
Database Table Optimization ZiziCache provides tools for the safe optimization of database tables, improving query performance and reducing data fragmentation. Types of Table Optimization The plugin recognizes and optimizes different types of tables: MyISAM tables: Full optimization with OPTIMIZE TABLE InnoDB tables: Optimization only in case of fragmentation Fragmented tables: Priority optimization Safety Measures The...
ZiziCache provides a robust REST API for remote management of database operations, enabling integration with external tools and automation of database maintenance. Available REST Endpoints The API includes the following main endpoints: /optimize-db-tables: Optimization of database tables /optimize-db-tables-batch: Batch optimization for large databases /database-statistics: Detailed database statistics /database-status: Current database status /database-size-history: Database growth history...