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 | 970999920 | 0 | 0 | 0 | 2 | 164491536 | |
charsets | Index | 1 | 19495 | 220756272 | 0 | 0 | 0 | 2 | 14184720 | |
mysql | ibdata1 | 20 | 2441216 | 11947334784 | 65 | 16580608 | 8710492560 | 63 | 1101401835072 | |
mysql | ib_logfile0 | 6 | 4608 | 544622496 | 22 | 11264 | 941350080 | 25 | 311410011264 | |
mysql | ib_logfile1 | 2 | 66048 | 766738896 | 1193 | 2266624 | 272809048512 | 520 | 7058459169696 | |
mysql | undo_001 | 389 | 6422528 | 32506910832 | 361 | 5914624 | 12857003280 | 28 | 286908025008 | |
mysql | undo_002 | 385 | 6356992 | 28904889552 | 360 | 5898240 | 9575747280 | 27 | 287204101536 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 9462046704 | 4 | 210058720080 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 58990272 | 5 | 35188333488 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 62246448 | 5 | 27196622112 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 72855552 | 5 | 35411955216 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 71385600 | 5 | 37958203536 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 71358144 | 5 | 28398634176 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 74424768 | 5 | 28321955376 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 8 | 458752 | 229606608 | 9 | 102807202080 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 35 | 1753088 | 1415912784 | 22 | 338451713424 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 8 | 458752 | 264630432 | 9 | 106400154960 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 7 | 376832 | 235821168 | 8 | 82712064336 | |
mysql | mysql | 405 | 6684672 | 82671564096 | 243 | 3981312 | 8253731376 | 40 | 397069476672 | |
sys | sys_config | 1 | 65536 | 310980912 | 0 | 0 | 0 | 2 | 10658208 | |
mysql | binlog | 66 | 944 | 1066055760 | 36 | 7163 | 1225019136 | 235 | 518965571520 | |
mysql | auto | 3 | 56 | 520474416 | 0 | 0 | 0 | 2 | 16522704 | |
mysqld | mysqld | 0 | 0 | 0 | 1 | 4 | 1906080 | 2 | 12162480 | |
spanish | errmsg | 3 | 305161 | 906919728 | 0 | 0 | 0 | 2 | 755548992 | |
russian | errmsg | 3 | 318782 | 6607621152 | 0 | 0 | 0 | 2 | 289349808 |
|