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 | 957431904 | 0 | 0 | 0 | 2 | 179186832 | |
charsets | Index | 1 | 19495 | 235569840 | 0 | 0 | 0 | 2 | 14158320 | |
mysql | ibdata1 | 20 | 2441216 | 6212034576 | 179 | 15695872 | 13323234672 | 180 | 2932527585504 | |
mysql | ib_logfile0 | 6 | 4608 | 590992512 | 85 | 43520 | 5686032528 | 88 | 1202146149072 | |
mysql | ib_logfile1 | 2 | 66048 | 820830912 | 526 | 414208 | 69581920320 | 368 | 5135931202512 | |
mysql | undo_001 | 388 | 6406144 | 71908780944 | 330 | 5406720 | 22575392928 | 63 | 715962485568 | |
mysql | undo_002 | 384 | 6340608 | 34957754832 | 351 | 5750784 | 13300391808 | 56 | 955651400352 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 14066151264 | 4 | 226805485104 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 104718240 | 5 | 32885689584 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 104030256 | 5 | 30209241216 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 86856528 | 5 | 35448218256 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 171433680 | 5 | 35309371680 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 276357840 | 5 | 37553600832 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 374490336 | 5 | 32031399840 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 224326608 | 5 | 31460669856 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 53 | 1523712 | 10174485024 | 14 | 232982652144 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 5 | 212992 | 207041472 | 6 | 59847605136 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 72 | 2228224 | 157875124176 | 20 | 350747360304 | |
mysql | mysql | 412 | 6799360 | 154488945600 | 111 | 1818624 | 11655091536 | 85 | 413207298768 | |
sys | sys_config | 4 | 114688 | 865465920 | 0 | 0 | 0 | 5 | 45847296 | |
sakila | actor | 5 | 131072 | 876156864 | 0 | 0 | 0 | 5 | 40695600 | |
sakila | address | 9 | 196608 | 10534221456 | 0 | 0 | 0 | 5 | 42959664 | |
sakila | category | 4 | 114688 | 1089655248 | 0 | 0 | 0 | 5 | 47854752 | |
sakila | city | 7 | 163840 | 808566000 | 0 | 0 | 0 | 5 | 36218160 | |
sakila | country | 4 | 114688 | 753228432 | 0 | 0 | 0 | 5 | 30034224 |
|