自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

yanzongshuai的专栏

专注于MySQL、MariaDB、Percona、PostgreSQL数据库及Aerospike等nosql数据库

  • 博客(7)
  • 论坛 (3)
  • 问答 (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 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

原创 transaction on mysql的一个有用网址

https://blogs.oracle.com/mysqlinnodb/

2015-05-23 21:32:14 483

原创 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

TA创建的收藏夹 TA关注的收藏夹

TA关注的人 TA的粉丝

提示
确定要删除当前文章?
取消 删除