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 | 915628032 | 0 | 0 | 0 | 2 | 159358848 | |
charsets | Index | 1 | 19495 | 221040864 | 0 | 0 | 0 | 2 | 16478880 | |
mysql | ibdata1 | 20 | 2441216 | 12082686528 | 39 | 4030464 | 2883666720 | 42 | 1127784205680 | |
mysql | ib_logfile0 | 6 | 4608 | 809274576 | 19 | 9728 | 744687504 | 22 | 296840597856 | |
mysql | ib_logfile1 | 2 | 66048 | 963342336 | 181 | 201216 | 39178811760 | 115 | 1675236197712 | |
mysql | undo_001 | 387 | 6389760 | 34681658352 | 74 | 1212416 | 2300948496 | 17 | 142227071712 | |
mysql | undo_002 | 382 | 6307840 | 29911575408 | 60 | 983040 | 6778630320 | 18 | 154483908480 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 11049228960 | 4 | 217396646016 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 295050624 | 5 | 40822108800 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 238920528 | 5 | 33908841648 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 251295792 | 5 | 35550676656 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 265579248 | 5 | 35160529536 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 319826496 | 5 | 33577676880 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 262996800 | 5 | 50320063728 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 317924640 | 5 | 35043681552 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 278073840 | 5 | 33588138672 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 350416176 | 5 | 34078583088 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 42 | 1998848 | 2034364992 | 24 | 370166707152 | |
mysql | mysql | 385 | 6356992 | 89563043856 | 73 | 1196032 | 2022245808 | 24 | 179324294160 | |
sys | sys_config | 1 | 65536 | 376684704 | 0 | 0 | 0 | 2 | 10749552 | |
sakila | actor | 1 | 65536 | 249253488 | 0 | 0 | 0 | 2 | 5673888 | |
sakila | address | 1 | 65536 | 336611616 | 0 | 0 | 0 | 2 | 4370784 | |
sakila | category | 1 | 65536 | 352974864 | 0 | 0 | 0 | 2 | 17813136 | |
sakila | city | 7 | 163840 | 1223384976 | 0 | 0 | 0 | 5 | 2565224112 | |
sakila | country | 4 | 114688 | 833305968 | 0 | 0 | 0 | 5 | 40682400 |
|