Tag:index upgrade

  • Solving MySQL deadlock routine by different index updates


    Previous articles have introduced the use of source code to debug lock-related information. Here we also use this tool to solve an online real deadlock case. It is also the first two cases of deadlock caused by SQL that we introduced. Because of the complexity of the online table structure, some simplifications are made as […]