SELECT * FROM `x$ps_schema_table_statistics_io`
|
table_schema | table_name | count_read | sum_number_of_bytes_read | sum_timer_read | count_write | sum_number_of_bytes_write | sum_timer_write | count_misc | sum_timer_misc | |
---|---|---|---|---|---|---|---|---|---|---|
english | errmsg | 3 | 303507 | 1048974432 | 0 | 0 | 0 | 2 | 209647680 | |
charsets | Index | 1 | 19495 | 272826576 | 0 | 0 | 0 | 2 | 14631936 | |
mysql | ibdata1 | 20 | 2441216 | 7139738496 | 19 | 1851392 | 1705440528 | 24 | 341450930304 | |
mysql | ib_logfile0 | 6 | 4608 | 546170592 | 8 | 4096 | 1447028352 | 11 | 120031498224 | |
mysql | ib_logfile1 | 2 | 66048 | 803279664 | 97 | 101888 | 58121750016 | 65 | 967643074992 | |
mysql | undo_001 | 387 | 6389760 | 41002884384 | 47 | 770048 | 1765390704 | 14 | 88790182800 | |
mysql | undo_002 | 382 | 6307840 | 29415063216 | 32 | 524288 | 1106349552 | 14 | 100150402176 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 18411761280 | 4 | 223178075472 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 257319744 | 5 | 50508419280 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 242819280 | 5 | 33970554288 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 245539536 | 5 | 36065938656 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 245994144 | 5 | 37513280640 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 270445296 | 5 | 56077906896 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 346194816 | 5 | 50795649168 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 492466656 | 5 | 42793604832 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 278645136 | 5 | 42842188752 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 391916976 | 5 | 40469069520 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 9 | 409600 | 691835232 | 8 | 89927318976 | |
mysql | mysql | 325 | 5373952 | 88922164848 | 16 | 262144 | 439996656 | 13 | 47569874352 | |
sys | sys_config | 1 | 65536 | 344382720 | 0 | 0 | 0 | 2 | 10374672 | |
sakila | actor | 1 | 65536 | 282243984 | 0 | 0 | 0 | 2 | 5959008 | |
sakila | address | 1 | 65536 | 316947840 | 0 | 0 | 0 | 2 | 6007056 | |
sakila | category | 4 | 114688 | 974667936 | 0 | 0 | 0 | 5 | 41986032 | |
sakila | city | 6 | 147456 | 3993939312 | 0 | 0 | 0 | 5 | 259863120 | |
sakila | country | 4 | 114688 | 1574464848 | 0 | 0 | 0 | 5 | 79509936 |
|