Mysql导致大量行锁
-
Mysql for update导致大量行锁的问题
目录一、引言二、分析1、Innodb不存在锁升级2、当for update一个不存在的where条件时3、Innodb如果在索引中找不到记录4、Innodb加锁的方式是从上到下的5、RR级别加锁情况三、总结一、引言[详细]
2023-11-19 13:12 分类:数据库 Parameterized SQL statements vs. very simple method
When I started to write the first SQL-Statements in my programs I felt quite comfortable with protecting myself against SQL-Injection with a very simple method that a colleague showed me. It replaced[详细]
2022-12-28 17:21 分类:问答