Re: 5.5 running tiny queries much slower than 5.0
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
Subject
Views
Written By
Posted
3383
June 27, 2012 01:18PM
1742
June 28, 2012 10:08AM
1757
July 01, 2012 01:41PM
1830
July 02, 2012 01:12PM
Re: 5.5 running tiny queries much slower than 5.0
1804
July 03, 2012 12:32PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.