XFileSharing Pro - InnoDB

Message
Author
ankurs
Posts: 1054
Joined: Mar 10, 2009 2:34 am

InnoDB

#1 Postby ankurs » Oct 04, 2010 7:49 am

can we convert IP2Files , from MyISAM to InnoDB ? without any modification to script

as InnoDB is more optimized for writes & would help decrease some load on server

User avatar
PilgrimX182
Posts: 2186
Joined: Mar 22, 2006 1:39 pm

#2 Postby PilgrimX182 » Oct 04, 2010 1:40 pm

Sure.

Code: Select all

ALTER TABLE IP2Files ENGINE=InnoDB;
but better clean it up first so this operation won't take hours :)