I posted this problem before and heard nothing, but this time I compiled mysqld to debug and have posted some of the debugging output. The following worked fine under 3.23.8. It fails miserably under 3.23.32 - also 3.23.33 but I used 3.23.32 for the output below. It seems that mysqlimport reads and writes the entire data file. At least the .MYD file is roughly the same size as the file being loaded in. At that point, mysqladmin processlist shows a status line indicating the load data infile but then also says 'repair with key cache'. I then have to kill off mysqld or it never finishes. I know the table is good since there is nothing in it and I created it with a mysqladmin create command. mysqladmin flush-tables myisamchk -rq --keys-used=0 /data1/book/book mysqladmin flush-tables mysqlimport book /data2/bip/book # Never gets to the following lines mysqladmin flush-tables myisamchk -rq /data1/book/book mysqladmin flush-tables Here is 235 lines of the debug output. The first thing that looks suspicious to me is on line 48. T@7171 : | | | | | >str_to_TIME T@7171 : | | | | | | enter: str: 1984-06-00 T@7171 : | | | | | <str_to_TIME T@7171 : | | | | | >update_auto_increment T@7171 : | | | | | <update_auto_increment T@7171 : | | | | | >mi_write T@7171 : | | | | | | enter: isam: 9 data: 10 T@7171 : | | | | | | >_mi_readinfo T@7171 : | | | | | | <_mi_readinfo T@7171 : | | | | | | >_mi_rec_pack T@7171 : | | | | | | | exit: packed length: 207 T@7171 : | | | | | | <_mi_rec_pack T@7171 : | | | | | | >write_dynamic_record T@7171 : | | | | | | | >_mi_find_writepos T@7171 : | | | | | | | <_mi_find_writepos T@7171 : | | | | | | | >_mi_write_part_record T@7171 : | | | | | | | | header: Memory: bf5ff360 Bytes: (4) 03 00 CF 01 T@7171 : | | | | | | | <_mi_write_part_record T@7171 : | | | | | | <write_dynamic_record T@7171 : | | | | | | >_mi_writeinfo T@7171 : | | | | | | <_mi_writeinfo T@7171 : | | | | | <mi_write T@7171 : | | | | | >str_to_TIME T@7171 : | | | | | | enter: str: 1984-06-00 T@7171 : | | | | | <str_to_TIME T@7171 : | | | | | >update_auto_increment T@7171 : | | | | | <update_auto_increment T@7171 : | | | | | >mi_write T@7171 : | | | | | | enter: isam: 9 data: 10 T@7171 : | | | | | | >_mi_readinfo T@7171 : | | | | | | <_mi_readinfo T@7171 : | | | | | | >_mi_rec_pack T@7171 : | | | | | | | exit: packed length: 207 T@7171 : | | | | | | <_mi_rec_pack T@7171 : | | | | | | >write_dynamic_record T@7171 : | | | | | | | >_mi_find_writepos T@7171 : | | | | | | | <_mi_find_writepos T@7171 : | | | | | | | >_mi_write_part_record T@7171 : | | | | | | | | header: Memory: bf5ff360 Bytes: (4) 03 00 CF 01 T@7171 : | | | | | | | <_mi_write_part_record T@7171 : | | | | | | <write_dynamic_record T@7171 : | | | | | | >_mi_writeinfo T@7171 : | | | | | | <_mi_writeinfo T@7171 : | | | | | <mi_write T@7171 : | | | | | >my_read T@7171 : | | | | | | my: Fd: 11 Buffer: 40a19008 Count: 129408 MyFlags: 16 T@7171 : | | | | | | warning: Read only 0 bytes off 129408 from 11, errno: -1 T@7171 : | | | | | <my_read T@7171 : | | | | | >update_auto_increment T@7171 : | | | | | <update_auto_increment T@7171 : | | | | | >mi_write T@7171 : | | | | | | enter: isam: 9 data: 10 T@7171 : | | | | | | >_mi_readinfo T@7171 : | | | | | | <_mi_readinfo T@7171 : | | | | | | >_mi_rec_pack T@7171 : | | | | | | | exit: packed length: 41 T@7171 : | | | | | | <_mi_rec_pack T@7171 : | | | | | | >write_dynamic_record T@7171 : | | | | | | | >_mi_find_writepos T@7171 : | | | | | | | <_mi_find_writepos T@7171 : | | | | | | | >_mi_write_part_record T@7171 : | | | | | | | | header: Memory: bf5ff360 Bytes: (3) 01 00 29 T@7171 : | | | | | | | <_mi_write_part_record T@7171 : | | | | | | <write_dynamic_record T@7171 : | | | | | | >_mi_writeinfo T@7171 : | | | | | | <_mi_writeinfo T@7171 : | | | | | <mi_write T@7171 : | | | | <read_sep_field T@7171 : | | | | >mi_extra T@7171 : | | | | | >end_io_cache T@7171 : | | | | | | >flush_io_cache T@7171 : | | | | | | | >my_write T@7171 : | | | | | | | | my: Fd: 10 Buffer: 40a3a008 Count: 508 MyFlags: 36 T@7171 : | | | | | | | <my_write T@7171 : | | | | | | <flush_io_cache T@7171 : | | | | | | >my_free T@7171 : | | | | | | | my: ptr: 40a3a008 T@7171 : | | | | | | <my_free T@7171 : | | | | | <end_io_cache T@7171 : | | | | <mi_extra T@7171 : | | | | >activate_all_index T@7171 : | | | | | >ha_myisam::repair T@7171 : | | | | | | >fn_format T@7171 : | | | | | | | enter: name: ./book/book dsk: form: .MYI flag: 20 T@7171 : | | | | | | | >dirname_part T@7171 : | | | | | | | | enter: './book/book' T@7171 : | | | | | | | <dirname_part T@7171 : | | | | | | | >unpack_dirname T@7171 : | | | | | | | | >dirname_part T@7171 : | | | | | | | | | enter: './book/' T@7171 : | | | | | | | | <dirname_part T@7171 : | | | | | | | | >cleanup_dirname T@7171 : | | | | | | | | | enter: from: './book/' T@7171 : | | | | | | | | | exit: to: './book/' T@7171 : | | | | | | | | <cleanup_dirname T@7171 : | | | | | | | <unpack_dirname T@7171 : | | | | | | | >strlength T@7171 : | | | | | | | <strlength T@7171 : | | | | | | <fn_format T@7171 : | | | | | | >mi_lock_database T@7171 : | | | | | | <mi_lock_database T@7171 : | | | | | | >mi_repair T@7171 : | | | | | | | >init_io_cache T@7171 : | | | | | | | | enter: type: 0 pos: 0 T@7171 : | | | | | | | | >my_tell T@7171 : | | | | | | | | | my: Fd: 10 MyFlags: 0 T@7171 : | | | | | | | | | exit: pos: 9175548 T@7171 : | | | | | | | | <my_tell T@7171 : | | | | | | | | >my_seek T@7171 : | | | | | | | | | my: Fd: 10 Hpos: 0 Pos: 0 Whence: 0 MyFlags: 2 T@7171 : | | | | | | | | <my_seek T@7171 : | | | | | | | | >my_seek T@7171 : | | | | | | | | | my: Fd: 10 Hpos: 0 Pos: 0 Whence: 0 MyFlags: 0 T@7171 : | | | | | | | | <my_seek T@7171 : | | | | | | | | >my_malloc T@7171 : | | | | | | | | | my: Size: 262144 MyFlags: 0 T@7171 : | | | | | | | | | exit: ptr: 40a3a008 T@7171 : | | | | | | | | <my_malloc T@7171 : | | | | | | | | info: init_io_cache: cachesize = 262144 T@7171 : | | | | | | | <init_io_cache T@7171 : | | | | | | | >my_malloc T@7171 : | | | | | | | | my: Size: 1174 MyFlags: 0 T@7171 : | | | | | | | | exit: ptr: 821d0e8 T@7171 : | | | | | | | <my_malloc T@7171 : | | | | | | | >my_seek T@7171 : | | | | | | | | my: Fd: 10 Hpos: 0 Pos: 0 Whence: 0 MyFlags: 2 T@7171 : | | | | | | | <my_seek T@7171 : | | | | | | | >sort_get_next_record T@7171 : | | | | | | | | >_mi_read_cache T@7171 : | | | | | | | | | >my_seek T@7171 : | | | | | | | | | | my: Fd: 10 Hpos: 0 Pos: 0 Whence: 0 MyFlags: 0 T@7171 : | | | | | | | | | <my_seek T@7171 : | | | | | | | | | >my_read T@7171 : | | | | | | | | | | my: Fd: 10 Buffer: 40a3a008 Count: 262144 MyFlags: 16 T@7171 : | | | | | | | | | <my_read T@7171 : | | | | | | | | <_mi_read_cache T@7171 : | | | | | | | | header: Memory: bf5fdc40 Bytes: (20) 03 01 07 01 DC BF 01 00 E1 F5 05 30 38 39 38 31 35 31 37 37 T@7171 : | | | | | | | | >_mi_read_cache T@7171 : | | | | | | | | <_mi_read_cache T@7171 : | | | | | | | | >_mi_rec_unpack T@7171 : | | | | | | | | <_mi_rec_unpack T@7171 : | | | | | | | <sort_get_next_record T@7171 : | | | | | | | >writekeys T@7171 : | | | | | | | | >_mi_make_key T@7171 : | | | | | | | | | exit: keynr: 0 T@7171 : | | | | | | | | | key: Memory: 821c540 Bytes: (8) 05 F5 E1 00 00 00 00 00 Key: "100000000" T@7171 : | | | | | | | | <_mi_make_key T@7171 : | | | | | | | | >_mi_ck_write T@7171 : | | | | | | | | | >_mi_enlarge_root T@7171 : | | | | | | | | | | >_mi_new T@7171 : | | | | | | | | | | | exit: Pos: 1024 T@7171 : | | | | | | | | | | <_mi_new T@7171 : | | | | | | | | | | page: write page at: 1024 T@7171 : | | | | | | | | | | buff: Memory: 821bb90 Bytes: (10) 00 0A 05 F5 E1 00 00 00 00 00 T@7171 : | | | | | | | | | <_mi_enlarge_root T@7171 : | | | | | | | | <_mi_ck_write T@7171 : | | | | | | | | >_mi_make_key T@7171 : | | | | | | | | | exit: keynr: 1 T@7171 : | | | | | | | | | key: Memory: 821c540 Bytes: (92) 57 77 68 61 74 20 63 6F 6C 6F 72 20 69 73 20 79 6F 75 72 20 70 61 72 61 63 68 75 74 65 20 31 39 38 38 20 61 20 70 72 61 63 74 69 63 61 6C 20 6D 61 6E 75 61 6C 20 66 6F 72 20 6A 6F 62 20 68 75 6E 74 65 72 73 20 61 6E 64 20 63 61 72 65 65 72 20 63 68 61 6E 67 65 73 00 00 00 00 Key: "what color is your parachute 1988 a practical manual for job hunters and career changes" T@7171 : | | | | | | | | <_mi_make_key T@7171 : | | | | | | | | >_mi_ck_write T@7171 : | | | | | | | | | >_mi_enlarge_root T@7171 : | | | | | | | | | | test: tot_length: 92 length: 93 uniq_key_length: 87 T@7171 : | | | | | | | | | | >_mi_new T@7171 : | | | | | | | | | | | exit: Pos: 2048 T@7171 : | | | | | | | | | | <_mi_new T@7171 : | | | | | | | | | | page: write page at: 2048 T@7171 : | | | | | | | | | | buff: Memory: 821bb90 Bytes: (95) 00 5F 00 57 77 68 61 74 20 63 6F 6C 6F 72 20 69 73 20 79 6F 75 72 20 70 61 72 61 63 68 75 74 65 20 31 39 38 38 20 61 20 70 72 61 63 74 69 63 61 6C 20 6D 61 6E 75 61 6C 20 66 6F 72 20 6A 6F 62 20 68 75 6E 74 65 72 73 20 61 6E 64 20 63 61 72 65 65 72 20 63 68 61 6E 67 65 73 00 00 00 00 T@7171 : | | | | | | | | | <_mi_enlarge_root T@7171 : | | | | | | | | <_mi_ck_write T@7171 : | | | | | | | | >_mi_make_key T@7171 : | | | | | | | | | exit: keynr: 2 T@7171 : | | | | | | | | | key: Memory: 821c540 Bytes: (15) 0A 30 38 39 38 31 35 31 37 37 35 00 00 00 00 Key: "0898151775" T@7171 : | | | | | | | | <_mi_make_key T@7171 : | | | | | | | | >_mi_ck_write T@7171 : | | | | | | | | | >_mi_enlarge_root T@7171 : | | | | | | | | | | test: tot_length: 15 length: 15 uniq_key_length: 10 T@7171 : | | | | | | | | | | >_mi_new T@7171 : | | | | | | | | | | | exit: Pos: 3072 T@7171 : | | | | | | | | | | <_mi_new T@7171 : | | | | | | | | | | page: write page at: 3072 T@7171 : | | | | | | | | | | buff: Memory: 821bb90 Bytes: (17) 00 11 0A 30 38 39 38 31 35 31 37 37 35 00 00 00 00 T@7171 : | | | | | | | | | <_mi_enlarge_root T@7171 : | | | | | | | | <_mi_ck_write T@7171 : | | | | | | | | >_mi_make_key T@7171 : | | | | | | | | | exit: keynr: 3 T@7171 : | | | | | | | | | key: Memory: 821c540 Bytes: (20) 0F 74 65 6E 20 73 70 65 65 64 20 70 72 65 73 73 00 00 00 00 Key: "ten speed press" T@7171 : | | | | | | | | <_mi_make_key T@7171 : | | | | | | | | >_mi_ck_write T@7171 : | | | | | | | | | >_mi_enlarge_root T@7171 : | | | | | | | | | | test: tot_length: 20 length: 21 uniq_key_length: 15 T@7171 : | | | | | | | | | | >_mi_new T@7171 : | | | | | | | | | | | exit: Pos: 4096 T@7171 : | | | | | | | | | | <_mi_new T@7171 : | | | | | | | | | | page: write page at: 4096 T@7171 : | | | | | | | | | | buff: Memory: 821bb90 Bytes: (23) 00 17 00 0F 74 65 6E 20 73 70 65 65 64 20 70 72 65 73 73 00 00 00 00 T@7171 : | | | | | | | | | <_mi_enlarge_root T@7171 : | | | | | | | | <_mi_ck_write T@7171 : | | | | | | | | >_mi_make_key T@7171 : | | | | | | | | | exit: keynr: 4 T@7171 : | | | | | | | | | key: Memory: 821c540 Bytes: (5) 00 00 00 00 00 Key: "" T@7171 : | | | | | | | | <_mi_make_key T@7171 : | | | | | | | | >_mi_ck_write T@7171 : | | | | | | | | | >_mi_enlarge_root T@7171 : | | | | | | | | | | test: tot_length: 5 length: 5 uniq_key_length: 0 T@7171 : | | | | | | | | | | >_mi_new T@7171 : | | | | | | | | | | | exit: Pos: 5120 T@7171 : | | | | | | | | | | <_mi_new T@7171 : | | | | | | | | | | page: write page at: 5120 T@7171 : | | | | | | | | | | buff: Memory: 821bb90 Bytes: (7) 00 07 00 00 00 00 00 --------------------------------------------------------------------- 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
