Hi,
We recently decided to start switching on InnoDB for some our web
projects. We have tested InnoDB on test machines and have been
satisifed with results. Now the question: how can we minimize downtime
on production server during transition?
We see two choises:
1) change mysql server to
Ilya,
actually, it may be safest that you use CREATE TABLE to create
an identical InnoDB table, and then do
INSERT INTO newtable SELECT * FROM oldtable WHERE yourkey something
AND yourkey somethingelse;
In this way you can divide the insertion
Thanks for idea again :)
HT Ilya,
HT actually, it may be safest that you use CREATE TABLE to create
HT an identical InnoDB table, and then do
HT INSERT INTO newtable SELECT * FROM oldtable WHERE yourkey something
HT AND yourkey somethingelse;
HT