… performance standpoint)? In this post I’d like to present a small benchmark which shows MySQL performance when you use 3 different approaches: ENUM… MyISAM table which is accessed via index, which means to retrieve each row MySQL will have to perform OS system call to read….0854793 As you can see, ENUM and VARCHAR show close performance, while join performance degraded dramatically. Here is why: mysql> explain select SQL_NO…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… master, so they may benefit from different indexing Q: Is there a Percona recommendation for … value). If you make the field an ENUM(‘payed’,'shipped’,'canceled’,'archived’), the values will …to learn MySQL administration suggest any book or practices. Of course I’m biased but High Performance MySQL …
Comment: How to find wrong indexing with glance view
August 23, 2008 By 27 Comments
… long indexes. Let’s consider you’re superb and have 1 billion of users. If you’re smart enough and read mysql performance related articles then you’ll store all those fields as enums or tiny int with dictionary…-union-to-implement-loose-index-scan-to-mysql/#comment-1695 2. http://dev.mysql.com/doc/refman/5.1/en/index-merge-intersection.html
Post: When the subselect runs faster
March 18, 2010 By 9 Comments
…the table is looks like this: `col1` enum(‘A’,'B’,'C’,'CD’,'DE’,'F’,'G’,'… query using subqueries we actually improved it performance 100 times. So subqueries are not always…index order. We can just use FORCE INDEX hint to override MySQL index choice: mysql> explain select * from table FORCE INDEX…
