myisam to innodb
Hello,
We have a db, which has many tables. db size is bigger than 100G, and some tables are myisam, some tables are innodb.
The server is a virtual server, and many time we have read-only file system problem.
One of our myisam table is more than 3 million lines, myd file 50G.
I think, there might be a performance problem to write-read 50G file.
What would happen we convert this table to innodb ? Which methods you prefer ?
Thanks.
Subject
Views
Written By
Posted
myisam to innodb
1688
March 12, 2015 09:24AM
882
March 13, 2015 07:16PM
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.