InnoDB can be set as default:

It should also be the default storage engine if you are using MySQL 5.5 or 

Which version of MySQL are you using? 5.5 / 5.6 are generally a lot nicer than 
e.g. 5.1

Dave T

From: galaxy-dev [] On Behalf 
Of McCully, Dwayne (NIH/NIAMS) [C]
Sent: Friday, April 10, 2015 3:54 PM
To: ''
Subject: [galaxy-dev] MySQL InnoDB - Execution Order

Hello Everyone,

The running Galaxy in a production environment documentation states:

"If you are using MySQL<> with 
MyISAM<> table 
engine when Galaxy is in multiprocess configuration, workflow steps will get 
executed out of 
 and fail.
Use InnoDB<> 
engine instead or switch to PostgreSQL<>."

I've enabled InnoDB for my MySQL database via the my.cnf file but the default 
database and database to log all database transactions were created with MyISAM 
If this is normal,  when will Galaxy create InnoDB tables?   I don't believe 
you can create a database with InnoDB.



UT Southwestern

Medical Center

The future of medicine, today.

Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:

To search Galaxy mailing lists use the unified search at:

Reply via email to