Profile
Achievement
Eloi's Recent SnippetsTagged mysql
- All /
« Prev 1 Next »
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...
1
1770
posted 17 years ago by Eloi
Splitting table users in frequently and infrequently accessed attributes
2
2217
posted 17 years ago by Eloi
Saving the IP as Int we save a lot of space and permit do beautibul selects
2
1872
posted 17 years ago by Eloi