… query and report MySQL Optimizer Bug 
But now lets see in the difference of behavior of ANALYZE TABLE for MyISAM vs Innodb. I used… TABLE Innodb, same as MyISAM will internally run analyze as soon as table is rebuilt and values will be more sensible: mysql> alter table antest_innodb type=innodb…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql… releases) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld…
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… nasty going on on Innodb level, so I tried running the test with MyISAM tables instead. The process … in a batch vs 40 seconds for single row statements. So with single statement MyISAM was about 10% ….0. At row0sel.c:row_search_for_mysql() “PHASE 3:”, InnoDB judge whether the SQL is “SELECT” or not…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb Transactional log which…you’re using – DRBD does not work with MyISAM (check required) so you need to have …hot vs cold. If you’re using decent hardware and care about performance you use O_DIRECT with Innodb…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) …MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 9, 2007 By 117 Comments
…InnoDB vs. MyISAM vs. Falcon in MySQL MySQL Performance Blog — InnoDB vs MyISAM vs Falcon benchmarks. Great test and lots of figures and graphs. … after 11 months of work (2) MyISAM toasts InnoDB in read performance is a myth. InnoDB rules for now with low concurrency. Eagerly…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb… 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam… was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… quite expected – This is MyISAM table which is accessed via index, which means to retrieve each row MySQL will have to perform… times faster than for MyISAM. This is great example of the case when Innodb is much faster than MyISAM for Read load. The… close performance, while join performance degraded dramatically. Here is why: mysql> explain select SQL_NO_CACHE c.city from cities_join…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
December 22, 2007 By 117 Comments
[...] InnoDB vs MyISAM vs Falcon benchmarks – part 1 Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. [...]
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
November 7, 2007 By 117 Comments
… InnoDB vs MyISAM for insertion queries for up to 100 threads (see presentation “Measuring MySQL Server Performance for the Sensor Data Stream Processing” at MySQL User Conference 2006. Unless you have very short records (less than 200 bytes) MyISAM outpreforms InnoDB for insertion speed…
