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 | 71 | 12271616 | 8461160400 | 67 | 1599079631952 | |
mysql | ib_logfile0 | 6 | 4608 | 809274576 | 29 | 14848 | 1026736128 | 32 | 443680450224 | |
mysql | ib_logfile1 | 2 | 66048 | 963342336 | 343 | 529920 | 87439400928 | 203 | 2976187440864 | |
mysql | undo_001 | 388 | 6406144 | 41808707424 | 194 | 3178496 | 5774242320 | 29 | 280684588800 | |
mysql | undo_002 | 382 | 6307840 | 29911575408 | 158 | 2588672 | 8042628000 | 28 | 307147150992 | |
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 | 51 | 2473984 | 2410033824 | 29 | 451938219216 | |
mysql | mysql | 395 | 6520832 | 92540552544 | 299 | 4898816 | 6041980032 | 37 | 354674775312 | |
sys | sys_config | 4 | 114688 | 803928576 | 0 | 0 | 0 | 5 | 37109952 | |
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 |
|