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 | 1010394528 | 0 | 0 | 0 | 2 | 247814160 | |
charsets | Index | 1 | 19495 | 249273552 | 0 | 0 | 0 | 2 | 21224544 | |
mysql | ibdata1 | 20 | 2441216 | 5434592592 | 42 | 3555328 | 1579120224 | 47 | 682108943472 | |
mysql | ib_logfile0 | 6 | 4608 | 444917616 | 22 | 11264 | 617512368 | 25 | 278577781680 | |
mysql | ib_logfile1 | 2 | 66048 | 942164784 | 137 | 149504 | 11584990560 | 95 | 1483254940992 | |
mysql | undo_001 | 387 | 6389760 | 32993487648 | 59 | 966656 | 1023956736 | 21 | 196697015856 | |
mysql | undo_002 | 382 | 6307840 | 31899702384 | 43 | 704512 | 948794880 | 21 | 153047181408 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 10099326864 | 4 | 222708687168 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 106343952 | 5 | 34171538016 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 167682240 | 5 | 31826322528 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 85427232 | 5 | 27871140000 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 74955936 | 5 | 30398407776 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 66931392 | 5 | 33281243952 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 116206464 | 5 | 30599310192 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 228011520 | 5 | 36346159872 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 178534752 | 5 | 47068277520 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 79166208 | 5 | 49917162240 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 16 | 786432 | 650340240 | 12 | 149015760432 | |
mysql | mysql | 336 | 5554176 | 70529790144 | 68 | 1114112 | 713281008 | 26 | 134606260272 | |
sys | sys_config | 4 | 114688 | 1796049552 | 0 | 0 | 0 | 5 | 45009360 | |
sakila | actor | 4 | 114688 | 1003965600 | 0 | 0 | 0 | 5 | 36206544 | |
sakila | address | 6 | 147456 | 1257150576 | 0 | 0 | 0 | 5 | 47193696 | |
sakila | category | 1 | 65536 | 306640752 | 0 | 0 | 0 | 2 | 4944192 | |
sakila | city | 1 | 65536 | 359093856 | 0 | 0 | 0 | 2 | 4423056 | |
sakila | country | 4 | 114688 | 1025990592 | 0 | 0 | 0 | 5 | 42970752 |
|