Installed XenForo using MyISAM; had skip-innodb set and our default engine set. Looking to convert those tables that are not setup as MyISAM or MEMORY to InnoDB; as XenForo would prefer. (re: http://xenforo.com/community/threads/mysql-myisam-or-innodb.388/page-3#post-258835)
I have no problem converting the tables (re: http://xenforo.com/community/threads/some-server-log-errors.26959/#post-323255), but I'm not overly familiar with the InnoDB engine or settings so I'm looking for some basic must have settings / tips.
- MySQL is on a dedicated 16 core server w/ 8GB.
- Some tables are MyISAM, some are InnoDB; as per XenForo and previous custom tables.