これは、なにをしたくて書いたもの?
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 標準モニターからの広範囲にわたる情報を表示します。
特に、InnoDBバッファープールの情報が気になるところですね。
第101回 InnoDBバッファプールの状態を確認するさまざまな方法:MySQL道普請便り|gihyo.jp … 技術評論社
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の統計情報を有効にするには、こちらで。
リセット、無効化も含めて。
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の情報を定期的に書き出すことができます。
有効化はこちら。
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)
こちらのテーブルを見るようです。
- mutex_instances: 相互排他ロック同期オブジェクトインスタンス
- cond_instances: 条件同期オブジェクトインスタンス
- rwlock_instances: ロック同期オブジェクトインスタンス
- file_instances: ファイルインスタンス
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
が基本なのでしょうね。