CLOVER🍀

That was when it all began.

MySQL 8.0で、InnoDBの状態を確認する方法を調べる

これは、なにをしたくて書いたもの?

MySQLのInnoDBストレージエンジンの状態、情報を見るのには、どうしたらよいのかな?ということで。

情報を調べて、とっかかりとして簡単にまとめておくことにしました。

環境

今回の環境は、こちらです。

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.23    |
+-----------+
1 row in set (0.00 sec)

ちなみに、特にデータは入れないまま空っぽのMySQLでコマンドだけを確認しています。

show engine innodb status/mutex

まずは、show engine innodb status/mutexでしょうか。

SHOW ENGINE ステートメント statusから。InnoDBストレージエンジンに関する情報を取得することができます。というか、これを見ておけばよいという
感じなのでは。

mysql> show engine innodb status\G
*************************** 1. row ***************************
  Type: InnoDB
  Name: 
Status: 
=====================================
2021-04-14 14:19:25 0x7f097c593700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 11 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 818 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 1
OS WAIT ARRAY INFO: signal count 1
RW-shared spins 0, rounds 0, OS waits 0
RW-excl spins 0, rounds 0, OS waits 0
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 2569
Purge done for trx's n:o < 2566 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421153728372120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421153728371264, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421153728370408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
835 OS file reads, 207 OS file writes, 44 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 553253, node heap has 0 buffer(s)
Hash table size 553253, node heap has 0 buffer(s)
Hash table size 553253, node heap has 0 buffer(s)
Hash table size 553253, node heap has 0 buffer(s)
Hash table size 553253, node heap has 0 buffer(s)
Hash table size 553253, node heap has 0 buffer(s)
Hash table size 553253, node heap has 1 buffer(s)
Hash table size 553253, node heap has 3 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number          18138816
Log buffer assigned up to    18138816
Log buffer completed up to   18138816
Log written up to            18138816
Log flushed up to            18138816
Added dirty pages up to      18138816
Pages flushed up to          18138816
Last checkpoint at           18138816
12 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2191523840
Dictionary memory allocated 379717
Buffer pool size   131072
Free buffers       130114
Database pages     954
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 812, created 142, written 160
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 954, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   16384
Free buffers       16202
Database pages     182
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 181, created 1, written 2
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 182, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   16384
Free buffers       16254
Database pages     129
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 127, created 2, written 2
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 129, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   16384
Free buffers       16294
Database pages     89
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 87, created 2, written 4
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 89, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   16384
Free buffers       16336
Database pages     47
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 45, created 2, written 6
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 47, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   16384
Free buffers       16317
Database pages     66
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 65, created 1, written 1
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 66, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   16384
Free buffers       16299
Database pages     85
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 21, created 64, written 64
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 85, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   16384
Free buffers       16210
Database pages     174
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 109, created 65, written 69
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 174, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   16384
Free buffers       16202
Database pages     182
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 177, created 5, written 12
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 182, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=75, Main thread ID=139676939044608 , state=sleeping
Number of rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 0, updated 315, deleted 0, read 4656
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

1 row in set (0.00 sec)

この情報は、InnoDB標準モニターのもののようです。

SHOW ENGINE INNODB STATUS は、InnoDB ストレージエンジンの状態に関する InnoDB 標準モニターからの広範囲にわたる情報を表示します。

SHOW ENGINE ステートメント

特に、InnoDBバッファープールの情報が気になるところですね。

第101回 InnoDBバッファプールの状態を確認するさまざまな方法:MySQL道普請便り|gihyo.jp … 技術評論社

InnoDB インメモリー構造

InnoDB 標準モニターを使用したバッファープールのモニタリング

今回、InnoDBバッファープールは2GBにしています。

----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 2191523840
Dictionary memory allocated 400726
Buffer pool size   131072
Free buffers       128760
Database pages     2302

ちなみにページサイズはデフォルトで16KBなので、Buffer pool sizeに16KBを掛けると2GBになります。

