> > not sure, though, feel free to report test results Results not good so far. I created a big load file by creating a list of all the files on my server (using "find / -printf ...). and appending that file four of five times over for several hundred thousand rows.
Then I did a LOAD DATA CONCURRENT INFILE 'my_big_file'... While that was running, I ran a SELECT COUNT(*) query in another session. The latter was blocked until the former finished every time. And this wasn't even using merged tables, but rather just a single myisam table. Looks like the concurrent select thing described in the documentation doesn't even work as advertised for even this simple case. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org