Change language table from MyISAM to InnoDB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fleiding
    Senior Member
    • Jan 2012
    • 152
    • 5.3.x

    Change language table from MyISAM to InnoDB

    All tables of my database are InnoDB except the language table, which is MyISAM. I tried converting it to InnoDB using the following:
    Code:
    ALTER TABLE language ENGINE=InnoDB
    After running I get the following error:
    Code:
    #1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
    My host informed me that innodb_strict_mode is not enabled and the innodb_log_file_size is on 512MB. Is there any way I can convert the table or can I leave it just as is? Not sure if there would be any increase in performance when changing this table.
  • bootsie1
    Senior Member
    • Jun 2017
    • 150
    • 5.3.x

    #2
    I have a few sites set to MyISAM and a few set to InnoDB and some mixed
    All sites using MySQL 5.7.14 run in InnoDB all sites running 10.2.12-MariaDB is MyISAM and all sites using MySQL8.0.3-rc-log has mixed engines.
    I have not noticed any performance difference in any of them
    Cometbar

    DartsLeague

    Comment

    • Wayne Luke
      vBulletin Technical Support Lead
      • Aug 2000
      • 73981

      #3
      You cannot convert the phrase and language tables to INNODB unless you're using MySQL 5.7 or higher. We will set these tables to MyISAM by default during installation. They rely on Fulltext indexes that aren't available in earlier versions of MySQL and not reliable with INNODB under MySQL 5.6.

      The error has nothing to do with the log file size.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73981

        #4
        Here is the information on dynamic and compressed row types - https://dev.mysql.com/doc/refman/5.7...t-dynamic.html

        I am pretty sure this is the default format in MySQL 5.7.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • Fleiding
          Senior Member
          • Jan 2012
          • 152
          • 5.3.x

          #5
          Thanks, Wayne, I can work with this.

          Comment

          Related Topics

          Collapse

          Working...