Ilya,
actually, it may be safest that you use CREATE TABLE to create
an identical InnoDB table, and then do
INSERT INTO newtable SELECT * FROM oldtable WHERE yourkey > something
AND yourkey < somethingelse;
In this way you can divide the insertion into pieces, and you have
better control on what is happening. After all data is inserted,
you can rename tables.
Regard,
Heikki
At 04:22 PM 5/22/01 +0400, you wrote:
>
>Thanks for info.
>
>HT> Ilya,
>HT> ALTER TABLE should be faster: InnoDB does not have special optimization
>HT> for separate index creation. Therefore the fastest way is to do the inserts
>HT> directly to an InnoDB table.
>
>HT> You should set the InnoDB buffer pool size big during the
>HT> transition, to reduce disk i/o. Not bigger than 80 % of the physical
>HT> memory, though. You should set InnoDB log files big, as described in the
>HT> manual at http://www.innobase.fi, and also the log buffer to 8 MB,
>HT> for example.
>
>HT> Make sure you do not run out of tablespace: InnoDB tables take a lot
>HT> more space than MyISAM tables. If an ALTER TABLE runs out of space,
>HT> it will start a rollback, and that can take hours if it is disk bound.
>HT> In that case it is better that you kill the database process and
>HT> delete all InnoDB files and all InnoDB table .frm files, and start
>HT> your job again, rather than wait millions of disk i/os to complete.
>
>HT> Regards,
>
>HT> Heikki Tuuri
>HT> Innobase Oy
>
>--
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>| Ilya Martynov (http://martynov.org/) |
>| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
>| AGAVA Software Company (http://www.agava.com/) |
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