mysql> show global variables where variable_name like 'innodb_page_size';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| innodb_page_size | 16384 |
+------------------+-------+
1 row in set (0.00 sec)

mutexの方はロックの情報になります。

mysql> show engine innodb mutex\G

mutexの統計情報を有効にするには、こちらで。

innodb_monitor_enable

リセット、無効化も含めて。

mysql> set global innodb_monitor_enable = 'latch';

mysql> set global innodb_monitor_reset = 'latch';

mysql> set global innodb_monitor_disable = 'latch';

allを指定することもできるようです。

InnoDBモニター

InnoDBモニターを有効にすると、InnoDBの情報を定期的に書き出すことができます。

有効化はこちら。

InnoDB モニターの有効化

mysql> set global innodb_status_output = on;
Query OK, 0 rows affected (0.00 sec)

約15秒ごとに、標準エラー出力に情報を書き出します。デフォルトでは、エラーログに書き込まれることになります。

InnoDBモニターの情報はshow engine innodb statusと同じなのですが(show engine innodb statusがInnoDBモニターの結果を
使っているので)、show engine innodb statusとの違いは、出力される量が制限されないことです。
show engine innodb statusの場合は、出力される量は1MBに制限されるようです。

放っておくとずっと出力され続けるので、確認が済んだら無効化しましょう。

mysql> set global innodb_status_output = off;
Query OK, 0 rows affected (0.00 sec)

ロックの情報のみに絞ってモニタリングすることもできるようです。

mysql> set global innodb_status_output_locks = on;
Query OK, 0 rows affected (0.00 sec)

mysql> set global innodb_status_output_locks = off;
Query OK, 0 rows affected (0.00 sec)

infomrmation_schema

information_schemaにも、InnoDBの情報はあります。

InnoDB INFORMATION_SCHEMA テーブル

テーブルとしては、これだけですね。

mysql> show tables from information_schema like 'innodb%';
+----------------------------------------+
| Tables_in_information_schema (INNODB%) |
+----------------------------------------+
| INNODB_BUFFER_PAGE                     |
| INNODB_BUFFER_PAGE_LRU                 |
| INNODB_BUFFER_POOL_STATS               |
| INNODB_CACHED_INDEXES                  |
| INNODB_CMP                             |
| INNODB_CMPMEM                          |
| INNODB_CMPMEM_RESET                    |
| INNODB_CMP_PER_INDEX                   |
| INNODB_CMP_PER_INDEX_RESET             |
| INNODB_CMP_RESET                       |
| INNODB_COLUMNS                         |
| INNODB_DATAFILES                       |
| INNODB_FIELDS                          |
| INNODB_FOREIGN                         |
| INNODB_FOREIGN_COLS                    |
| INNODB_FT_BEING_DELETED                |
| INNODB_FT_CONFIG                       |
| INNODB_FT_DEFAULT_STOPWORD             |
| INNODB_FT_DELETED                      |
| INNODB_FT_INDEX_CACHE                  |
| INNODB_FT_INDEX_TABLE                  |
| INNODB_INDEXES                         |
| INNODB_METRICS                         |
| INNODB_SESSION_TEMP_TABLESPACES        |
| INNODB_TABLES                          |
| INNODB_TABLESPACES                     |
| INNODB_TABLESPACES_BRIEF               |
| INNODB_TABLESTATS                      |
| INNODB_TEMP_TABLE_INFO                 |
| INNODB_TRX                             |
| INNODB_VIRTUAL                         |
+----------------------------------------+
31 rows in set (0.00 sec)

詳しくは、ドキュメントを…。

とはいえ、テーブルによってはけっこうなデータ量があるので、あまり頻繁に参照するものでもなさそうです。

mysql> select count(1) from information_schema.innodb_buffer_page;
+----------+
| count(1) |
+----------+
|   131072 |
+----------+
1 row in set (0.28 sec)

performance_schema

最後は、performance_schemaです。

InnoDB の MySQL パフォーマンススキーマとの統合

