Re: [Openstack] [Nova] MySQL drivers in DB

2011-10-12 Thread Pitucha, Stanislaw Izaak
@lists.launchpad.net Subject: Re: [Openstack] [Nova] MySQL drivers in DB +1 on modifying it in your environment, this seems outside the scope of migrations, though perhaps listed as a best practice for the deployment process. Similarly, I have been trying to decide what makes sense for indexes. Right now

Re: [Openstack] [Nova] MySQL drivers in DB

2011-10-12 Thread Jay Pipes
On Wed, Oct 12, 2011 at 7:54 AM, Gabe Westmaas gabe.westm...@rackspace.com wrote: +1 on modifying it in your environment,  this seems outside the scope of migrations, though perhaps listed as a best practice for the deployment process. +1 Similarly, I have been trying to decide what makes

Re: [Openstack] [Nova] MySQL drivers in DB

2011-10-11 Thread Monty Taylor
I do not know from where that comes, but I would consider it a bug and that there is no good reason in this context to be using MyISAM for any purpose. On 10/11/2011 01:55 PM, Nick Sokolov wrote: Hi stackers! I noticed, that tables in database use two database engines instead of two, but

Re: [Openstack] [Nova] MySQL drivers in DB

2011-10-11 Thread Monty Taylor
On 10/11/2011 02:15 PM, Vishvananda Ishaya wrote: For some reason tables are getting created as default type. There is a migration in the history to convert tables to InnoDB, but anything created after that migration will go in as the default type. We can add another migration to convert