- 博客(7)
- 问答 (1)
- 收藏
- 关注
原创 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 1334
原创 innodb table level lock 与lock table语句关系
DDL语句只申请意向级别的表锁。在lock table语句中,mysql会申请mysql级别表锁,同时innodb也会申请innodb级别表锁。前提是innodb_table_locks=1 https://www.percona.com/blog/2012/07/31/innodb-table-locks/ MySQL Table level locks and Innodb Ta
2015-05-24 17:31:21 2155
原创 limits on mysql
1、limits of joins The 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 973
原创 Barracuda文件格式和Antelope的区别
/** There are currently two InnoDB fileformats which are used to group features with similar restrictions anddependencies. Using an enum allows switch statements to give a compilerwarning when a new
2015-05-10 20:49:32 1981 1
原创 innodb 物理行格式 compressed (怎么16进制中找不到最大最小伪记录)
从.ibd16进制内容可以看到,该压缩格式的页没有infimum和supremum记录。 page0zip.cc:: /* Please refer to ../include/page0zip.ic for a description of the compressed page format. */ 参考page0zip.ic理解压缩页格式 /* The infimum and
2015-05-08 22:46:14 854
原创 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 1435
空空如也
innodb插入意向锁如何使用
2015-06-07
TA创建的收藏夹 TA关注的收藏夹
TA关注的人