I spend months evaluating xF, testing my conversion, and today I finally pull the trigger on my biggest site conversion. I'm 6 hours into the conversion (to give you an idea it took 2 hours to import posts / topics) and then while my search cache rebuild is underway I decide to browse the forum here.
Well, I stumble on this MySQL: MyISAM or INNODB thread and check my tables...
EVERY SINGLE ONE OF THEM IS MyISAM!!!
So, what do I do? I mean, my forum seems to be running fine, but it also hasn't been hammered by a bunch of concurrent users yet.
The last time I tried to convert a platform from MyISAM to INNODB (another project different platform) it went terribly terribly wrong and I had to do a full server restore and roll back to MyISAM. The thought of going through that again is terrifying at best.
So my questions for the masters:
- Why the heck on a brand new install weren't the correct table structures setup?
- Do I "have to" convert the tables to INNODB?
- What happens if I don't convert to INNODB?
Some of my tables aren't super huge, but also not tiny:
I'm kinda freaking out about this, so thanks in advance for your help and suggestions!