3 ms·
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 o
by dkhenry 13y ago
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 )
- jeltz 13y agoDo 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-innodb-myisam-522945.pdf 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.