Skip to main content

统计和运维

查询估算的表和每行的磁盘占用​

  • table_schema: 记录数据库名
  • table_name: 记录数据表名
  • engine : 存储引擎
  • table_rows: 关于表的粗略行估计
  • data_length : 记录表的大小（单位字节）
  • index_length : 记录表的索引的大小
  • row_format: 可以查看数据表是否压缩过
SELECT
    table_name,
    table_rows,
    data_length,
    avg_row_length
FROM
    information_schema.tables
WHERE
    table_schema = 'your_database_name'
    AND table_name = 'your_table_name';

查看当前连接​

show processlist;

查询超时60s事务​

select * from information_schema.innodb_trx where TIME_TO_SEC(timediff(now(),trx_started))>60;

查当前的锁状态​

select * from performance_schema.data_locks;

redo log 相关配置参数​

SHOW VARIABLES LIKE 'innodb_log%';