Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved innoDB merge slow? How can I make this faster?
#1
Not Solved
So, instead of waiting forever for the MyISAM posts table (as it's huge and wampserver seems to freeze when trying to switch over) I thought about importing them into an InnoDB MyBB that's already set up and already set as InnoDB. But, it's horribly slow.

Merging to an MyISAM table I can get through the posts within 2 hours (for 1 million). But, the timing for doing a InnoDB is sitting at 30 hours. :/

Anyone know how to make this faster?
#2
Not Solved
last time I convert around 1,8 millions post from MyIsam into innoDB only took less than an hour on dedicated server, and takes longer many times if using local server under windows Smile
Hello, Welcome to MyBB Indonesia to get local support
My 'Simple' Unique Plugin here Smile
#3
Not Solved
Quote:wampserver
I think we've found your issue.
#4
Not Solved
I ended up just doing MYISAM takes less than an hour to do that and I can convert to innodb after it.

I use wampserver because it's what documentations constantly recommend for Windows 8 users for offline conversions.


Forum Jump:


Users browsing this thread: 1 Guest(s)