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 | 1036537392 | 0 | 0 | 0 | 2 | 248070768 | |
charsets | Index | 1 | 19495 | 230518992 | 0 | 0 | 0 | 2 | 15263424 | |
mysql | ibdata1 | 20 | 2441216 | 5040461712 | 128 | 20365312 | 15787786080 | 126 | 2126961610224 | |
mysql | ib_logfile0 | 6 | 4608 | 442149840 | 52 | 26624 | 3798058704 | 55 | 749531698080 | |
mysql | ib_logfile1 | 2 | 66048 | 744748224 | 675 | 724480 | 213214791504 | 413 | 5932512124704 | |
mysql | undo_001 | 388 | 6406144 | 33010331904 | 380 | 6225920 | 20015664240 | 50 | 499512646512 | |
mysql | undo_002 | 384 | 6340608 | 23828401344 | 380 | 6225920 | 13775630880 | 50 | 628052076432 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 12147841200 | 4 | 204580791360 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 62346240 | 5 | 36645955632 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 61702608 | 5 | 29896865328 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 59199360 | 5 | 26251926096 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 58227312 | 5 | 35516336064 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 55110528 | 5 | 31107169632 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 66439296 | 5 | 30907965792 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 55973280 | 5 | 26351585568 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 78772320 | 5 | 32750397504 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 296 | 8257536 | 5662691760 | 56 | 1010918132400 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 11 | 507904 | 327277632 | 9 | 119534886240 | |
mysql | mysql | 435 | 7176192 | 88297368192 | 338 | 5537792 | 7540727040 | 66 | 516496412256 | |
sys | sys_config | 1 | 65536 | 304512912 | 0 | 0 | 0 | 2 | 10573200 | |
sakila | actor | 5 | 131072 | 2665529328 | 0 | 0 | 0 | 5 | 37670688 | |
sakila | address | 9 | 196608 | 3274119552 | 0 | 0 | 0 | 5 | 23108448 | |
sakila | category | 4 | 114688 | 803894256 | 0 | 0 | 0 | 5 | 26477088 | |
sakila | city | 7 | 163840 | 1963843728 | 0 | 0 | 0 | 5 | 33367488 | |
sakila | country | 4 | 114688 | 4710746304 | 0 | 0 | 0 | 5 | 50963088 |
|