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 | 1238630448 | 0 | 0 | 0 | 2 | 252172272 | |
charsets | Index | 1 | 19495 | 301199712 | 0 | 0 | 0 | 2 | 15446112 | |
mysql | ibdata1 | 20 | 2441216 | 6422405088 | 58 | 16564224 | 10678742448 | 57 | 991148657664 | |
mysql | ib_logfile0 | 6 | 4608 | 980194512 | 19 | 9728 | 2073353568 | 22 | 284003995968 | |
mysql | ib_logfile1 | 2 | 66048 | 1026135792 | 1178 | 2237952 | 317046554352 | 496 | 6525972538800 | |
mysql | undo_001 | 388 | 6406144 | 67612068480 | 340 | 5570560 | 11355051840 | 30 | 362948029488 | |
mysql | undo_002 | 384 | 6340608 | 38156423712 | 358 | 5865472 | 6932854368 | 31 | 399038010624 | |
mysql | ibtmp1 | 0 | 0 | 0 | 143 | 14729216 | 15317688672 | 4 | 232114667664 | |
#innodb_temp | temp_1 | 0 | 0 | 0 | 3 | 114688 | 181868016 | 5 | 47568541152 | |
#innodb_temp | temp_2 | 0 | 0 | 0 | 3 | 114688 | 143848320 | 5 | 39848300976 | |
#innodb_temp | temp_3 | 0 | 0 | 0 | 3 | 114688 | 229049568 | 5 | 36210721008 | |
#innodb_temp | temp_4 | 0 | 0 | 0 | 3 | 114688 | 336285840 | 5 | 35933790816 | |
#innodb_temp | temp_5 | 0 | 0 | 0 | 3 | 114688 | 256011888 | 5 | 35494070304 | |
#innodb_temp | temp_6 | 0 | 0 | 0 | 3 | 114688 | 247818912 | 5 | 41535792144 | |
#innodb_temp | temp_7 | 0 | 0 | 0 | 3 | 114688 | 243435984 | 5 | 34881421344 | |
#innodb_temp | temp_8 | 0 | 0 | 0 | 3 | 114688 | 253617408 | 5 | 33088644336 | |
#innodb_temp | temp_9 | 0 | 0 | 0 | 3 | 114688 | 300511200 | 5 | 33109000320 | |
#innodb_temp | temp_10 | 0 | 0 | 0 | 80 | 2621440 | 595832177424 | 24 | 430394505024 | |
mysql | mysql | 371 | 6127616 | 124265081952 | 268 | 4390912 | 9188632992 | 35 | 366343198848 | |
sys | sys_config | 4 | 114688 | 911301072 | 0 | 0 | 0 | 5 | 43505616 | |
mysql | binlog | 48 | 872 | 1123430880 | 35 | 7031 | 2448656496 | 180 | 503631376512 | |
mysql | auto | 3 | 56 | 616610544 | 0 | 0 | 0 | 2 | 14924448 | |
mysqld | mysqld | 0 | 0 | 0 | 1 | 4 | 6936336 | 2 | 38285280 | |
french | errmsg | 3 | 304914 | 967342464 | 0 | 0 | 0 | 2 | 1813761840 | |
spanish | errmsg | 3 | 305161 | 1998290448 | 0 | 0 | 0 | 2 | 1748338416 |
|