MySQL事务锁问题-Lock wait timeout exceeded

https://cloud.tencent.com/developer/article/1356959

https://cloud.tencent.com/info/2b391b12c82529a50b56ecbc3a7ae136.html

https://www.jianshu.com/p/f030aa5d7a28

 https://blog.csdn.net/qq_15037231/article/details/79792776

综合解决方案：增加多线程处理，减少数据处理时间。

配置线程池，将任务提交到线程池处理。