The LOCK TABLE command can be used to lock a table instead of using the default row locking.
可使用LOCKTABLE命令来锁定一个表,而不是使用缺省的行锁定。
If many transactions will be updating individual rows, change to row locking mode for a particular table using the following SQL statement.
如果许多事务将更新一些单独的行,则使用下列sql语句将特定表更改为row locking模式。
Transactional database systems in general are not very good at generating summary tables from log tables, because in this case row locking is almost useless.
传统的数据库一般地在从日志表中生成摘要表这方面的表现不怎么好,因为在这种情况下,行记录锁几乎没用。
Row locking with escalation to table locks.
行锁定,具有到表锁的升级。
Row locking with escalation to table locks.
行锁定,具有到表锁的升级。
应用推荐