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 | 1032175584 | 0 | 0 | 0 | 2 | 179629824 | |
charsets | Index | 1 | 19495 | 209386320 | 0 | 0 | 0 | 2 | 14929728 | |
mysql | ibdata1 | 20 | 2441216 | 8005355424 | 39 | 7618560 | 4176899760 | 41 | 724958212704 | |
mysql | ib_logfile0 | 6 | 4608 | 1003734336 | 17 | 8704 | 3381314640 | 20 | 233831589552 | |
mysql | ib_logfile1 | 2 | 66048 | 1031274288 | 235 | 212480 | 104870446032 | 141 | 1854240765696 | |
mysql | undo_001 | 388 | 6406144 | 72204008976 | 230 | 3768320 | 3394461840 | 17 | 158989694688 | |
mysql | undo_002 | 384 | 6340608 | 45917858448 | 178 | 2916352 | 3502461072 | 23 | 231971684736 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 20594923008 | 4 | 268424613600 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 259419072 | 5 | 66683228304 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 348467328 | 5 | 51845773056 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 373722624 | 5 | 39498400128 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 324237408 | 5 | 34486219680 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 302099424 | 5 | 33960823248 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 410870064 | 5 | 36308083680 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 486462768 | 5 | 33994267296 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 186415152 | 5 | 32732118144 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 206750544 | 5 | 39053861616 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 97 | 1916928 | 982029840 | 9 | 129327487344 | |
mysql | mysql | 344 | 5685248 | 89489535696 | 23 | 376832 | 1183660368 | 21 | 65721430896 | |
sys | sys_config | 4 | 114688 | 1180853520 | 0 | 0 | 0 | 5 | 53112576 | |
sakila | actor | 4 | 114688 | 695707584 | 0 | 0 | 0 | 5 | 35078736 | |
sakila | address | 8 | 180224 | 2367522960 | 0 | 0 | 0 | 5 | 39953232 | |
sakila | category | 4 | 114688 | 871520496 | 0 | 0 | 0 | 5 | 37910928 | |
sakila | city | 6 | 147456 | 1682836848 | 0 | 0 | 0 | 5 | 33768240 | |
sakila | country | 4 | 114688 | 823686864 | 0 | 0 | 0 | 5 | 35525424 |
|