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 | 993701808 | 0 | 0 | 0 | 2 | 189046176 | |
charsets | Index | 1 | 19495 | 255227280 | 0 | 0 | 0 | 2 | 13247520 | |
mysql | ibdata1 | 20 | 2441216 | 5530275168 | 189 | 39272448 | 18988488816 | 178 | 2870149773216 | |
mysql | ib_logfile0 | 6 | 4608 | 397277760 | 70 | 35840 | 2483939568 | 73 | 925588924656 | |
mysql | ib_logfile1 | 2 | 66048 | 776972592 | 2423 | 4452352 | 628276906224 | 1200 | 16225749641904 | |
mysql | undo_001 | 389 | 6422528 | 52202367360 | 757 | 12402688 | 23636371440 | 95 | 851081271216 | |
mysql | undo_002 | 386 | 6373376 | 32981321472 | 751 | 12304384 | 17401848816 | 96 | 938966839536 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 13189362384 | 4 | 247911658368 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 260257536 | 5 | 39150360480 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 232717056 | 5 | 36604348704 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 245544288 | 5 | 34877657760 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 230571792 | 5 | 33072522384 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 274591152 | 5 | 34429435392 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 248417664 | 5 | 33801069984 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 241953888 | 5 | 35164454160 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 230622480 | 5 | 33261752304 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 7 | 311296 | 425768640 | 7 | 100487591952 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 154 | 3899392 | 277726969344 | 25 | 431215435200 | |
mysql | mysql | 431 | 7110656 | 138813087600 | 627 | 10272768 | 28686501888 | 105 | 944125640832 | |
sys | sys_config | 4 | 114688 | 881780064 | 0 | 0 | 0 | 5 | 44541552 | |
mysql | binlog | 87 | 1028 | 4726937424 | 81 | 26186 | 3136082928 | 343 | 1195509192768 | |
mysql | auto | 3 | 56 | 906534816 | 0 | 0 | 0 | 2 | 15515280 | |
mysqld | mysqld | 0 | 0 | 0 | 1 | 4 | 2182224 | 2 | 12478224 | |
spanish | errmsg | 3 | 305161 | 1116049440 | 0 | 0 | 0 | 2 | 791004192 | |
polish | errmsg | 3 | 304436 | 1113441648 | 0 | 0 | 0 | 2 | 2036292192 |
|