1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Converting to InnoDB

Discussion in 'Server Configuration and Hosting' started by Hardcore, Feb 27, 2012.

  1. Hardcore

    Hardcore Active Member

    Hey there -

    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.
    Any help would be appreciated.

  2. Mike

    Mike XenForo Developer Staff Member

    Todd @ BA likes this.
  3. Slavik

    Slavik XenForo Moderator Staff Member

    The main setting you want to look at is innodb_buffer_pool_size

    Set it to whatever your database size is +20%

    So if your db is 1gb, set the buffer pool to 1.2gb
    Todd @ BA likes this.
  4. Hardcore

    Hardcore Active Member

    Thanks Mike. Am I also right in assuming that most the current my.cnf setting can still remain so long as I'm still using MySIAM tables too?
  5. Mike

    Mike XenForo Developer Staff Member

    Yeah, generally speaking. Though as you use less MyISAM, you may be able to turn some values down.
  6. Hardcore

    Hardcore Active Member


    Though during my test I discovered a typo in this recommended script: http://xenforo.com/community/threads/some-server-log-errors.26959/#post-323255

    Should be:

    Had to move all /var/lib/mysql/ib* files to a temp directory too. They were lingering from the sever's defaults before I tweaked it for MyISAM and wasn't allowing InnoDB to work.

    Thanks again all. I think I'm going to like working with InnoDB.
    D.O.A., Slavik and Mike like this.

Share This Page