Page 1 of 1

alter table engine problems

Posted: Wed Sep 30, 2009 1:11 pm
by blacksea
How can i change easy engine from a table i try with alter but after 4 hours still didnt finished, also i dumped the table changed to innodb but same 30 min didnt finished and i stopped... i try to change items from myisam to innodb , table items size = about 700MB , also i noticed after i changed table characters from myisam to innodb server didnt started even in 10 min and i changed back to myisam...

Re: alter table engine problems

Posted: Thu Oct 01, 2009 12:25 am
by momo61
i think that because the item table changes a lot, you should keep it myisam (or innodb, im not sure)

Re: alter table engine problems

Posted: Thu Oct 01, 2009 10:58 am
by blacksea
myisam is not so good for some tables...