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 | 1011392448 | 0 | 0 | 0 | 2 | 240275376 | |
charsets | Index | 1 | 19495 | 310701072 | 0 | 0 | 0 | 2 | 10750608 | |
mysql | ibdata1 | 20 | 2441216 | 9387247584 | 143 | 33849344 | 14637944112 | 138 | 2222826759120 | |
mysql | ib_logfile0 | 6 | 4608 | 568732560 | 52 | 26624 | 4382100096 | 55 | 698767196160 | |
mysql | ib_logfile1 | 2 | 66048 | 762530736 | 1140 | 1025536 | 489466277520 | 717 | 9214841703408 | |
mysql | undo_001 | 388 | 6406144 | 65125675296 | 781 | 12795904 | 16610994576 | 71 | 571241619696 | |
mysql | undo_002 | 384 | 6340608 | 21685875024 | 964 | 15794176 | 13148447136 | 74 | 798291555600 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 15205972848 | 4 | 251952522096 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 243864192 | 5 | 48357161952 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 281379120 | 5 | 34813386960 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 345724368 | 5 | 41772547344 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 270725136 | 5 | 35534676144 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 278698992 | 5 | 37550028912 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 297032208 | 5 | 36751066176 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 379876992 | 5 | 42804235584 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 336894096 | 5 | 33062157744 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 323172960 | 5 | 32789728752 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 25 | 1196032 | 1159908816 | 16 | 242405809008 | |
mysql | mysql | 434 | 7159808 | 103085906352 | 170 | 2785280 | 2642766192 | 71 | 406089760032 | |
sys | sys_config | 4 | 114688 | 926113056 | 0 | 0 | 0 | 5 | 49935072 | |
sakila | actor | 5 | 131072 | 787468176 | 0 | 0 | 0 | 5 | 35513808 | |
sakila | address | 9 | 196608 | 3614219136 | 0 | 0 | 0 | 5 | 41021904 | |
sakila | category | 4 | 114688 | 876932496 | 0 | 0 | 0 | 5 | 31261296 | |
sakila | city | 6 | 147456 | 1611235296 | 0 | 0 | 0 | 5 | 55932096 | |
sakila | country | 4 | 114688 | 961078272 | 0 | 0 | 0 | 5 | 32129856 |
|