<div>
<a href="http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html" rel="ugc nofollow">http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html</a> says it is an unsupported operation.<br />
<br />
So you've (db2inst1) have done this twice before or you were just testing it?
</div>


http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html [http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html] says it is an unsupported operation.

So you've (db2inst1) have done this twice before or you were just testing it?

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; I've got a table with 110k records. Reads/Writes are a little slow. I'm using MyISAM for the table. Considering the size and speed problems, will making the table InnoDB improve things?<br />
&nbsp; I'm using MySQL 5.0.22. &nbsp;I also read that MySQL cautions this conversion as being unsupported. <br />
<br />
(1) Anyone with any thoughts/experience on doing this?<br />
(2) Anyone with any thoughts on my specific situation?<br />
<br />
Thanks.
</div>
</div>


Hi,
  I've got a table with 110k records. Reads/Writes are a little slow. I'm using MyISAM for the table. Considering the size and speed problems, will making the table InnoDB improve things?
  I'm using MySQL 5.0.22.  I also read that MySQL cautions this conversion as being unsupported. 

(1) Anyone with any thoughts/experience on doing this?
(2) Anyone with any thoughts on my specific situation?

Thanks.

Converting tables from MyISAM to InnoDB

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.