MariaDB 10.3
I am investigating a Wordpress / Woocommerce installation, which is quite slow. I threw the slow log into ChatGPT, which suggested adding indexes to the status
column of the wp_wc_order_stats
table. I checked to see if there weren't indexes already, and sure enough; there were (on more columns than just the status column in fact)
So I used EXPLAIN like this: EXPLAIN SELECT DISTINCT status FROM wp_wc_order_stats;
which resulted in the table
ChatGPT told me 'Using temporary' indicated that the index wasn't used. What can I do to fix this?
woocommerce add index
yields a lot of tips for improving performance. Maybe you try some of these.