MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Very high disk utilization by mysql server during reads.
Posted by: Rick James
Date: July 10, 2012 09:47AM

> How much performance improvement do you expect if I use Innodb engine instead of Myisam?

There is no simple answer. There are cases where InnoDB is faster; there are cases for MyISAM. When switching engine, you _may_ need to change the indexes. See http://mysql.rjweb.org/doc.php/myisam2innodb

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Very high disk utilization by mysql server during reads.
4029
Shantanu B
July 05, 2012 12:49PM
Re: Very high disk utilization by mysql server during reads.
1508
Aftab Khan
July 06, 2012 02:51AM
Re: Very high disk utilization by mysql server during reads.
1377
Shantanu B
July 06, 2012 10:38AM
Re: Very high disk utilization by mysql server during reads.
1361
Aftab Khan
July 07, 2012 06:07AM
Re: Very high disk utilization by mysql server during reads.
1261
Rick James
July 07, 2012 12:34PM
Re: Very high disk utilization by mysql server during reads.
1176
Shantanu B
July 09, 2012 01:59PM
Re: Very high disk utilization by mysql server during reads.
1211
Rick James
July 10, 2012 09:47AM


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.