…MySQL to pick and choose indexes and hence is irrelevant to this problem. Next, I proceeded to test using MySQL 5.1.58 and 5.5…-00 00:00:00′, `type` tinyint(4) NOT NULL DEFAULT ’0′, KEY `id…bug in MySQL 5.1 and how it calculates the row estimates. This bug was tracked down to http://bugs.mysql.com/bug…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… expect to find a lot more bugs and annoyances. There are … int unsigned not null, is_blue tinyint unsigned not null, clicks int unsigned … improve here? Especially assuming that there are indexes other than the primary key, we…by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and …
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
… was wrong about bug in key length in 5.0 explain. Actually I used tinyint for age and …do it on idle box so as in MySQL 5.0 you do not have to any more….index range scan was initiated. Handler_read_next=42250 means 42250 rows were analyzed during this scan. Basically MySQL started scanning Index…
