4
脚本跑数
source link: https://zsmhub.github.io/post/%E5%AE%9E%E6%88%98%E6%A1%88%E4%BE%8B/%E8%84%9A%E6%9C%AC%E8%B7%91%E6%95%B0/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
2022-08-31
约 116 字
预计阅读 1 分钟
MySQL数据表更新数据
- 对于100万条记录、200M占用空间的数据表，执行全量update语句，速度很快，1分钟可执行完毕
- 对于100万条记录、200M占用空间的数据表，使用脚本循环执行一条条记录的update，大概5分钟内可执行完毕
Gitalking ...
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK