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 | 915628032 | 0 | 0 | 0 | 2 | 159358848 | |
charsets | Index | 1 | 19495 | 221040864 | 0 | 0 | 0 | 2 | 16478880 | |
mysql | ibdata1 | 20 | 2441216 | 12082686528 | 111 | 18382848 | 11670832272 | 102 | 2189334015264 | |
mysql | ib_logfile0 | 6 | 4608 | 809274576 | 44 | 22528 | 1720872912 | 47 | 644972263056 | |
mysql | ib_logfile1 | 2 | 66048 | 963342336 | 562 | 850432 | 172458979440 | 334 | 4818191869392 | |
mysql | undo_001 | 388 | 6406144 | 41808707424 | 254 | 4161536 | 7261355904 | 43 | 462602814432 | |
mysql | undo_002 | 384 | 6340608 | 30564982800 | 200 | 3276800 | 9044331120 | 40 | 461602824144 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 11049228960 | 4 | 217396646016 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 295050624 | 5 | 40822108800 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 238920528 | 5 | 33908841648 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 251295792 | 5 | 35550676656 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 265579248 | 5 | 35160529536 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 319826496 | 5 | 33577676880 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 262996800 | 5 | 50320063728 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 317924640 | 5 | 35043681552 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 278073840 | 5 | 33588138672 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 350416176 | 5 | 34078583088 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 65 | 3162112 | 3082356816 | 36 | 618741729408 | |
mysql | mysql | 395 | 6520832 | 92540552544 | 502 | 8224768 | 9542287392 | 54 | 517151109552 | |
sys | sys_config | 4 | 114688 | 803928576 | 0 | 0 | 0 | 5 | 37109952 | |
sakila | actor | 1 | 65536 | 249253488 | 0 | 0 | 0 | 2 | 5673888 | |
sakila | address | 9 | 196608 | 2281671216 | 0 | 0 | 0 | 5 | 35086128 | |
sakila | category | 4 | 114688 | 913669680 | 0 | 0 | 0 | 5 | 53227152 | |
sakila | city | 7 | 163840 | 1223384976 | 0 | 0 | 0 | 5 | 2565224112 | |
sakila | country | 4 | 114688 | 833305968 | 0 | 0 | 0 | 5 | 40682400 |
|