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 | 1020606576 | 0 | 0 | 0 | 2 | 230245488 | |
charsets | Index | 1 | 19495 | 303982800 | 0 | 0 | 0 | 2 | 12909600 | |
mysql | ibdata1 | 20 | 2441216 | 12273047952 | 125 | 18366464 | 14749001520 | 120 | 1966904300064 | |
mysql | ib_logfile0 | 6 | 4608 | 468993888 | 46 | 23552 | 3551118384 | 49 | 638991235344 | |
mysql | ib_logfile1 | 2 | 66048 | 861637392 | 739 | 997888 | 271017557184 | 436 | 6459141311568 | |
mysql | undo_001 | 388 | 6406144 | 72873121728 | 310 | 5079040 | 14849403888 | 57 | 543164496864 | |
mysql | undo_002 | 384 | 6340608 | 31647207504 | 264 | 4325376 | 17278308960 | 53 | 534131213616 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 8724109680 | 4 | 260448259104 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 297386496 | 5 | 41559522576 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 279459840 | 5 | 35281873968 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 297413952 | 5 | 37823979072 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 411530064 | 5 | 31863149472 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 387058320 | 5 | 37638330048 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 484493856 | 5 | 32939357088 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 427039536 | 5 | 38002175376 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 437829744 | 5 | 31582577664 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 194502528 | 5 | 33165398112 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 105 | 2244608 | 4190726496 | 12 | 170366894544 | |
mysql | mysql | 361 | 5963776 | 117140125344 | 342 | 5603328 | 13073052432 | 68 | 509474609424 | |
sys | sys_config | 1 | 65536 | 421522992 | 0 | 0 | 0 | 2 | 12575376 | |
sakila | actor | 4 | 114688 | 8529765024 | 0 | 0 | 0 | 5 | 146171520 | |
sakila | address | 8 | 180224 | 3980979552 | 0 | 0 | 0 | 5 | 90373536 | |
sakila | category | 4 | 114688 | 4195551888 | 0 | 0 | 0 | 5 | 51902928 | |
sakila | city | 7 | 163840 | 1488905616 | 0 | 0 | 0 | 5 | 85814256 | |
sakila | country | 4 | 114688 | 1265487696 | 0 | 0 | 0 | 5 | 70113120 |
|