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, and fragmentation
• ROW_FORMAT details (Barracuda/Antelope) and maximum index key length
• Recommended indexes with priority (high/medium/low) and generated ALTER TABLE SQL

Covered Tables

The default analysis includes WordPress core tables and optional WooCommerce tables if present:

• Core: wp_posts, wp_postmeta, wp_comments, wp_commentmeta, wp_options, wp_usermeta, wp_users, wp_termmeta
• WooCommerce: woocommerce_order_itemmeta, wc_orders_meta (HPOS) when the tables exist

Slow Query Analysis (optional)

If MySQL Performance Schema is available, ZiziCache samples slow query digests with average time greater than 1 second. If Performance Schema is not available, no slow-query data is returned.

Applying Recommendations

Indexes are not created automatically. Applying them is a deliberate action (admin UI or REST API). Only a predefined allowlist of index names can be applied for safety.

Output Summary

The response includes the analysis timestamp, summary counts by priority, and the full recommendation list.