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 | 989308848 | 0 | 0 | 0 | 2 | 192493488 | |
charsets | Index | 1 | 19495 | 272518224 | 0 | 0 | 0 | 2 | 11918544 | |
mysql | ibdata1 | 20 | 2441216 | 8512672080 | 158 | 30244864 | 29050770144 | 148 | 2479157407584 | |
mysql | ib_logfile0 | 6 | 4608 | 493729104 | 53 | 27136 | 3284799408 | 56 | 786532411104 | |
mysql | ib_logfile1 | 2 | 66048 | 813844416 | 1526 | 1946624 | 318858005664 | 877 | 12054234596448 | |
mysql | undo_001 | 388 | 6406144 | 58774803120 | 715 | 11714560 | 23134881792 | 70 | 712132698816 | |
mysql | undo_002 | 384 | 6340608 | 44578580112 | 655 | 10731520 | 35063252400 | 66 | 732305620992 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 24528262704 | 4 | 241089026640 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 234517008 | 5 | 45994850880 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 226959744 | 5 | 31714449888 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 251184384 | 5 | 31750365504 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 258413760 | 5 | 46202238720 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 306345600 | 5 | 32733734352 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 319072512 | 5 | 38188872480 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 302152224 | 5 | 56911768848 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 282723408 | 5 | 37387573344 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 490278096 | 5 | 51226319232 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 7 | 311296 | 536434800 | 7 | 72851128416 | |
mysql | mysql | 412 | 6799360 | 100092426720 | 283 | 4636672 | 10951903248 | 77 | 694194691872 | |
sys | sys_config | 4 | 114688 | 930568848 | 0 | 0 | 0 | 5 | 42293856 | |
sakila | actor | 5 | 131072 | 3071351712 | 0 | 0 | 0 | 5 | 62276544 | |
sakila | address | 9 | 196608 | 853005648 | 0 | 0 | 0 | 5 | 34616208 | |
sakila | category | 4 | 114688 | 999612768 | 0 | 0 | 0 | 5 | 45332496 | |
sakila | city | 7 | 163840 | 1296784896 | 0 | 0 | 0 | 5 | 39049296 | |
sakila | country | 4 | 114688 | 958582416 | 0 | 0 | 0 | 5 | 64553808 |
|