Re: Changing database tables to different storage engine.

2010-11-22 Thread Kyong Kim
be active again I need to >>> restart the database, however aftewards I assume the tables will still >>> be MyIsam. >>> >>>         In this event I will need to manually alter each table, and I am >>> concerned about the impact of this on the sy

Re: Changing database tables to different storage engine.

2010-11-22 Thread Johan De Meersman
I will need to manually alter each table, and I am >> concerned about the impact of this on the system performance. >> >> Regards >> Machiel >> >> >> -Original Message- >> From: John Daisley >> To: Machiel Richards >> Cc: mysql mailing list

Re: Changing database tables to different storage engine.

2010-11-22 Thread Tyler Poland
mance. Regards Machiel -Original Message- From: John Daisley To: Machiel Richards Cc: mysql mailing list Subject: Re: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 10:51:23 + I have frequently seen Innodb 'silently' disabled if the innodb_l

Re: Changing database tables to different storage engine.

2010-11-22 Thread Johan De Meersman
On Mon, Nov 22, 2010 at 11:55 AM, Machiel Richards < machiel.richa...@gmail.com> wrote: >In this event I will need to manually alter each table, and I am > concerned about the impact of this on the system performance. > That will indeed make for quite some locking time, depending on the

Re: Changing database tables to different storage engine.

2010-11-22 Thread Machiel Richards
Machiel -Original Message- From: Machiel Richards To: mysql mailing list Subject: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 11:59:03 +0200 Good day all Hope a

Re: Changing database tables to different storage engine.

2010-11-22 Thread John Daisley
this? I > will look into the innodb not working soon. > > Machiel > > > -Original Message- > From: Machiel Richards > To: mysql mailing list > Subject: Changing database tables to different storage engine. > Date: Mon, 22 Nov 2010 11:59:03 +0200 > > &g

Re: Changing database tables to different storage engine.

2010-11-22 Thread Machiel Richards
To: mysql mailing list Subject: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 11:59:03 +0200 Good day all Hope all is well. I have something to ask as someone might have done this as well and may have a good solution on how to fix this

Changing database tables to different storage engine.

2010-11-22 Thread Machiel Richards
Good day all Hope all is well. I have something to ask as someone might have done this as well and may have a good solution on how to fix this. During a database migration this weekend to move a MySQL database from windows to linux, we created a backup and r