News for hackers. Stuff that matters.
Re:NoSQL databases benchmark: Cassandra, HBase, MongoDB, Riak by HarrisonFisk on Friday November 02, 2012 @01:35PM (#4733773)
I wonder why they picked MyISAM for MySQL, since basically no one sane is using that anymore. It isn't even the default anymore, so that can't be the excuse.

"MyISAM caches index blocks but not data blocks."

Re:NoSQL databases benchmark: Cassandra, HBase, MongoDB, Riak by elchief on Friday November 02, 2012 @07:40PM (#4735301)
MyISAM is fast at reads. You can use innodb for the transactional, writeable master, and replicate to MyISAM for read-only slaves. This also gives you full-text search.
Re:NoSQL databases benchmark: Cassandra, HBase, MongoDB, Riak by HarrisonFisk on Friday November 02, 2012 @07:47PM (#4735327)
Then your slaves will lag really badly while the replication thread keeps stalling on table level locks.

InnoDB is faster at reads for most workloads on modern hardware. MyISAM has horrible scalability across multiple CPUs. MariaDB recently improved in MyISAM with the segmented key cache, but I haven't seen any results of head-to-head benchmarks since then.