I am new to Percona Server for MySQL, and I’m unsure about how to configure MySQL indexes. Could someone guide me on where I can find a list of all the indexes and identify the most useful ones for my table? Your assistance is greatly appreciated.
Thank you in advance.
If you want to see indexes on a table, just run “SHOW CREATE TABLE fooTable” and examine the schema. You will see all indexes.
If you want to understand the effectiveness of an index, run “EXPLAIN” on a query. For example,
EXPLAIN SELECT * FROM table WHERE colA = 4567 If the optimizer was able to use an index, you will see that index listed. If there was no good index, you will see ‘ALL’ indicating a full-table-scan took place.
This answer barely scratches the surface of the “Query Optimization” topic. Percona offers a 2-day training course on query and schema optimization.