Member since 06/27/2006

Location: Barcelona

Website: http://eloipoch.es

3 snippets

1756 profile views

0 Comment(s) Posted

View their favorites



first submission:submitting first snipplet

Eloi's Recent SnippetsTagged mysql

« 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 462 posted 14 years ago by Eloi
Splitting table users in frequently and infrequently accessed attributes
2 872 posted 14 years ago by Eloi
Saving the IP as Int we save a lot of space and permit do beautibul selects
2 536 posted 14 years ago by Eloi
« Prev 1 Next »