mysql> show engine innodb status;//查看innodb存储引擎状态
mysql> show variables like 'innodb_version';//查看innodb存储引擎版本
mysql> show variables like 'innodb_%io_threads';//查看innodb存储引擎io_thread参数
innodb存储引擎内存由缓冲池(buffer pool)、重做日志缓冲池(redo log buffer)和额外内存池(additional memory pool)组成
mysql> show variables like 'innodb_buffer_pool_size';
mysql> show variables like 'innodb_log_buffer_size';
mysql> show variables like 'innodb_additional_mem_pool_size';
关键特性
插入缓冲
使用前提:非聚集且不唯一的索引
两次写
mysql> show variables like 'innodb_doublewrite';
mysql> show global status like 'innodb_dblwr%';//查看运行情况
自适应哈希索引
mysql> show variables like 'innodb_adaptive_hash_index';
innodb_fast_shutdown
innodb_force_recovery