MySQL InnoDB - Execution Order

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

MySQL InnoDB - Execution Order

McCully, Dwayne (NIH/NIAMS) [C]

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 order 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 files.

If this is normal,  when will Galaxy create InnoDB tables?   I don’t believe you can create a database with InnoDB.

 

Dwayne


___________________________________________________________
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:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/
Reply | Threaded
Open this post in threaded view
|

Re: MySQL InnoDB - Execution Order

David Trudgian

InnoDB can be set as default:

 

http://serverfault.com/questions/93559/how-do-i-set-the-default-table-type-as-innodb-in-my-cnf

 

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

 

http://dev.mysql.com/doc/refman/5.6/en/innodb-default-se.html

 

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 [mailto:[hidden email]] On Behalf Of McCully, Dwayne (NIH/NIAMS) [C]
Sent: Friday, April 10, 2015 3:54 PM
To: '[hidden email]'
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 order 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 files.

If this is normal,  when will Galaxy create InnoDB tables?   I don’t believe you can create a database with InnoDB.

 

Dwayne



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:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/