On Mon, Mar 20, 2006 at 06:27:22PM -, Jorge Bastos wrote:
> DecimalHi,
>
> There's no problem to set dbmail tables from MyISAM to InnoDB directly?
One thing to keep in mind (especially if you have big tables) is that
the table(s) will be write-locked until the ALTER is complete. This
might b
t;Matthew Sayler" <[EMAIL PROTECTED]>
To: "DBMail mailinglist"
Sent: Monday, March 20, 2006 7:02 PM
Subject: Re: [Dbmail] MyISAM to InnoDB
On Mon, Mar 20, 2006 at 06:27:22PM -, Jorge Bastos wrote:
DecimalHi,
There's no problem to set dbmail tables from MyI
On Mon, Mar 20, 2006 at 07:27:03PM -, Jorge Bastos wrote:
> I see, i'll just stop postfix and dbmail when i'll do it
> Just one more question to make sure i do the right thing, how do you advise
> to do it?
> This is the normal procedure right?
>
> "ALTER TABLE table_name ENGINE = InnoDB;"
A
Simon,
Simon wrote:
> set unique_checks=0;
> alter table dbmail_users type=innodb;
> ... etc ...
> set unique_checks=1;
>
> This seems to have worked fine on my dev server, shutting down dbmail
> before doing so... My question is: Is there any small tweaks needed
> within mysql before doing thi
On 7/10/06, Paul J Stevens <[EMAIL PROTECTED]> wrote:
Simon,
Simon wrote:
> set unique_checks=0;
> alter table dbmail_users type=innodb;
> ... etc ...
> set unique_checks=1;
>
> This seems to have worked fine on my dev server, shutting down dbmail
> before doing so... My question is: Is there
Hello all,
Does anyone know if this procedure has been documented anywhere?
Best,
Adam
jurgen wrote:
One thing to watch out for is the innodb_data_file_path sting. That
controls how big individual innodb files are allowed to get, and if
they're allowed to grow. The default on my system (Gentoo
One thing to watch out for is the innodb_data_file_path sting. That
controls how big individual innodb files are allowed to get, and if
they're allowed to grow. The default on my system (Gentoo 2006.0) was
an unreasonably small number, and importing my initial load of
messages would always fail sh