…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 …128 MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several… when single query executed being 1/3rd of MyISAM and 1/6th of Innodb. On other hand it scales quite nicely as… Cores. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for MyISAM key cache contention issue…
Comment: Testing MySQL column stores
August 16, 2010 By 15 Comments
… columns. As for a MyISAM/InnoDB comparison, it does not make sense to test the same queries on MyISAM/InnoDB since most of them would take significantly longer to run. Just loading the data would take significantly longer, since MyISAM/InnoDB…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… most efficient if you would like optimal structure both for MyISAM and Innodb tables, however it is not as convenient to work… (IS ” would not work) or you can use Null-Aware comparison operator: mysql> select count(*) from cbool where c1NULL; +———-+ | count(*) | +———-+ | 1048576…
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… about Innodb ? Innodb executed the same query in 2.9 seconds which was a bit disappointing for me as I expected MyISAM to… Innodb table to latin1 character set. I was expected this to shorten some internal buffers MySQL has to allocate for key comparison… can range from few percent to couple of times for Innodb tables MyISAM Tables may suffer significantly if key compression is not…
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… better than Suse in InnoDB benchmark. I think it is related to InnoDB‘s implementation of syncronious primitives. For MyISAM Suse is stable… 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: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… just compare it directly. It also does not mention if Innodb or MyISAM tables are used – it turns out Both are used… full solution yet. It is also interesting to see CPU comparison in this test. Woodcrest has best performance in this test… is seen much better on this picture Linux vs Solaris comparison is also pretty interesting. With MySQL Linux has higher peak…
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. [...]
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… my box Dual Core Athlon 3800+, 1Gb of RAM. For comparison I tested the same workload on my primary Suse 10…. Here are results (in transactions per sec, more is better): InnoDB threads Ubuntu 6.06 Suse 10.0 Suse/ Ubuntu ratio…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…of view but this is not the point of comparison. “Failback could destroy the original master tooâ€, however… HA I often have 15+ minutes reply of Innodb Transactional log which would be a huge bummer … you’re using – DRBD does not work with MyISAM (check required) so you need to have processes …
