http://snipplr.com/users/Eloi/tags/mysql Recent snippets posted on Snipplr.com en-us Thu, 20 Jun 2013 20:18:57 GMT http://snipplr.com/view/16218/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. Jay Pipes (http://jpipes.com/)

]]> Tue, 23 Jun 2009 08:02:28 GMT http://snipplr.com/view/16218/the-worst-performing-indexes/ http://snipplr.com/view/14738/create-table-users/ Splitting table users in frequently and infrequently accessed attributes

]]> Tue, 05 May 2009 11:20:21 GMT http://snipplr.com/view/14738/create-table-users/ http://snipplr.com/view/14731/create-table-sessions/ Saving the IP as Int we save a lot of space and permit do beautibul selects

]]> Tue, 05 May 2009 10:26:39 GMT http://snipplr.com/view/14731/create-table-sessions/