setup_instrumentsテーブルと

InnoDB 関連のインストゥルメントを表示するには、innodb を含むインストゥルメント名を setup_instruments テーブルにクエリーすることができます。

mysql> select * from performance_schema.setup_instruments where name like '%innodb%';
+---------------------------------------------------------+---------+-------+-------------------+------------+---------------+
| NAME                                                    | ENABLED | TIMED | PROPERTIES        | VOLATILITY | DOCUMENTATION |
+---------------------------------------------------------+---------+-------+-------------------+------------+---------------+
| wait/synch/mutex/innodb/commit_cond_mutex               | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/innobase_share_mutex            | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/resume_encryption_cond_mutex    | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/autoinc_mutex                   | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/autoinc_persisted_mutex         | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/buf_pool_chunks_mutex           | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/buf_pool_flush_state_mutex      | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/buf_pool_LRU_list_mutex         | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/buf_pool_free_list_mutex        | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/buf_pool_zip_free_mutex         | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/buf_pool_zip_hash_mutex         | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/buf_pool_zip_mutex              | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/cache_last_read_mutex           | NO      | NO    |                   |          0 | NULL          |
| wait/synch/mutex/innodb/clone_snapshot_mutex            | NO      | NO    |                   |          0 | NULL          |

...

| memory/innodb/ut0new                                    | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/ut0pool                                   | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/ut0rbt                                    | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/ut0rnd                                    | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/ut0sort                                   | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/ut0stage                                  | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/ut0ut                                     | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/ut0vec                                    | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/ut0wqueue                                 | YES     | NULL  |                   |          0 | NULL          |
| memory/innodb/zipdecompress                             | YES     | NULL  |                   |          0 | NULL          |
+---------------------------------------------------------+---------+-------+-------------------+------------+---------------+
326 rows in set (0.01 sec)

こちらのテーブルを見るようです。

パフォーマンススキーマインスタンステーブル

mysql> select * from performance_schema.mutex_instances where name like '%innodb%';
+---------------------------------------------------------+-----------------------+---------------------+
| NAME                                                    | OBJECT_INSTANCE_BEGIN | LOCKED_BY_THREAD_ID |
+---------------------------------------------------------+-----------------------+---------------------+
| wait/synch/mutex/innodb/lock_sys_table_mutex            |       139678601749232 |                NULL |
| wait/synch/mutex/innodb/rw_lock_list_mutex              |        94571645319424 |                NULL |
| wait/synch/mutex/innodb/sync_array_mutex                |       139678644745288 |                NULL |
| wait/synch/mutex/innodb/trx_pool_manager_mutex          |       139678644745464 |                NULL |
| wait/synch/mutex/innodb/trx_pool_mutex                  |       139678644745912 |                NULL |
| wait/synch/mutex/innodb/trx_mutex                       |       139678751658040 |                NULL |
| wait/synch/mutex/innodb/trx_undo_mutex                  |       139678751658608 |                NULL |
| wait/synch/mutex/innodb/trx_mutex                       |       139678751658896 |                NULL |
| wait/synch/mutex/innodb/trx_undo_mutex                  |       139678751659464 |                NULL |
| wait/synch/mutex/innodb/trx_mutex                       |       139678751659752 |                NULL |
| wait/synch/mutex/innodb/trx_undo_mutex                  |       139678751660320 |                NULL |
| wait/synch/mutex/innodb/trx_mutex                       |       139678751660608 |                NULL |

...

