定义上: 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 ...

2015-05-27 21:12:23

阅读数 850

评论数 0

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-t...

2015-05-24 17:31:21

阅读数 1525

评论数 0

transaction on mysql的一个有用网址


2015-05-23 21:32:14

阅读数 347

评论数 0

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 ...

2015-05-17 15:26:02

阅读数 725

评论数 0


/** There are currently two InnoDB fileformats which are used to group features with similar restrictions anddependencies. Using an enum allows switc...

2015-05-10 20:49:32

阅读数 1573

评论数 1

innodb 物理行格式 compressed (怎么16进制中找不到最大最小伪记录)

从.ibd16进制内容可以看到,该压缩格式的页没有infimum和supremum记录。 page0zip.cc:: /* Please refer to ../include/page0zip.ic for a description of the compressed page form...

2015-05-08 22:46:14

阅读数 536

评论数 0

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 Inn...

2015-05-02 21:06:34

阅读数 942

评论数 0

取消 删除