10行 gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10.txt' into table testload fields terminated by ','; Query OK, 10 rows affected (Elapsed: 00:00:06.42) Task 4104 finished, Loaded 10 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10.txt' into table testload fields terminated by ','; Query OK, 10 rows affected (Elapsed: 00:00:08.57) Task 4105 finished, Loaded 10 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10.txt' into table testload fields terminated by ','; Query OK, 10 rows affected (Elapsed: 00:00:08.45) Task 4106 finished, Loaded 10 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10.txt' into table testload fields terminated by ','; Query OK, 10 rows affected (Elapsed: 00:00:08.18) Task 4107 finished, Loaded 10 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10.txt' into table testload fields terminated by ','; Query OK, 10 rows affected (Elapsed: 00:00:05.16) Task 4108 finished, Loaded 10 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/100.txt' into table testload fields terminated by ','; Query OK, 100 rows affected (Elapsed: 00:00:08.53) Task 4109 finished, Loaded 100 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/100.txt' into table testload fields terminated by ','; Query OK, 100 rows affected (Elapsed: 00:00:08.00) Task 4110 finished, Loaded 100 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/100.txt' into table testload fields terminated by ','; Query OK, 100 rows affected (Elapsed: 00:00:08.10) Task 4111 finished, Loaded 100 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/100.txt' into table testload fields terminated by ','; Query OK, 100 rows affected (Elapsed: 00:00:06.32) Task 4112 finished, Loaded 100 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/100.txt' into table testload fields terminated by ','; Query OK, 100 rows affected (Elapsed: 00:00:07.75) Task 4113 finished, Loaded 100 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:08.96) Task 4114 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:09.13) Task 4115 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:18.90) Task 4116 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:09.40) Task 4117 finished, Loaded 1000 records, Skipped 0 records gbase> select count(*) from testload; +----------+ | count(*) | +----------+ | 4550 | +----------+ 1 row in set (Elapsed: 00:00:00.00) gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:06.26) Task 4118 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:09.21) Task 4119 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:18.80) Task 4120 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:14.15) Task 4121 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:08.74) Task 4122 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:08.96) Task 4123 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:09.38) Task 4124 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:09.34) Task 4125 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:07.30) Task 4126 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:10.61) Task 4127 finished, Loaded 1000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/1000.txt' into table testload fields terminated by ','; Query OK, 1000 rows affected (Elapsed: 00:00:09.13) Task 4128 finished, Loaded 1000 records, Skipped 0 records gbase> select now();load data infile 'ftp://gbase:gbase1234@10.0.2.101/1w.txt' into table testload fields terminated by ','; +---------------------+ | now() | +---------------------+ | 2021-02-02 15:16:42 | +---------------------+ 1 row in set (Elapsed: 00:00:00.00) Query OK, 10000 rows affected (Elapsed: 00:00:14.63) Task 4129 finished, Loaded 10000 records, Skipped 1 records gbase> select now();load data infile 'ftp://gbase:gbase1234@10.0.2.101/1w.txt' into table testload fields terminated by ','; +---------------------+ | now() | +---------------------+ | 2021-02-02 15:20:47 | +---------------------+ 1 row in set (Elapsed: 00:00:00.00) Query OK, 10000 rows affected (Elapsed: 00:00:15.59) Task 4130 finished, Loaded 10000 records, Skipped 1 records gbase> select now();load data infile 'ftp://gbase:gbase1234@10.0.2.101/1w.txt' into table testload fields terminated by ','; +---------------------+ | now() | +---------------------+ | 2021-02-02 15:21:05 | +---------------------+ 1 row in set (Elapsed: 00:00:00.00) Query OK, 10000 rows affected (Elapsed: 00:00:16.27) Task 4131 finished, Loaded 10000 records, Skipped 1 records gbase> select now();load data infile 'ftp://gbase:gbase1234@10.0.2.101/1w.txt' into table testload fields terminated by ','; +---------------------+ | now() | +---------------------+ | 2021-02-02 15:21:26 | +---------------------+ 1 row in set (Elapsed: 00:00:00.00) Query OK, 10000 rows affected (Elapsed: 00:00:14.16) Task 4132 finished, Loaded 10000 records, Skipped 1 records gbase> select now();load data infile 'ftp://gbase:gbase1234@10.0.2.101/1w.txt' into table testload fields terminated by ','; +---------------------+ | now() | +---------------------+ | 2021-02-02 15:21:42 | +---------------------+ 1 row in set (Elapsed: 00:00:00.00) Query OK, 10000 rows affected (Elapsed: 00:00:18.44) Task 4133 finished, Loaded 10000 records, Skipped 1 records gbase> select now();load data infile 'ftp://gbase:gbase1234@10.0.2.101/1w.txt' into table testload fields terminated by ','; +---------------------+ | now() | +---------------------+ | 2021-02-02 15:22:01 | +---------------------+ 1 row in set (Elapsed: 00:00:00.00) Query OK, 10000 rows affected (Elapsed: 00:00:14.06) Task 4134 finished, Loaded 10000 records, Skipped 1 records gbase> select now();load data infile 'ftp://gbase:gbase1234@10.0.2.101/1w.txt' into table testload fields terminated by ','; +---------------------+ | now() | +---------------------+ | 2021-02-02 15:22:24 | +---------------------+ 1 row in set (Elapsed: 00:00:00.00) Query OK, 10000 rows affected (Elapsed: 00:00:14.33) Task 4135 finished, Loaded 10000 records, Skipped 1 records gbase> select count(*) from testload; +----------+ | count(*) | +----------+ | 85550 | +----------+ 1 row in set (Elapsed: 00:00:00.01) gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10w.txt' into table testload fields terminated by ','; Query OK, 100000 rows affected (Elapsed: 00:01:47.24) Task 4136 finished, Loaded 100000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10w.txt' into table testload fields terminated by ','; Query OK, 100000 rows affected (Elapsed: 00:01:40.37) Task 4137 finished, Loaded 100000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10w.txt' into table testload fields terminated by ','; Query OK, 100000 rows affected (Elapsed: 00:01:49.68) Task 4138 finished, Loaded 100000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10w.txt' into table testload fields terminated by ','; Query OK, 100000 rows affected (Elapsed: 00:01:54.84) Task 4139 finished, Loaded 100000 records, Skipped 0 records gbase> load data infile 'ftp://gbase:gbase1234@10.0.2.101/10w.txt' into table testload fields terminated by ','; Query OK, 100000 rows affected (Elapsed: 00:01:53.09) Task 4140 finished, Loaded 100000 records, Skipped 0 records