alter table engine problems

If something doesn't fit in any other forum then post it here.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
blacksea
Posts: 458
Joined: Fri Oct 05, 2007 1:29 am

alter table engine problems

Post 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...
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: alter table engine problems

Post by momo61 »

i think that because the item table changes a lot, you should keep it myisam (or innodb, im not sure)
blacksea
Posts: 458
Joined: Fri Oct 05, 2007 1:29 am

Re: alter table engine problems

Post by blacksea »

myisam is not so good for some tables...
Post Reply