# do you recommend change MyISAM to InnoDB ?

**URL:** <https://forums.percona.com/t/do-you-recommend-change-myisam-to-innodb/1417>\
**Category:** Other MySQL® Questions\
**Created:** [May 28, 2010, 12:43am UTC](https://forums.percona.com/t/do-you-recommend-change-myisam-to-innodb/1417 "2010-05-28T00:43:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![silent-ion](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@silent-ion](https://forums.percona.com/u/silent-ion)\
**Post date:** [May 28, 2010, 12:43am UTC](https://forums.percona.com/t/do-you-recommend-change-myisam-to-innodb/1417/1 "2010-05-28T00:43:00Z")

</div>

Com\_replace 1714Com\_insert 44551Com\_delete 417231Com\_update 794975Com\_select 660554Table\_locks\_immediate 2177056 Table\_locks\_waited 1525

do you recommend change MyISAM to InnoDB ?

And if I decide to change storage engine, can I change it by mysqldump, just change from MyISAM to InnoDB in dump? and can I do MyISAM → InnoDB, InnoDB → MyISAM convert by mysqldump?

thanks a lot

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [May 29, 2010, 6:30am UTC](https://forums.percona.com/t/do-you-recommend-change-myisam-to-innodb/1417/2 "2010-05-29T06:30:40Z")

</div>

innodb has many other advantages other than row level locking. [URL][http://en.wikipedia.org/wiki/InnoDB[/URL]](http://en.wikipedia.org/wiki/InnoDB%5B/URL%5D)

The only disadvantage is that row size increases by 18 bytes, which is very noticable if you have a very large table with very small row size.

easiest way is alter table yourtbl engine=innodb;

---

<div class="post-metadata">

**Author:** ![silent-ion](https://avatars.discourse-cdn.com/v4/letter/s/da6949/32.png) [@silent-ion](https://forums.percona.com/u/silent-ion)\
**Post date:** [May 29, 2010, 6:47am UTC](https://forums.percona.com/t/do-you-recommend-change-myisam-to-innodb/1417/3 "2010-05-29T06:47:44Z")

</div>

But Am I right that if number of select queries \<= update,insert queries than Inndb is more preferable?  
But I’m still in hesitation, because Table\_locks\_waited is not big as I expected.