Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-24857

Create MySQL tables using InnoDB engine by default - session variable

    XMLWordPrintable

    Details

      Description

      With JIRA 4.3+ we require users to use InnoDB storage engine when integrating with MySQL

      http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+MySQL#ConnectingJIRAtoMySQL-2.CreateandConfiguretheMySQLDatabase

      However, this isn't the default engine for MySQL (MYISAM) also for various reason ppl may not wish to change the default engine to suite our application.

      Anyway, this request is completely unnecessary as MySQL allows to define storage_engine as an attribute for a session.

      Funny enough other ATL product already use it... Confluence or Bamboo:

      http://confluence.atlassian.com/display/BAMBOO/MySQL+5.x

      Unaware users will see in fatal errors in their log file:

      2011-06-01 23:26:55,334 main ERROR      [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
      CREATE INDEX idx_goup_attr_dir_name_lval ON cwd_group_attributes (directory_id, attribute_name, lower_attribute_value)
      Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 1000 bytes
      SQL Exception while executing the following:
      CREATE UNIQUE INDEX uk_group_attr_name_lval ON cwd_group_attributes (group_id, attribute_name, lower_attribute_value)
      

      Currently our configurer (config.sh/bat) does not allow to set this attribute on the connection.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mlassau Mark Lassau (Inactive)
              Reporter:
              bdziedzic Bogdan Dziedzic [Atlassian]
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: