January 2019
Intermediate to advanced
286 pages
7h 41m
English
The performance summary tables in the schema instructions have several interesting columns. In our case, two of them are important: NO_INDEX_USED (this will tell you which indexes have not been solicited) and NO_GOOD_INDEX_USED, if MySQL did not find a correct index for the query.
In the SYS schema, you will find a base view that points to the performance_schema.events_statements_summary_by_digest table and is very useful for this purpose via the statements_with_full_table_scans statement, which keeps all instructions that have performed a table analysis.
The following is an example:

The preceding query ...
Read now
Unlock full access