Re: Performance issues with INNODB vs MyISAM
Posted by:
Rick James
Date: April 19, 2015 01:22PM
I don't know the details of Drupal or those benchmarks. However, if you could provide SHOW CREATE TABLE and some of the queries that are so much slower, I should be able to spot something.
There are subtle differences between the two engines, so blindly doing ALTER TABLE ... ENGINE=InnoDB is not always sufficient. In this blog, I have itemized most of the things to watch out for:
http://mysql.rjweb.org/doc.php/myisam2innodb
What value do you have for innodb_buffer_pool_size? How much RAM do you have?
Subject
Views
Written By
Posted
2914
April 17, 2015 01:20PM
Re: Performance issues with INNODB vs MyISAM
1232
April 19, 2015 01:22PM
914
April 27, 2015 11:15AM
875
April 28, 2015 10:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.