News for hackers. Stuff that matters.
Re:Scaling MongoDB at Mailbox by dkhenry on Thursday September 12, 2013 @03:11PM (#6376250)
MySQL has a few engines that still have a database level lock ( MyISAM, MEMORY ) and those generally preform better for unbalanced loads ( i.e very read heavy or very write heavy )
Re:Scaling MongoDB at Mailbox by jeltz on Thursday September 12, 2013 @06:00PM (#6377271)
Do you have any source for this? While logic suggests that they should (but perhaps only very slightly) I think InnoDD has got a lot of more optimization work than any other engine.

A benchmark from Oracle shows InnoDB as being much faster on a read-only workload.

http://www.oracle.com/partners/en/knowledge-zone/mysql-5-5-i...

EDIT: By the way the locks are table level in MyISAM and Memory.