table_io_waits_summary_by_table テーブルを見ればわかるらしいです。テーブル定義は以下でCOUNT_*をテーブルごとに表示して時間を置いて実行することで確認することができます。
mysql> desc performance_schema.table_io_waits_summary_by_table; +------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------+------+-----+---------+-------+ | OBJECT_TYPE | varchar(64) | YES | | NULL | | | OBJECT_SCHEMA | varchar(64) | YES | | NULL | | | OBJECT_NAME | varchar(64) | YES | | NULL | | | COUNT_STAR | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_WAIT | bigint(20) unsigned | NO | | NULL | | | COUNT_READ | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_READ | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_READ | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_READ | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_READ | bigint(20) unsigned | NO | | NULL | | | COUNT_WRITE | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_WRITE | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_WRITE | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_WRITE | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_WRITE | bigint(20) unsigned | NO | | NULL | | | COUNT_FETCH | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_FETCH | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_FETCH | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_FETCH | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_FETCH | bigint(20) unsigned | NO | | NULL | | | COUNT_INSERT | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_INSERT | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_INSERT | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_INSERT | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_INSERT | bigint(20) unsigned | NO | | NULL | | | COUNT_UPDATE | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_UPDATE | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_UPDATE | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_UPDATE | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_UPDATE | bigint(20) unsigned | NO | | NULL | | | COUNT_DELETE | bigint(20) unsigned | NO | | NULL | | | SUM_TIMER_DELETE | bigint(20) unsigned | NO | | NULL | | | MIN_TIMER_DELETE | bigint(20) unsigned | NO | | NULL | | | AVG_TIMER_DELETE | bigint(20) unsigned | NO | | NULL | | | MAX_TIMER_DELETE | bigint(20) unsigned | NO | | NULL | | +------------------+---------------------+------+-----+---------+-------+ 38 rows in set (0.00 sec)
selectなのかupdateなのかをそれぞれ回数で出力する場合は以下です。結構な行数のテストテーブルをselectしたので以下のようになっています。各テーブルごとに複数回実施して差分を確認すればアクセス頻度の多いテーブルを確認することができます。
mysql> SELECT OBJECT_NAME,COUNT_FETCH,COUNT_INSERT,COUNT_UPDATE,COUNT_DELETE FROM performance_schema.table_io_waits_summary_by_table where OBJECT_NAME='friends'; +-------------+-------------+--------------+--------------+--------------+ | OBJECT_NAME | COUNT_FETCH | COUNT_INSERT | COUNT_UPDATE | COUNT_DELETE | +-------------+-------------+--------------+--------------+--------------+ | friends | 1531312 | 0 | 0 | 0 | +-------------+-------------+--------------+--------------+--------------+ 1 row in set (0.00 sec)
