…is so called “micro” benchmark which concentrates on particular simple storage engine functions and we use it to see performance and scalability…128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… you have to be picky about storage engines you’re using – DRBD does not work with MyISAM (check required) so you need to have processes to ensure your application does not uses this storage engine which may…. First – hot vs cold. If you’re using decent hardware and care about performance you use O_DIRECT with Innodb which makes…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… you’re using MySQL with Innodb (and running MyISAM with DRBD makes little sense…Innodb log to commit it and finally there is record in Binary log to commit transaction followed by commit transaction in Innodb storage engine…we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead …
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 30 Comments
… key value (for Innodb tables) physical file offset (for MyISAM tables) or something else. It is important internally storage engine can use that value…, KEY `i1` (`i1`), KEY `i2` (`i2`), KEY `combined` (`i1`,`i2`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 I made columns i1 and i2 independent…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The …is so called “micro” benchmark which concentrates on particular simple storage engine functions and we use it to see performance and …
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… id=2; … waiting… in 30 sec: ERROR 1031 (HY000): Table storage engine for ‘test2′ doesn’t have this option Strange error message… are InnoDB sessions: Test 1: Deadlock detection (deadlock is correctly detected): insert into test2 values (1,’Mysql’),(2,’Solid’),(3,’MyISAM‘); Session1…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
December 22, 2007 By 117 Comments
[...] InnoDB vs MyISAM vs Falcon benchmarks – part 1 Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. [...]
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
September 6, 2007 By 117 Comments
[...] and commentary available from MySQL Performance Blog at InnoDB vs MyISAM vs Falcon benchmarks – part 1 and Falcon Storage Engine Design [...]
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…This is not simply the case of 32 bytes vs 4 bytes for key value – if you would… cached. It is also worth to note Innodb (which is storage engine which usually considered best for parallel insert/… size so here they are: I’ve created MyISAM tables containing just integer auto_increment primary key…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… and other way around. Even storage engines have very important differences which can…packed rows – quite possible scenario for MyISAM tables. Now if we take … The times for full table scan vs range scan by index: mysql> …There are also clustered keys in Innodb which combine index access with data…
