{ Snipperize } /performence

Snippets about performence

Here are the latest snippets talking about performence. Please choose your favorite one or add a new one.

The Worst Performing Indexes

This script shows the top 10 worst indexes (in terms of selectivity %) on the whole MySQL server instance. Selectivity is the percentage of distinct values in an indexed field compared to the number of records in the table. Note that this query can take some time to complete on servers with lots of databases or lots of tables.

SQL / performence / by ThePeppersStudio (393 days, 12.44 hours ago)

  • 1