…performs in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB…benchmarks/innodb-myisam-falcon…Part 2). There MyISAM shows bad scalability with increasing count of thread. I think the reason is pread system call MyISAM…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… existent with MyISAM. QA has to be performed as part of the move. Performance Innodb has a lot to offer in terms of performance – Performance benefits and…. Innodb needs resources and it will not work well with defaults a lot. Tuning MyISAM from defaults rarely gives more than 2-3…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, spent about 2 hours, and came back to the client with “there’s not a lot of performance left to … an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or … that really matter. That’s why I save this part of the analysis for last. You cannot consider any…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb…MySQL 5.4.2 for tests… case. This part of data…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… as part of our consulting practice, but is totally…keep in memory much more records then InnoDB / MyISAM. Actually in internal cache records are … you do in iiBench test ( Graph 2), and the number of inserts/sec … data rate, enabling much higher query performance. Beside iiBench we run benchmarks of …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb…performance improvement is marginal however WB cache brings single thread random write performance…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… NULL, PRIMARY KEY (id), KEY state (state) ) ENGINE=MyISAM; 2) Table with VARCHAR: CREATE TABLE cities_varchar ( id…be larger. It is also interesting to note performance of Innodb tables in this case: for VARCHAR it…case but this is other story. To avoid part of this problem we of course arrange state…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…Even that doesn’t help, though. Problem 2: Counters don’t measure time… takes. If you approach application performance optimization from the standpoint of … very slow relative to other parts of the computer. And here… to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM,…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB…InnoDB in both performance and features. The early version of PBXT was not fully durable (equivalent to innodb_flush_log_at_trx_commit=2… avoid modifying any part of MySQL to…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… index header (most complex part of opening and closing MyISAM table) can happen by … rate. Interesting enough it dropped just 2 times and was about same for…performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well) – Innodb…
