Uploaded image for project: 'Offre de formation'
  1. Offre de formation
  2. ODF-1269

InnoDB integration: we should use the feature ROW_FORMAT=COMPRESSED when creating tables

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 2.5.3
    • None
    • None
    • None

      In order to avoid:
      "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."

      Which occurs when exceeding the amount of data that can be stored in one row. The compression allows to circumvent this, provided the file format used is "barracuda", which is not necessarily the default format depending on the version of mysql.

      To ensure that this is the case, the 2 lines below should be added to the [mysqld] section of the "my.cnf" configuration file of MySQL (Linux) or "my.ini" file (Windows), and the service restarted with the new configuration.

      innodb_file_per_table=1 
      innodb_file_format=barracuda
      

            Unassigned Unassigned
            quentin Quentin Glinel-Mortreuil (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: