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 | 310 | 84099072 | 34645160880 | 288 | 4736271732720 | |
mysql | ib_logfile0 | 6 | 4608 | 568732560 | 93 | 47616 | 5689084896 | 96 | 1254892968384 | |
mysql | ib_logfile1 | 2 | 66048 | 762530736 | 3001 | 2921472 | 1081320230496 | 1827 | 23189921362080 | |
mysql | undo_001 | 389 | 6422528 | 68905998480 | 2087 | 34193408 | 44098646064 | 156 | 1233000358656 | |
mysql | undo_002 | 386 | 6373376 | 27607780464 | 2308 | 37814272 | 43116236592 | 155 | 1567380102288 | |
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 | 202 | 4882432 | 76006909440 | 28 | 475367868624 | |
mysql | mysql | 434 | 7159808 | 103085906352 | 412 | 6750208 | 6492486000 | 139 | 868183973712 | |
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 |
|