… of cons to the table which are missing in MyISAM and vice-versa. MyISAM is like a dog and InnoDB is like… – you should not use MyISAM. If you have a huge number of concurrent writes and selects and query performance must be consistently fast in this use case – you should not use MyISAM. If none…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… important than performance for small application. As load increases you might convert certain tables to MyISAM and other storage engines for performance reasons… cache which you hoped for causing unexpected slowdowns. delay_key_writes Whatever way you enable this option – globally, for table or…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover skip-grant-tables… WT cache enabled, single thread performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to …is to avoid the accumulating a backlog of asynchronous writes, but writing synchronously. Although write performance is comparable with InnoDB, I am not …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… 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… if data size is close to memory size), generally slower writes, slower blob handling, concurrency issues, problems dealing with very large… would not switch table to MyISAM because it gives 5% performance improvement but I can perfectly use MyISAM (or Archive) for logging. Innodb…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key… bad performance. We hope the performance of LIMIT queries will be fixed before release. MyISAM shows stable result. InnoDB is better than MyISAM by…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… most common questions we hear is how to build high-performance systems to do this work. Let’s see some ways you can build the functionality you need and get the performance you need. Because I’ve built two such systems to… can write CSV files with any programming language. Naturally, CSV files don’t store as compactly on disk as [Compressed] MyISAM…
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
… matches or range lookups. This is however not performance gotcha I’m going to write about. There is one more thing you… thing you may find unusual is – the key cardinality affects performance even when this key is not directly used for lookup… Innodb could delay writes and do all the changes directly in memory. MyISAM however had to perform number of random writes to the key…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… this setting improves performance. Though be careful if you do not have battery backed up RAID cache as when write IO may… MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there would be some changes you would like to… sake of consistency and to get better performance. Next if your application has any writes be prepared to handle deadlocks which may…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… us how we do a performance audit (it’s our most popular service). I thought I should write a blog post that…’m not going to write that much. The kickoff call There’s actually a step before the performance audit begins. We call… might be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be…
