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 | 900448032 | 0 | 0 | 0 | 2 | 201445200 | |
charsets | Index | 1 | 19495 | 260076960 | 0 | 0 | 0 | 2 | 14085984 | |
mysql | ibdata1 | 20 | 2441216 | 7951112928 | 66 | 10403840 | 7720621392 | 66 | 1108315883664 | |
mysql | ib_logfile0 | 6 | 4608 | 839796672 | 29 | 14848 | 2261827920 | 32 | 445055482080 | |
mysql | ib_logfile1 | 2 | 66048 | 904234320 | 335 | 366080 | 143749558656 | 203 | 3053329181760 | |
mysql | undo_001 | 388 | 6406144 | 43141906896 | 221 | 3620864 | 4647847776 | 31 | 298424937888 | |
mysql | undo_002 | 382 | 6307840 | 44370072912 | 191 | 3129344 | 4255834704 | 31 | 321894148224 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 22798695216 | 4 | 272570926848 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 265508496 | 5 | 37789171200 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 237473280 | 5 | 42826934832 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 241270656 | 5 | 34837706640 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 296595024 | 5 | 34689424176 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 328769232 | 5 | 32543395104 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 352368192 | 5 | 32071759104 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 228405408 | 5 | 55441504800 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 281639424 | 5 | 34511997696 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 279960912 | 5 | 32518091232 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 97 | 1851392 | 40005998736 | 8 | 103253232720 | |
mysql | mysql | 355 | 5865472 | 90982189056 | 148 | 2424832 | 3198440256 | 36 | 271219979712 | |
sys | sys_config | 4 | 114688 | 740788224 | 0 | 0 | 0 | 5 | 57846096 | |
sakila | actor | 5 | 131072 | 990948816 | 0 | 0 | 0 | 5 | 43435392 | |
sakila | address | 8 | 180224 | 1294088400 | 0 | 0 | 0 | 5 | 32447184 | |
sakila | category | 4 | 114688 | 894915648 | 0 | 0 | 0 | 5 | 35289936 | |
sakila | city | 7 | 163840 | 1597298208 | 0 | 0 | 0 | 5 | 28854672 | |
sakila | country | 4 | 114688 | 741599232 | 0 | 0 | 0 | 5 | 36397680 |
|