Hi!
I measured the following import speeds with different types of
LOAD TABLE INFILE, which is used by mysqlimport.
Since autocommit does not commit the transaction during
a LOAD TABLE INFILE, there is little difference whether one
uses LOW_PRIORITY or CONCURRENT, or none.
Regards,
Heikki
http
ryc writes:
> My application needs to insert between 200-500k rows about once a day...
> When using MyISAM tables I determined the best way to get this done (while
> still allowing users to perform select statements from the table) was to use
> mysqlimport with --low-priority. This way all the ins
My application needs to insert between 200-500k rows about once a day...
When using MyISAM tables I determined the best way to get this done (while
still allowing users to perform select statements from the table) was to use
mysqlimport with --low-priority. This way all the inserts get bundled up
