Multi-threaded single table operation, multiple threads through the load infile insert data
A thread count select count (1) from the table;
With mysql commands show the processlist display select count (1) from the table; State has been sending data sometimes, 2000 + 3000 + seconds, down load infile in execution state,
How can ability let statistics to perform select count (1) from the table;
CodePudding user response:
The load data takes up too much resources select not to come out is very normal