Recent snippets posted on Snipplr.com https://snipplr.com/ Wed, 10 Jun 2026 04:39:59 +0000 https://snipplr.com/view/16218/the-worst-performing-indexes <p>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/)</p> Tue, 23 Jun 2009 08:02:28 UTC https://snipplr.com/view/16218/the-worst-performing-indexes https://snipplr.com/view/14738/create-table-users <p>Splitting table users in frequently and infrequently accessed attributes</p> Tue, 05 May 2009 11:20:21 UTC https://snipplr.com/view/14738/create-table-users https://snipplr.com/view/14731/create-table-sessions <p>Saving the IP as Int we save a lot of space and permit do beautibul selects</p> Tue, 05 May 2009 10:26:39 UTC https://snipplr.com/view/14731/create-table-sessions