[...] and commentary available from MySQL Performance Blog at InnoDB vs MyISAM vs Falcon benchmarks – part 1 and Falcon Storage Engine Design [...]
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb…performance improvement is marginal however WB cache brings single thread random write performance…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… transactional engine for MySQL. While my far goal is the performance and scalability testing before I wanted to look at basic… are InnoDB sessions: Test 1: Deadlock detection (deadlock is correctly detected): insert into test2 values (1,’Mysql’),(2,’Solid’),(3,’MyISAM‘); Session1…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… to test how it performs in tpcc-mysql workload from both performance and stability standpoints. I… bigger innodb logfiles to get more stable results. So there it is with 2x4GB vs 2x8GB innodb …= 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
Dale, I specially list Performance as one of concerns. There are cases when Innodb will not perform as good as MyISAM no questions… in particular if you tuned your applications for MyISAM for years. Innodb does… many Alexa Top 100 sites (as an example) use mostly Innodb vs Mostly MyISAM.
Comment: Innodb Performance Optimization Basics
April 24, 2008 By 75 Comments
… (even after changing the innodb_buffer_pool_size). The MyISAM table finishes approximately 4 times faster than the InnoDB table. This is significant…, however, I have not read where machine performance dictates the percentage of increase of InnoDB vs MyISAM. (Although I don know it it memory…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…If you’re using MySQL with Innodb (and running MyISAM with DRBD makes little sense …performed parallel. Anyway the point is there is a lot of synchronous writes which are fully serialized because group commit in Innodb… we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…several Full Text Search solutions and compare their performance. Even if you missed the webinar, you …InnoDB FT index, I made sure to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM…where I announced the webinar: We evaluated MySQL vs Solr. I was able to index all …
Comment: Unused indexes by single query
September 14, 2008 By 14 Comments
… for InnoDB and MyISAM: To insert 1 million records in InnoDB with 1 index took 80 sec, with 2 indexes – 136 seconds. For MyISAM the difference is bigger: 72 sec vs 470… our release to our customer when we are working on performance problems.
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…packed rows – quite possible scenario for MyISAM tables. Now if we take … The times for full table scan vs range scan by index: mysql> …There are also clustered keys in Innodb which combine index access with … normalized to several tables or perform complex queries finding relationships between objects…
