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 | 350 | 98172928 | 40380323808 | 324 | 5330903679552 | |
mysql | ib_logfile0 | 6 | 4608 | 568732560 | 106 | 54272 | 6121355328 | 109 | 1421697864576 | |
mysql | ib_logfile1 | 2 | 66048 | 762530736 | 3393 | 3216384 | 1175118044496 | 2079 | 26331551307072 | |
mysql | undo_001 | 389 | 6422528 | 68905998480 | 2471 | 40484864 | 52399260144 | 174 | 1323947759376 | |
mysql | undo_002 | 386 | 6373376 | 27607780464 | 2742 | 44924928 | 53894468496 | 174 | 1742115251184 | |
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 | 15 | 507904 | 580633680 | 8 | 80876169792 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 204 | 4980736 | 76068965808 | 29 | 490632394560 | |
mysql | mysql | 434 | 7159808 | 103085906352 | 426 | 6979584 | 6691818144 | 153 | 945464121888 | |
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 | 7 | 163840 | 1884179088 | 0 | 0 | 0 | 5 | 55932096 | |
sakila | country | 4 | 114688 | 961078272 | 0 | 0 | 0 | 5 | 32129856 |
|