通过并行 Truncate Table 提升大批量清空表的性能时速度不够快,要怎么处理?
~
[root@iZbp1gck72rkvq2sxxk4elZ ~]# time ./create_table.sh
100 tables processed
200 tables processed
300 tables processed
400 tables processed
500 tables processed
600 tables processed
700 tables processed
800 tables processed
900 tables processed
1000 tables processed
1100 tables processed
1200 tables processed
1300 tables processed
1400 tables processed
1500 tables processed
1600 tables processed
1700 tables processed
1800 tables processed
1900 tables processed
2000 tables processed
2100 tables processed
2200 tables processed
2300 tables processed
2400 tables processed
2500 tables processed
2600 tables processed
2700 tables processed
2800 tables processed
2900 tables processed
3000 tables processed
3100 tables processed
3200 tables processed
3300 tables processed
3400 tables processed
3500 tables processed
3600 tables processed
3700 tables processed
3800 tables processed
3900 tables processed
4000 tables processed
4100 tables processed
4200 tables processed
4300 tables processed
4400 tables processed
4500 tables processed
4600 tables processed
4700 tables processed
4800 tables processed
4900 tables processed
5000 tables processed
5100 tables processed
5200 tables processed
5300 tables processed
5400 tables processed
5500 tables processed
5600 tables processed
5700 tables processed
5800 tables processed
5900 tables processed
6000 tables processed
6100 tables processed
6200 tables processed
6300 tables processed
6400 tables processed
6500 tables processed
6600 tables processed
6700 tables processed
6800 tables processed
6900 tables processed
7000 tables processed
7100 tables processed
7200 tables processed
7300 tables processed
7400 tables processed
7500 tables processed
7600 tables processed
7700 tables processed
7800 tables processed
7900 tables processed
8000 tables processed
8100 tables processed
8200 tables processed
8300 tables processed
8400 tables processed
8500 tables processed
8600 tables processed
8700 tables processed
8800 tables processed
8900 tables processed
9000 tables processed
9100 tables processed
9200 tables processed
9300 tables processed
9400 tables processed
9500 tables processed
9600 tables processed
9700 tables processed
9800 tables processed
9900 tables processed
10000 tables processed
real 4m6.426s
user 0m49.579s
sys 0m19.567s
[root@iZbp1gck72rkvq2sxxk4elZ ~]# time ./truncate_table.sh
100 tables processed
200 tables processed
300 tables processed
400 tables processed
500 tables processed
600 tables processed
700 tables processed
800 tables processed
900 tables processed
1000 tables processed
1100 tables processed
1200 tables processed
1300 tables processed
1400 tables processed
1500 tables processed
1600 tables processed
1700 tables processed
1800 tables processed
1900 tables processed
2000 tables processed
2100 tables processed
2200 tables processed
2300 tables processed
2400 tables processed
2500 tables processed
2600 tables processed
2700 tables processed
2800 tables processed
2900 tables processed
3000 tables processed
3100 tables processed
3200 tables processed
3300 tables processed
3400 tables processed
3500 tables processed
3600 tables processed
3700 tables processed
3800 tables processed
3900 tables processed
4000 tables processed
4100 tables processed
4200 tables processed
4300 tables processed
4400 tables processed
4500 tables processed
4600 tables processed
4700 tables processed
4800 tables processed
4900 tables processed
5000 tables processed
5100 tables processed
5200 tables processed
5300 tables processed
5400 tables processed
5500 tables processed
5600 tables processed
5700 tables processed
5800 tables processed
5900 tables processed
6000 tables processed
6100 tables processed
6200 tables processed
6300 tables processed
6400 tables processed
6500 tables processed
6600 tables processed
6700 tables processed
6800 tables processed
6900 tables processed
7000 tables processed
7100 tables processed
7200 tables processed
7300 tables processed
7400 tables processed
7500 tables processed
7600 tables processed
7700 tables processed
7800 tables processed
7900 tables processed
8000 tables processed
8100 tables processed
8200 tables processed
8300 tables processed
8400 tables processed
8500 tables processed
8600 tables processed
8700 tables processed
8800 tables processed
8900 tables processed
9000 tables processed
9100 tables processed
9200 tables processed
9300 tables processed
9400 tables processed
9500 tables processed
9600 tables processed
9700 tables processed
9800 tables processed
9900 tables processed
10000 tables processed
real 3m57.979s
user 0m50.390s
sys 0m19.494s