V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
youngforever
V2EX  ›  问与答

Lock wait timeout exceeded; try restarting transaction

  •  
  •   youngforever · Dec 2, 2022 · 738 views
    This topic created in 1256 days ago, the information mentioned may be changed or developed.

    有个业务需要同时更新 15000 多条记录,报了这个错误,应该是 mysql 的锁超时了。这种情况我把 15000 多条记录分成几份批量执行可以解决问题嘛?这是我目前能想到的办法,或者有没有什么更好的方法?

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   6217 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 34ms · UTC 06:11 · PVG 14:11 · LAX 23:11 · JFK 02:11
    ♥ Do have faith in what you're doing.