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 | 991760352 | 0 | 0 | 0 | 2 | 185020704 | |
charsets | Index | 1 | 19495 | 241944912 | 0 | 0 | 0 | 2 | 13214256 | |
mysql | ibdata1 | 20 | 2441216 | 5793200688 | 104 | 9256960 | 8656018272 | 107 | 1696824617664 | |
mysql | ib_logfile0 | 6 | 4608 | 466614720 | 49 | 25088 | 1858092720 | 52 | 685362399744 | |
mysql | ib_logfile1 | 2 | 66048 | 797923104 | 280 | 284160 | 42881513664 | 187 | 2748931759728 | |
mysql | undo_001 | 388 | 6406144 | 35878663392 | 158 | 2588672 | 4886013792 | 42 | 395546691408 | |
mysql | undo_002 | 382 | 6307840 | 25825898208 | 163 | 2670592 | 4414781184 | 47 | 417503101488 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 10103915712 | 4 | 219153199056 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 67263504 | 5 | 37546935888 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 63795600 | 5 | 39055368528 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 55003344 | 5 | 35297075088 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 54095184 | 5 | 26356540848 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 54835968 | 5 | 26459615952 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 55689744 | 5 | 28909899216 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 56062512 | 5 | 26528392704 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 69490080 | 5 | 52705041840 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 64648320 | 5 | 28282477872 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 56 | 2621440 | 2499043536 | 30 | 526440875664 | |
mysql | mysql | 394 | 6504448 | 82277463840 | 140 | 2293760 | 3105239280 | 58 | 378828546096 | |
sys | sys_config | 4 | 114688 | 3025258896 | 0 | 0 | 0 | 5 | 46748592 | |
sakila | actor | 1 | 65536 | 303398304 | 0 | 0 | 0 | 2 | 6094176 | |
sakila | address | 1 | 65536 | 315874416 | 0 | 0 | 0 | 2 | 5722464 | |
sakila | category | 1 | 65536 | 330760320 | 0 | 0 | 0 | 2 | 6494400 | |
sakila | city | 7 | 163840 | 4717351584 | 0 | 0 | 0 | 5 | 122601600 | |
sakila | country | 4 | 114688 | 926784672 | 0 | 0 | 0 | 5 | 41897856 |
|