Shard-Query (source) now supports the MySQL “LOAD DATA INFILE” command.
When you use LOAD DATA LOCAL INFILE a single threaded load from the current process will be performed. You can specify a path to a file anywhere readable by the PHP script. This allows loading without using the Gearman workers and without using a shared filesystem.
If you do not specify LOCAL, then the Gearman based loader is used. You must not specify a path to the file when you omit the LOCAL keyword. This …[Read more...]