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 | 934859904 | 0 | 0 | 0 | 2 | 225188304 | |
charsets | Index | 1 | 19495 | 308294448 | 0 | 0 | 0 | 2 | 30792432 | |
mysql | ibdata1 | 20 | 2441216 | 5791072320 | 122 | 10715136 | 5175402672 | 123 | 1905165919008 | |
mysql | ib_logfile0 | 6 | 4608 | 542322000 | 61 | 31232 | 2552084832 | 64 | 825799349760 | |
mysql | ib_logfile1 | 2 | 66048 | 829653792 | 332 | 318976 | 145805356224 | 229 | 3388117060944 | |
mysql | undo_001 | 388 | 6406144 | 34139045952 | 187 | 3063808 | 3029382048 | 38 | 408160426080 | |
mysql | undo_002 | 384 | 6340608 | 29893910112 | 187 | 3063808 | 3605522976 | 49 | 425725851936 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 12797795472 | 4 | 221067919776 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 56136432 | 5 | 36078363552 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 56899392 | 5 | 26647420800 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 60489264 | 5 | 43833608016 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 58073136 | 5 | 34036819872 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 58552560 | 5 | 39678241680 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 69024912 | 5 | 42479001312 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 78831456 | 5 | 32158451952 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 69655344 | 5 | 27951294096 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 70412496 | 5 | 30796816512 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 297 | 6569984 | 211943564976 | 30 | 584581780464 | |
mysql | mysql | 360 | 5947392 | 72816961008 | 156 | 2555904 | 2674567632 | 61 | 394812875424 | |
sys | sys_config | 4 | 114688 | 1551043296 | 0 | 0 | 0 | 5 | 49022160 | |
sakila | actor | 5 | 131072 | 1475634336 | 0 | 0 | 0 | 5 | 56720400 | |
sakila | address | 9 | 196608 | 4460189184 | 0 | 0 | 0 | 5 | 43577424 | |
sakila | category | 4 | 114688 | 1154856384 | 0 | 0 | 0 | 5 | 46627152 | |
sakila | city | 7 | 163840 | 2815933296 | 0 | 0 | 0 | 5 | 52296288 | |
sakila | country | 4 | 114688 | 1790058336 | 0 | 0 | 0 | 5 | 43838784 |
|