Re: mysqlimport --use-threads / mysqladmin processlist

2012-07-25 Thread Róbert Kohányi
Yes, the rows are in primary key order, however each row contains specific integer primary keys; I'm not inserting nulls into a table where the primary key is auto increment, so I don't see why concurrent inserts would fight for similar spots (although, I'm admittedly not a MySQL hotshot, so the ba

RE: mysqlimport --use-threads / mysqladmin processlist

2012-07-25 Thread Rick James
I'm skeptical that use-treads can every be very effective. What order are the rows in? They are probably in PRIMARY KEY order, which means that the INSERTing threads will be fighting over similar spots in the table. Is it I/O bound when it is single-threaded? If so, then there can't be any i