alter table engine problems
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 458
- Joined: Fri Oct 05, 2007 1:29 am
alter table engine problems
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...
- momo61
- Posts: 1648
- Joined: Fri Jun 06, 2008 2:05 pm
- Location: Europe
Re: alter table engine problems
i think that because the item table changes a lot, you should keep it myisam (or innodb, im not sure)
-
- Posts: 458
- Joined: Fri Oct 05, 2007 1:29 am
Re: alter table engine problems
myisam is not so good for some tables...