… –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 75 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…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… 500MB/sec writes with 16 concurrent threads. Things scaled well and with 256 threads I got even a bit better performance. Interesting… tested MyISAM with myisam_use_mmap option which did not seems to give any significant performance benefit, may be even reducing performance few percents…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… Innodb – even if writes are done in MyISAM table. So why was this done, being pretty bad for MySQL Performance and concurrency ? The… to see how well it performs 
One more thing to keep into account – INSERT … SELECT actually performs read in locking mode and… still going. In this case write is done to MyISAM table so we’ll not see any write activity. Other transaction which happes…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… well. MyISAM will not produce deadlocks for Innodb you should always see deadlocks as a probability as long as you write to the database. They may be rate but it is rather hard to guaranty you will never run into them. Performance Benchmarks – Innodb and MyISAM have different performance properties and you can’t really say one…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable… fully in Innodb data dictionary the operation is slower than MyISAM tables. Though the difference can be related to the size…. So innodb_open_files does not affect performance a lot on reads – what is about writes ? I tried again very simple test…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… Clustering and MyISAM tables if you follow certain rules like enabling external locking, disabling query cache and delayed key writes etc. This… be invalidated with remote writes which makes even less efficient. So this configuration would unlikely be well performing compared to other setups… was not repairing corrupted tables in this configuration even if myisam_repair is set. Space Saving ? As I mentioned replication can…
