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 | 136 | 29278208 | 19030577280 | 126 | 2270719353936 | |
mysql | ib_logfile0 | 6 | 4608 | 544622496 | 37 | 18944 | 1421406624 | 40 | 520321611744 | |
mysql | ib_logfile1 | 2 | 66048 | 766738896 | 1984 | 3640320 | 516068718000 | 946 | 13196293696608 | |
mysql | undo_001 | 389 | 6422528 | 32506910832 | 648 | 10616832 | 21334577088 | 59 | 600623457456 | |
mysql | undo_002 | 385 | 6356992 | 28904889552 | 585 | 9584640 | 20131400256 | 56 | 581822768208 | |
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 | 420 | 6930432 | 86881301232 | 396 | 6488064 | 25730208768 | 79 | 925303504224 | |
sys | sys_config | 1 | 65536 | 310980912 | 0 | 0 | 0 | 2 | 10658208 | |
mysql | binlog | 107 | 1108 | 1179735744 | 67 | 22903 | 2012857968 | 389 | 1013320671264 | |
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 |
|