mysql如何统计某个库中的读写最频繁的前5张表？
mysql如何统计某个库中的读写最频繁的前5张表？
5.7版本中
查看其它 2 个回答renou2012的回答
可以关注以下两个视图sys.io_global_by_file_by_bytes、sys.x$io_global_by_file_by_bytes
或者表performance_schema.file_summary_by_instance
| sys.io_global_by_file_by_bytes | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| file | varchar(512) | YES | NULL | ||
| count_read | bigint(20) unsigned | NO | NULL | ||
| total_read | text | YES | NULL | ||
| avg_read | text | YES | NULL | ||
| count_write | bigint(20) unsigned | NO | NULL | ||
| total_written | text | YES | NULL | ||
| avg_write | text | YES | NULL | ||
| total | text | YES | NULL | ||
| write_pct | decimal(26,2) | NO | 0.00 |
| sys.x$io_global_by_file_by_bytes | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| file | varchar(512) | NO | NULL | ||
| count_read | bigint(20) unsigned | NO | NULL | ||
| total_read | bigint(20) | NO | NULL | ||
| avg_read | decimal(23,4) | NO | 0.0000 | ||
| count_write | bigint(20) unsigned | NO | NULL | ||
| total_written | bigint(20) | NO | NULL | ||
| avg_write | decimal(23,4) | NO | 0.0000 | ||
| total | bigint(21) | NO | 0 | ||
| write_pct | decimal(26,2) | NO | 0.00 |
| performance_schema.file_summary_by_instance | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| FILE_NAME | varchar(512) | NO | NULL | ||
| EVENT_NAME | varchar(128) | NO | NULL | ||
| OBJECT_INSTANCE_BEGIN | bigint(20) unsigned | NO | NULL | ||
| COUNT_STAR | bigint(20) unsigned | NO | NULL | ||
| SUM_TIMER_WAIT | bigint(20) unsigned | NO | NULL | ||
| MIN_TIMER_WAIT | bigint(20) unsigned | NO | NULL | ||
| AVG_TIMER_WAIT | bigint(20) unsigned | NO | NULL | ||
| MAX_TIMER_WAIT | bigint(20) unsigned | NO | NULL | ||
| COUNT_READ | bigint(20) unsigned | NO | NULL | ||
| SUM_TIMER_READ | bigint(20) unsigned | NO | NULL | ||
| MIN_TIMER_READ | bigint(20) unsigned | NO | NULL | ||
| AVG_TIMER_READ | bigint(20) unsigned | NO | NULL | ||
| MAX_TIMER_READ | bigint(20) unsigned | NO | NULL | ||
| SUM_NUMBER_OF_BYTES_READ | bigint(20) | NO | NULL | ||
| COUNT_WRITE | bigint(20) unsigned | NO | NULL | ||
| SUM_TIMER_WRITE | bigint(20) unsigned | NO | NULL | ||
| MIN_TIMER_WRITE | bigint(20) unsigned | NO | NULL | ||
| AVG_TIMER_WRITE | bigint(20) unsigned | NO | NULL | ||
| MAX_TIMER_WRITE | bigint(20) unsigned | NO | NULL | ||
| SUM_NUMBER_OF_BYTES_WRITE | bigint(20) | NO | NULL | ||
| COUNT_MISC | bigint(20) unsigned | NO | NULL | ||
| SUM_TIMER_MISC | bigint(20) unsigned | NO | NULL | ||
| MIN_TIMER_MISC | bigint(20) unsigned | NO | NULL | ||
| AVG_TIMER_MISC | bigint(20) unsigned | NO | NULL | ||
| MAX_TIMER_MISC | bigint(20) unsigned | NO | NULL |
更多参考
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-file-by-bytes.html