Introduction of Pt-fifo-split Usage of the PT tool of MySQL

In the work used to also more, in the load data large file, if the file too assembly lead to the problem of master-slave delay, it must be split into many small files, the use of this tool does not require manual cutting files.

This tool works only on Unix-like operating systems. Specific can be viewed: http://www.mysqlperformanceblog.com/2008/07/03/how-to-load-large-files-safely-into-innodb-with-load-data-infile/

Execute the following command in a session:

Perl pt-fifo-split infile.txt--fifo/tmp/my-fifo--lines 1000000
Execute the following command in another session:

while [-e/tmp/my-fifo]; Todo
Time Mysql-e "Set foreign_key_checks=0; Set sql_log_bin=0; Set unique_checks=0; Load data local infile '/tmp/my-fifo ' to table load_test fields terminated by ' \ t ' lines terminated by ' \ n ' (col1, col2) ;"
Sleep 1;
Done