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 | 967514064 | 0 | 0 | 0 | 2 | 241901088 | |
charsets | Index | 1 | 19495 | 231932448 | 0 | 0 | 0 | 2 | 19423008 | |
mysql | ibdata1 | 20 | 2441216 | 11960223264 | 164 | 23461888 | 13455431088 | 159 | 2531721402144 | |
mysql | ib_logfile0 | 6 | 4608 | 484406208 | 74 | 37888 | 3836844000 | 77 | 1042893188832 | |
mysql | ib_logfile1 | 2 | 66048 | 819455472 | 826 | 1010688 | 212372711232 | 503 | 7863761962848 | |
mysql | undo_001 | 388 | 6406144 | 31758480864 | 410 | 6717440 | 26867309568 | 71 | 682358900256 | |
mysql | undo_002 | 385 | 6356992 | 25693754064 | 387 | 6340608 | 11275992816 | 69 | 660089707200 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 7749699408 | 4 | 198466235616 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 63878496 | 5 | 36095393664 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 87484320 | 5 | 32596594272 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 82176336 | 5 | 27053219424 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 97718016 | 5 | 35497812240 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 76567920 | 5 | 28878374448 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 111251184 | 5 | 26599330560 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 70900896 | 5 | 39844854720 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 64909680 | 5 | 36693159360 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 71601552 | 5 | 27596130672 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 137 | 3358720 | 2052972240 | 21 | 378576604560 | |
mysql | mysql | 435 | 7176192 | 104199641568 | 411 | 6733824 | 7765065264 | 88 | 890183766912 | |
sys | sys_config | 4 | 114688 | 947809632 | 0 | 0 | 0 | 5 | 40146480 | |
sakila | actor | 5 | 131072 | 1392112656 | 0 | 0 | 0 | 5 | 45696816 | |
sakila | address | 5 | 131072 | 1399797168 | 0 | 0 | 0 | 5 | 55854480 | |
sakila | category | 4 | 114688 | 5040348720 | 0 | 0 | 0 | 5 | 118166928 | |
sakila | city | 7 | 163840 | 5524416480 | 0 | 0 | 0 | 5 | 838142448 | |
sakila | country | 4 | 114688 | 841456176 | 0 | 0 | 0 | 5 | 55948992 |
|