…MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL…offer only incremental performance improvements. key_buffer_size – Very important if you use MyISAM tables. Set…of OK for many workloads with medium write load and shorter transactions. If you …
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… really follow these rules. Another option to filter writes on the Master is of course manual filtering -…MyISAM tables, because MyISAM can’t be disabled and so if you create tables as MYISAM or ALTER them to MyISAM… todo to see how well MySQL 5.1 row based replication works and performs and I will be…
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
One performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which… matches or range lookups. This is however not performance gotcha I’m going to write about. There is one more thing you… 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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first … variables or whatever other data I need, and write something instructional to the client about it. Preparing… an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there would be some… sake of consistency and to get better performance. Next if your application has any writes be prepared to handle deadlocks which may… these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… care of or which may seriously affect MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM tables there is very large chance of… experience related to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write about them some…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
… hit rate is good for optimal MySQL Performance” is typical question I’m asked. It could by MyISAM key_buffer or Innodb innodb… partuclar you should be looking at Key_reads and Key_writes for MyISAM tables (note this does not include row data access… your hit ratio is it is unlikely the problem for MySQL Performance. If it is however 120 per second it well could…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… sometimes handy feature but it can be rather expensive from performance point of view. The nasty thing with counters as they… stuff and you can’t easily tell it to perform certain action (ie write back to the database) when object is removed… use memcache + another mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive table and…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… Paul was for a while comparing PBXT to MyISAM with multi versioning and transactions and this …applications if implemented well. It is too bad MySQL Users Conference only allowed 45 minutes for …benchmarks PBXT both performs and scales well in many read workloads. We did not check writes because this…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… writes are done in MyISAM table. So why was this done, being pretty bad for MySQL Performance and concurrency ? The reason is – replication. In MySQL… 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…
