一名数据库爱好者的专栏

mysql 5.7mysql 8.0

select table_schema, table_name from information_schema.tables where 1=1 and table_name not in ( select distinct table_name from information_schema.columns where 1=1 and column_key = "PRI") and table_schema not in (

os: centos 7.4.1708db: mysql 8.0.19任何数据库都需要对锁进行监控，尤其是长时间的锁，mysql 也不例外。mysql 通过 show full processlist、show engine innodb status 可以查看到。其实通过 information_schema.innodb_trx 更容易监控到锁的情况。版本[root@node2 ~...

os: centos 7.4db: mysql 5.8# /usr/local/mysql/bin/mysql -h127.0.0.1 -P3306 -uroot -pdbma@0352 -e"select * from performance_schema.replication_group_members;"参考: