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

Re: Changing database tables to different storage engine.

2010-11-22 Thread Machiel Richards
machi...@rdc.co.za To: mysql mailing list mysql@lists.mysql.com 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

Re: Changing database tables to different storage engine.

2010-11-22 Thread John Daisley
not working soon. Machiel -Original Message- From: Machiel Richards machi...@rdc.co.za To: mysql mailing list mysql@lists.mysql.com Subject: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 11:59:03 +0200 Good day all Hope all is well

Re: Changing database tables to different storage engine.

2010-11-22 Thread Machiel Richards
...@gmail.com Cc: mysql mailing list mysql@lists.mysql.com 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_log_file_size is different to the files size on disk (quite common when moving

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 size

Re: Changing database tables to different storage engine.

2010-11-22 Thread Tyler Poland
. Regards Machiel -Original Message- From: John Daisleydaisleyj...@googlemail.com To: Machiel Richardsmachiel.richa...@gmail.com Cc: mysql mailing listmysql@lists.mysql.com Subject: Re: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 10:51:23 + I have

Re: Changing database tables to different storage engine.

2010-11-22 Thread Johan De Meersman
: John Daisleydaisleyj...@googlemail.com To: Machiel Richardsmachiel.richa...@gmail.com Cc: mysql mailing listmysql@lists.mysql.com Subject: Re: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 10:51:23 + I have frequently seen Innodb 'silently' disabled

Re: Changing database tables to different storage engine.

2010-11-22 Thread Kyong Kim
-Original Message- From: John Daisleydaisleyj...@googlemail.com To: Machiel Richardsmachiel.richa...@gmail.com Cc: mysql mailing listmysql@lists.mysql.com Subject: Re: Changing database tables to different storage engine. Date: Mon, 22 Nov 2010 10:51:23 + I have frequently seen