mysql锁剖析相关的几个系统视图
发布时间：2022-03-27 11:35:24 所属栏目：MySql教程 来源：互联网
导读：mysql锁分析相关的几个系统视图： 1、infomation_schema.innodb_lock_waits +-------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-------------+------+-----+-----
|
mysql锁分析相关的几个系统视图： 1、infomation_schema.innodb_lock_waits +-------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-------------+------+-----+---------+-------+ | requesting_trx_id | varchar(18) | NO | | | | #请求锁的事务id | requested_lock_id | varchar(81) | NO | | | | #请求锁的id | blocking_trx_id | varchar(18) | NO | | | | #拥有锁的事务id | blocking_lock_id | varchar(81) | NO | | | | #拥有锁的id +-------------------+-------------+------+-----+---------+-------+ 2、information_schema.innodb_trx +----------------------------+---------------------+------+-----+---------------------+-------+ | Field | Type | Null | Key | Default |Extra | +----------------------------+---------------------+------+-----+---------------------+-------+ | trx_id | varchar(18) | NO | | | | # 事务id | trx_state | varchar(13) | NO | | | | # 事务的执行状态 | trx_started | datetime | NO | | 0000-00-00 00:00:00 | | # 事务开始的时间 | trx_requested_lock_id | varchar(81) | YES | | NULL | | # 事务正等待的锁id | trx_wait_started | datetime | YES | | NULL | | # 事务等待锁开始的时间 | trx_weight | bigint(21) unsigned | NO | | 0 | | # 事务权重，主要反映事物修改和锁定的行数 | trx_mysql_thread_id | bigint(21) unsigned | NO | | 0 | | # 事务相应线程的id | trx_query | varchar(1024) | YES | | NULL | | # 事务SQL语句 | trx_operation_state | varchar(64) | YES | | NULL | | # 事务的目前操作 | trx_tables_in_use | bigint(21) unsigned | NO | | 0 | | # 事务处理当前SQL所用的表数 | trx_tables_locked | bigint(21) unsigned | NO | | 0 | | # 事务当前SQL拥有行锁的表数 | trx_lock_structs | bigint(21) unsigned | NO | | 0 | | # 事物保留的锁数 | trx_lock_memory_bytes | bigint(21) unsigned | NO | | 0 | | # 事务锁结构所占内存大小 | trx_rows_locked | bigint(21) unsigned | NO | | 0 | | # 事务锁住的近似行数 | trx_rows_modified | bigint(21) unsigned | NO | | 0 | | # 事务修改和插入的行数 | trx_concurrency_tickets | bigint(21) unsigned | NO | | 0 | | # 指示当前事务被交换出之前需处理工作量的数值 | trx_isolation_level | varchar(16) | NO | | | | # 当前事务的隔离等级 | trx_unique_checks | int(1) | NO | | 0 | | # 唯一检查对当前事务是否开启 | trx_foreign_key_checks | int(1) | NO | | 0 | | # 外键检查对当前事务是否开启 | trx_last_foreign_key_error | varchar(256) | YES | | NULL | | # 最近外键报错的详细信息 | trx_adaptive_hash_latched | int(1) | NO | | 0 | | # 当前事务是否锁定自适应哈希索引 | trx_adaptive_hash_timeout | bigint(21) unsigned | NO | | 0 | | # 指示当前事务是否放弃或保留搜索自适应索引的数值，为0时，则立即放弃 | trx_is_read_only | int(1) | NO | | 0 | | # 当前事务是否只读，1为只读 | trx_autocommit_non_locking | int(1) | NO | | 0 | | # 指示当前事务是否为非锁定自动提交 +----------------------------+---------------------+------+-----+---------------------+-------+ 3、 information_schema.processlist +---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | ID | bigint(21) unsigned | NO | | 0 | | # 连接线程的id | USER | varchar(32) | NO | | | | # 登录mysql的user | HOST | varchar(64) | NO | | | | # 登录mysql的主机名或地址:端口 | DB | varchar(64) | YES | | NULL | | # 登录mysql的数据库名 | COMMAND | varchar(16) | NO | | | | # 连接线程当前运行命令的类型 | TIME | int(7) | NO | | 0 | | # 连接线程处于当前状态的秒数 | STATE | varchar(64) | YES | | NULL | | # 连接线程当前所处的状态 | INFO | longtext | YES | | NULL | | # 连接线程当前正执行的语句 +---------+---------------------+------+-----+---------+-------+ （编辑：晋中站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
