mysql> select sn,id,info from s100 group by id; +-----+------+------+ | sn | id | info | +-----+------+------+ | 227 | 1 | aa | | 228 | 2 | bb | +-----+------+------+ 2 rows in set (0.02 sec) mysql> select sn,count(id),info from s100 group by id; +-----+-----------+------+ | sn | count(id) | info | +-----+-----------+------+ | 227 | 32768 | aa | | 228 | 1 | bb | +-----+-----------+------+ 2 rows in set (0.02 sec) mysql> mysql> mysql> show index from s100; +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | s100 | 0 | PRIMARY | 1 | sn | A | 33366 | NULL | NULL | | BTREE | | | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 1 row in set (0.00 sec) mysql> show variables like '%tx_isolation%'; +---------------+----------------+ | Variable_name | Value | +---------------+----------------+ | tx_isolation | READ-COMMITTED | +---------------+----------------+ 1 row in set (0.00 sec) mysql> show variables like '%commit%'; +--------------------------------+-------+ | Variable_name | Value | +--------------------------------+-------+ | autocommit | OFF | | binlog_order_commits | ON | | innodb_api_bk_commit_interval | 5 | | innodb_commit_concurrency | 0 | | innodb_flush_log_at_trx_commit | 1 | +--------------------------------+-------+ 5 rows in set (0.00 sec) Session 1: mysql> select * from s100 where id=2 for update; +-----+------+------+ | sn | id | info | +-----+------+------+ | 228 | 2 | bb | +-----+------+------+ 1 row in set (0.02 sec) Session 2: Database changed mysql> insert into s100(id,info) values(9999,'fcadfad'); Query OK, 1 row affected (0.00 sec) RC模式下,是行锁 不会上升到表级锁
mysql READ-COMMITTED 模式下 行锁不会升级到表级锁
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
下一篇:mysql sql执行顺序
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章