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 | 1038603984 | 0 | 0 | 0 | 2 | 201949968 | |
charsets | Index | 1 | 19495 | 207788592 | 0 | 0 | 0 | 2 | 13185744 | |
mysql | ibdata1 | 20 | 2441216 | 7130525424 | 60 | 9207808 | 6485887584 | 63 | 1031301296256 | |
mysql | ib_logfile0 | 6 | 4608 | 852922224 | 27 | 13824 | 1523306928 | 30 | 392045626368 | |
mysql | ib_logfile1 | 2 | 66048 | 963209808 | 331 | 274944 | 227240050224 | 212 | 3740381494080 | |
mysql | undo_001 | 388 | 6406144 | 65355249696 | 233 | 3817472 | 5177910672 | 31 | 295918542480 | |
mysql | undo_002 | 384 | 6340608 | 35170039872 | 227 | 3719168 | 6927306144 | 32 | 317735258544 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 34075534416 | 4 | 257354098848 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 324034656 | 5 | 48496106736 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 254270544 | 5 | 50175503664 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 287338128 | 5 | 45165173856 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 251659056 | 5 | 36331593936 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 320082048 | 5 | 33228705840 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 408634512 | 5 | 35189226864 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 305833440 | 5 | 36826611888 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 246449280 | 5 | 33752171376 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 348279888 | 5 | 35174963472 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 8 | 393216 | 553591104 | 8 | 104731092048 | |
mysql | mysql | 344 | 5685248 | 138902380320 | 48 | 786432 | 1010538144 | 32 | 107241094752 | |
sys | sys_config | 4 | 114688 | 848254704 | 0 | 0 | 0 | 5 | 46493568 | |
sakila | actor | 5 | 131072 | 1293633792 | 0 | 0 | 0 | 5 | 62928096 | |
sakila | address | 9 | 196608 | 9207128304 | 0 | 0 | 0 | 5 | 55203456 | |
sakila | category | 4 | 114688 | 798456384 | 0 | 0 | 0 | 5 | 41396256 | |
sakila | city | 6 | 147456 | 789059568 | 0 | 0 | 0 | 5 | 70613664 | |
sakila | country | 4 | 114688 | 568454304 | 0 | 0 | 0 | 5 | 35622576 |
|