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 | 1239719712 | 0 | 0 | 0 | 2 | 239103744 | |
charsets | Index | 1 | 19495 | 308941776 | 0 | 0 | 0 | 2 | 19521216 | |
mysql | ibdata1 | 20 | 2441216 | 6346388400 | 217 | 27475968 | 18907647792 | 211 | 3482041762848 | |
mysql | ib_logfile0 | 6 | 4608 | 984383136 | 96 | 49152 | 5273195664 | 99 | 1347941603712 | |
mysql | ib_logfile1 | 2 | 66048 | 935412192 | 920 | 1054208 | 217841742096 | 560 | 8343090241200 | |
mysql | undo_001 | 388 | 6406144 | 63499204560 | 415 | 6799360 | 17201845056 | 81 | 840812212416 | |
mysql | undo_002 | 384 | 6340608 | 30810494352 | 418 | 6848512 | 17720135136 | 88 | 859125579312 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 16228482336 | 4 | 218461695936 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 231050688 | 5 | 39029207184 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 334745136 | 5 | 34116291264 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 255807552 | 5 | 42585401232 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 289924272 | 5 | 43168996992 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 323966544 | 5 | 34167398496 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 331936704 | 5 | 34687444176 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 278069088 | 5 | 33293908032 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 279441888 | 5 | 34929567024 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 349981104 | 5 | 33090199296 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 103 | 4571136 | 4680598032 | 48 | 834103912752 | |
mysql | mysql | 433 | 7143424 | 111865528368 | 598 | 9797632 | 16616548080 | 125 | 1191880371264 | |
sys | sys_config | 4 | 114688 | 917692512 | 0 | 0 | 0 | 5 | 49907616 | |
sakila | actor | 4 | 114688 | 916524576 | 0 | 0 | 0 | 5 | 62276544 | |
sakila | address | 9 | 196608 | 6208377120 | 0 | 0 | 0 | 5 | 113899104 | |
sakila | category | 4 | 114688 | 931023456 | 0 | 0 | 0 | 5 | 46459248 | |
sakila | city | 7 | 163840 | 5752813968 | 0 | 0 | 0 | 5 | 88465872 | |
sakila | country | 4 | 114688 | 864802224 | 0 | 0 | 0 | 5 | 132893376 |
|