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 | 424 | 122175488 | 49161748416 | 391 | 6451783069776 | |
mysql | ib_logfile0 | 6 | 4608 | 568732560 | 120 | 61440 | 6416936064 | 123 | 1649171268624 | |
mysql | ib_logfile1 | 2 | 66048 | 762530736 | 4041 | 3694080 | 1319742796416 | 2481 | 31183869878304 | |
mysql | undo_001 | 389 | 6422528 | 68905998480 | 3024 | 49545216 | 58976301648 | 214 | 1572544051056 | |
mysql | undo_002 | 386 | 6373376 | 27607780464 | 3584 | 58720256 | 67079681856 | 214 | 2086159303536 | |
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 | 37 | 1392640 | 1351794048 | 16 | 241171384608 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 204 | 4980736 | 76068965808 | 29 | 490632394560 | |
mysql | mysql | 434 | 7159808 | 103085906352 | 452 | 7405568 | 7046473632 | 177 | 1115515654704 | |
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 |
|