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
- Slow queries: Queries taking longer than 1 second
- Memory usage: Memory consumption during database operations
- Peak memory: Maximum memory usage
Performance Analysis
The plugin offers user-friendly performance analysis with the following ratings:
- Excellent (<30 queries): The database is performing excellently
- Good (30-60 queries): The database is performing well
- Fair (60-100 queries): The database needs optimization
- Poor (>100 queries): The database is overloaded
Optimization Recommendations
Based on the analysis, the plugin provides specific recommendations:
- Enable database caching for a high number of queries
- Optimize slow queries
- Check plugins and themes when overloaded
- Implement Redis or Memcached for object caching
SQLite Storage for Performance Metrics
Performance metrics are stored in a dedicated SQLite database for long-term trend monitoring and historical performance analysis. This provides efficient storage and quick access to performance data without impacting the main WordPress database.