… in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is… RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… performance gotcha illustration purposes. The benchmark shows following results for MyISAM using MySQL 5.0.45 run on 4 Core System: Threads… Cores. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for MyISAM key cache contention issue…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… SubQueries avoided for MySQL) so do not just compare it directly. It also does not mention if Innodb or MyISAM tables are used… to see CPU comparison in this test. Woodcrest has best performance in this test (and in many other MySQL tests), Opteron comes… much better on this picture Linux vs Solaris comparison is also pretty interesting. With MySQL Linux has higher peak but Solaris suffers…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… efficient if you would like optimal structure both for MyISAM and Innodb tables, however it is not as convenient to …(IS ” would not work) or you can use Null-Aware comparison operator: mysql> select count(*) from cbool where c1NULL; +———-+ | count(*) | +———-+ | 1048576 | +———-+ …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…view but this is not the point of comparison. “Failback could destroy the original master tooâ€, …production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb Transactional log which…you’re using – DRBD does not work with MyISAM (check required) so you need to have …
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… it possible to connect to Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when…. Another thought – with Innodb Full Text Search coming up in MySQL 5.6 and Claimed to be faster than MyISAM‘s I really… to its Real Time indexes. Some easy to understand feature comparison table would also be helpful as in many cases people…
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… decided to benchmark. The results below are for MySQL 5.1.18 using MyISAM and Innodb tables. This time unlike other benchmarks I… convert Innodb table to latin1 character set. I was expected this to shorten some internal buffers MySQL has to allocate for key comparison as well as have comparison function significantly faster. The reason…
Post: FreeBSD tests
June 15, 2006 By 15 Comments
… (in transactions/sec, more is better. for comparison the results from Suse 10.0): InnoDB threads FreeBSD 6 Suse 10.0 Suse… ASUS A8N-E MySQL 5.0.22 params for InnoDB: –innodb-buffer-pool-size=500M –max-connections=500 params for MyISAM: –key-buffer-size=500M –max-connections=500 –skip-innodb Suse…
Post: Quick look at Ubuntu 6.06
June 13, 2006 By 3 Comments
….4.6 oltp-read-only workload with 1000000 rows against InnoDB and MyISAM tables. Such workload is CPU-bound and allows to compare CPU / OS if we are using the same version of MySQL. So I used MySQL 5.0.22 and my box Dual Core Athlon 3800+, 1Gb of RAM. For comparison I…
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. [...]
