Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-35380

Set row format of all tables to dynamic during upgrade

    XMLWordPrintable

Details

    Description

      Tables which were created in older version of MariaDB/Percona/MySQL run with ROW_FORMAT=COMPACT after updating to MariaDB. Since the default is ROW_FORMAT=DYNAMIC starting from MariaDB v10.2.2 the row format of all tables must be changed to DYNAMIC.

      This will prevent unexpected errors like:

      'ERROR 1118 (42000) at line 1: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs'

      Attachments

        Activity

          People

            monty Michael Widenius
            anbanmv Anban Malarvendan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.