Henry, Saturday, February 02, 2002, 12:25:16 AM, you wrote: HH> Hello,
HH> Under mysql 3.22.29, I was able to use isamchk to disable all index keys (-r HH> -k0), do millions of inserts into the table, then re-enable all the indexes HH> again with "isamchk -r -k4" (4 indexes). I'm testing out a new Redhat 7.2 HH> Linux server with mysql 3.23.41, and am attempting to load a table with 30 HH> million records, then re-enable the indexes. So, I use: HH> myisamchk -r -k0 new_table HH> - recovering (with keycache) MyISAM-table 'new_table.MYI' HH> Data records: 0 HH> I then use an : HH> insert into new_table from old_table; HH> To load the table, but mysql still attempts to build the index file (MYI), HH> greatly slowing down the table load. How can I entirely disable all indexes HH> for a table, load it, then re-enable? Like I said, this is how it used to work HH> under isamchk under 3.22.29. HH> BTW, I am aware that myisamchk uses a bitmap to re-enable the indexes, but I HH> haven't gotten to that point, since the indexes are being built upon the data HH> load. Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html HH> Thanks, HH> -Hank -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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
