- 论坛徽章:
- 0
|
本帖最后由 cenalulu 于 2013-04-09 09:47 编辑
今晚在观察row locks的时候发现一个问题
root@mysqlslap 12:16:22>set autocommit=0;update t1 set charcol1='2tes2t' ;
Query OK, 0 rows affected (0.01 sec)
Query OK, 5601 rows affected (0.19 sec)
Rows matched: 5601 Changed: 5601 Warnings: 0
观察show engine innodb status\G
---TRANSACTION 50EF6, ACTIVE 25 sec
19 lock struct(s), heap size 3112, 5616 row lock(s), undo log entries 5601
MySQL thread id 30, OS thread handle 0x40975940, query id 40005873 localhost root
发现InnoDB 内部出现了 5616 row lock(s)
why? |
|