需求背景:有一个9亿条的表,需要按条件导出uuid 字段内容到一张新表,供数据团队进行处理
实现方式:采用shell 脚本实现
#!/bin/bash
echo "run start"
for ((i=0; i < 900000000;i+=1000000));
do
{
mysql -h 192.168.x.x -uroot -p123456 -D user -e "insert into user_uuid(uuid) select uuid from user_keys where keysType = 'aaa' and id between $i and $i+1000000";
}&
done
wait
echo "run end"
mysql机器配置:4c8g
用时24分钟