我也要用- 博客(7)
- 论坛 (3)
- 问答 (1)
- 收藏
- 关注
RSS订阅原创 innodb外键限制
定义上：innodb permits a foreign key to reference any index column or group of columns. However, in the referenced table, there must be an index where the referenced columns are listed as the first colu
2015-05-27 21:12:23
1130
原创 innodb table level lock 与lock table语句关系
DDL语句只申请意向级别的表锁。在lock table语句中，mysql会申请mysql级别表锁，同时innodb也会申请innodb级别表锁。前提是innodb_table_locks=1https://www.percona.com/blog/2012/07/31/innodb-table-locks/ MySQL Table level locks and Innodb Ta
2015-05-24 17:31:21
1871
原创 limits on mysql
1、limits of joinsThe maximum number of tables that can be referenced in a single join is 61. This also applies to the number of tables that can be referenced in the definition of a view.2、表最多可以有
2015-05-17 15:26:02
844
原创 Barracuda文件格式和Antelope的区别
/** There are currently two InnoDB fileformats which are used to groupfeatures with similar restrictions anddependencies. Using an enum allowsswitch statements to give a compilerwarning when a new
2015-05-10 20:49:32
1692
1
原创 innodb 物理行格式 compressed （怎么16进制中找不到最大最小伪记录）
从.ibd16进制内容可以看到，该压缩格式的页没有infimum和supremum记录。page0zip.cc::/* Please refer to ../include/page0zip.ic for a description of thecompressed page format. */参考page0zip.ic理解压缩页格式/* The infimum and
2015-05-08 22:46:14
701
原创 innodb RC级别下加锁特殊情况
In MySQL5.7, when READ COMMITTED isolation level is used, or the deprecated innodb_locks_unsafe_for_binlogsystem variable is enabled, there is no InnoDB gap locking exceptfor foreign-key constraint
2015-05-02 21:06:34
1187
空空如也
yzs87的留言板
发表于 2020-01-02 最后回复 2020-01-02
写博客能不能添加个撤销键
发表于 2018-01-04 最后回复 2018-01-06
innodb插入意向锁如何使用
发表于 2015-06-07 最后回复 2015-06-07
innodb插入意向锁如何使用
2015-06-07
TA创建的收藏夹 TA关注的收藏夹
TA关注的人 TA的粉丝