MySQL Forums
Forum List  »  MyISAM

Re: 5.5 running tiny queries much slower than 5.0
Posted by: Rick James
Date: July 03, 2012 12:32PM

It should be possible to ALTER the tables to InnoDB, one at a time. However, if you do this, adjust key_buffer_size and innodb_buffer_pool_size periodically.

Also, take advice from the following on changes that might be useful in the INDEXes (esp. the PRIMARY KEYs) when doing the engine change:
http://mysql.rjweb.org/doc.php/myisam2innodb

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: 5.5 running tiny queries much slower than 5.0
1665
July 03, 2012 12:32PM


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.