| wait/synch/mutex/innodb/dict_table_mutex                |        94571696031856 |                NULL |
| wait/synch/mutex/innodb/autoinc_mutex                   |        94571696185920 |                NULL |
| wait/synch/mutex/innodb/autoinc_persisted_mutex         |        94571694357872 |                NULL |
| wait/synch/mutex/innodb/dict_table_mutex                |       139674819500176 |                NULL |
| wait/synch/mutex/innodb/autoinc_mutex                   |       139674551243008 |                NULL |
| wait/synch/mutex/innodb/autoinc_persisted_mutex         |       139674551072096 |                NULL |
| wait/synch/mutex/innodb/autoinc_mutex                   |       139674551440384 |                NULL |
| wait/synch/mutex/innodb/autoinc_persisted_mutex         |       139674551076496 |                NULL |
+---------------------------------------------------------+-----------------------+---------------------+
1703 rows in set (0.00 sec)
mysql> select * from performance_schema.rwlock_instances where name like '%innodb%';
+--------------------------------------------------+-----------------------+---------------------------+----------------------+
| NAME                                             | OBJECT_INSTANCE_BEGIN | WRITE_LOCKED_BY_THREAD_ID | READ_LOCKED_BY_COUNT |
+--------------------------------------------------+-----------------------+---------------------------+----------------------+
| wait/synch/sxlock/innodb/undo_spaces_lock        |       139678644844464 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/trx_i_s_cache_lock      |       139678644860176 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048589264 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048589368 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048589472 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048589576 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048589680 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048589784 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048589888 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048589992 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/hash_table_locks        |       139678048590096 |                      NULL |                    0 |

...

| wait/synch/sxlock/innodb/dict_table_stats        |       139678699576256 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/index_tree_rw_lock      |        94571695944544 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/dict_table_stats        |        94571695937664 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/index_tree_rw_lock      |        94571696216256 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/dict_table_stats        |        94571696096960 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/index_tree_rw_lock      |       139674552573152 |                      NULL |                    0 |
| wait/synch/sxlock/innodb/dict_table_stats        |       139674552102064 |                      NULL |                    0 |
+--------------------------------------------------+-----------------------+---------------------------+----------------------+
393 rows in set (0.00 sec)
mysql> select * from performance_schema.cond_instances where name like '%innodb%';
+-----------------------------------------------+-----------------------+
| NAME                                          | OBJECT_INSTANCE_BEGIN |
+-----------------------------------------------+-----------------------+
| wait/synch/cond/innodb/commit_cond            |        94571645186336 |
| wait/synch/cond/innodb/resume_encryption_cond |        94571645186208 |
+-----------------------------------------------+-----------------------+
2 rows in set (0.00 sec)
mysql> select * from performance_schema.file_instances where event_name like '%innodb%';
+-----------------------------------------+---------------------------------------+------------+
| FILE_NAME                               | EVENT_NAME                            | OPEN_COUNT |
+-----------------------------------------+---------------------------------------+------------+
| /var/lib/mysql/ibdata1                  | wait/io/file/innodb/innodb_data_file  |          3 |
| /var/lib/mysql/#ib_16384_0.dblwr        | wait/io/file/innodb/innodb_dblwr_file |          2 |
| /var/lib/mysql/#ib_16384_1.dblwr        | wait/io/file/innodb/innodb_dblwr_file |          2 |
| /var/lib/mysql/ib_logfile0              | wait/io/file/innodb/innodb_log_file   |          2 |
| /var/lib/mysql/ib_logfile1              | wait/io/file/innodb/innodb_log_file   |          2 |
| /var/lib/mysql/undo_001                 | wait/io/file/innodb/innodb_data_file  |          3 |
| /var/lib/mysql/undo_002                 | wait/io/file/innodb/innodb_data_file  |          3 |
| /var/lib/mysql/ibtmp1                   | wait/io/file/innodb/innodb_data_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_1.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_2.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_3.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_4.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_5.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_6.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_7.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_8.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_9.ibt  | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/#innodb_temp/temp_10.ibt | wait/io/file/innodb/innodb_temp_file  |          2 |
| /var/lib/mysql/mysql.ibd                | wait/io/file/innodb/innodb_data_file  |          3 |
| /var/lib/mysql/sys/sys_config.ibd       | wait/io/file/innodb/innodb_data_file  |          1 |
+-----------------------------------------+---------------------------------------+------------+
20 rows in set (0.00 sec)

とはいえ、まずはshow engine innodb statusが基本なのでしょうね。