I'm migrating JIRA in Windows from HSQL to MySQL and I got stuck with the message Unknown system variable 'storage_engine'. Though I created a backup, installed MySQL and copied J connector to libs of JIRA.

Then I set the system variable storage_engine = InnoDB and rebooted the machine but the message is still there.

Could you please point me to a good direction.


If you are using MySQL 5.6, InnoDB is already the default.

Please do not use storage-engine because it is deprecated and probably explains the error.

You should use default-storage-engine or default_storage_engine in my.cnf instead

default-storage-engine = InnoDB


|improve this answer|||||

It' already a known Issue in Confluence Docs:

  1. Stop Confluence
  2. Edit <confluence-home>/confluence.cfg.xml
  3. Look for a line similar to:

    <property name="hibernate.connection.url">jdbc:mysql://localhost/confluence?sessionVariables=storage_engine%3DInnoDB&useUnicode=true&characterEncoding=utf8</property>
  4. Remove storage_engine%3DInnoDB& from the line, it should look like:

    <property name="hibernate.connection.url">jdbc:mysql://localhost/confluence?sessionVariables=useUnicode=true&characterEncoding=utf8</property>
  5. Start Confluence

|improve this answer|||||
  • This is for confluence, not jira. – sweetfa May 13 '16 at 6:20

If using Mysql 7 and Jira 7 change the connection string in the mysql.properties file.

sudo vi ${JIRA_APPLICATION_DIR}/atlassian-jira/WEB-INF/classes/database-defaults/mysql.properties 

Find the line starting with databaseUrl=


and remove


Save the file and restart jira (Ubuntu 16.04 or any linux)

sudo service jira restart
|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.