Everyone using Innodb tables probably got use to the fact Innodb tables perform non locking reads, meaning unless you use some modifiers such… to be Innodb – even if writes are done in MyISAM table. So why was this done, being pretty bad for MySQL Performance and… tests to see how well it performs 
One more thing to keep into account – INSERT … SELECT actually performs read in locking mode and…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 21 Comments
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does… innodb_open_files does not affect performance a lot on reads – what is about writes ? I tried again very simple test inserting the…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… sec: 434.330528194 , reads rows per sec: 5157.1389149296sec. Insert performance is close, the difference is perhaps explained by the … table scan performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well) – Innodb suffers …
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…of rows in tens of thousands tables) Innodb was better choice mainly because of thouse…performance for small application. As load increases you might convert certain tables to MyISAM and other storage engines for performance… has to be one insert at the time. Happily inserts in MyISAM are rather fast …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…DATA INFILE be optimized same way as for MyISAM tables by separate phase of building Indexes ? …and same for all insert cases – in fact if the insert is single value insert or the number … also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads or …
Post: Innodb performance gotcha w Larger queries.
August 28, 2009 By 7 Comments
… nasty going on on Innodb level, so I tried running the test with MyISAM tables instead. The process… kind of performance bug of 5.0. At row0sel.c:row_search_for_mysql() “PHASE 3:”, InnoDB judge…doesn’t have “SELECT” so, InnoDB scan all of the SQL each times… (* “INSERT” may not use this function? “…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 16 Comments
…insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM… of inserts/sec. This time I worked with Innodb tables… …performance of your select queries dramatically. The inserts in this case of course are bulk inserts… using single value inserts…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… does it compare in performance? Â When would I use PBXT instead of a storage engine like MyISAM, InnoDB or XtraDB? Unfortunately it…-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on… I remember reports that PBXT (at an early stage) out performed InnoDB with INSERTS and UPDATES (but not SELECTS). That would make PBXT…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…functionality you need and get the performance you need. Because I’ve built…repairing huge MyISAM tables and taking downtime, I would not use MyISAM for … have to do with InnoDB? Data clustering. InnoDB‘s primary keys define …scale database server for the initial insertion, because you can write CSV …
Post: Redundant index is not always bad
August 28, 2007 By 7 Comments
… for MyISAM, for InnoDB difference will be less. MyISAM uses key-compression for VARCHAR columns, so makes things worse). So to have good performance…` (state_id, city, address) The drawback is worse INSERT performance, here is time to INSERT 1million records: only with state_id KEY – 72…
