如何查看InnoDB设置？

Is there a MySQL command that I can execute which will show settings such as innodb_file_format, or a configuration file which I should check?

是否有我可以执行的MySQL命令,它将显示innodb_file_format等设置,或者我应该检查的配置文件?

MySQL version: 5.5.32

MySQL版本:5.5.32

4 个解决方案

#1

show variables like 'innodb%';

#2

show variables like 'inno%' should show up all the innodb settings in effect at the moment you run the query.

显示像'inno%'这样的变量应该显示运行查询时生效的所有innodb设置。

As for files, there should probably be something like /etc/mysql/my.ini or a my.cnf somewhere.

至于文件,应该有/ etc / mysql / my.ini或某个地方的my.cnf。

#3

The other answers are only half correct because not all InnoDB variables start with innodb_. See the manual for the full list of possible InnoDB variables your setup may have.

其他答案只有一半是正确的,因为并非所有InnoDB变量都以innodb_开头。有关您的设置可能具有的InnoDB变量的完整列表,请参阅手册。

(Note that the manual shows the options for the latest version in each "release series". For example, the new innodb_flush_sync has just been added a few days ago, but it is already online in the 5.7 release series manual.)

(请注意,本手册显示了每个“发布系列”中最新版本的选项。例如,几天前刚刚添加了新的innodb_flush_sync,但它已经在5.7版本系列手册中已经在线了。)

To dump them all, use:

要全部转储它们,请使用:

show variables where variable_name in(
    'unique_checks',
    'foreign_key_checks',
    'timed_mutexes',
    'ngram_token_size',
    'mecab_rc_file'
)or variable_name like'innodb_%'
or variable_name like'%_innodb'
or variable_name like'%_innodb_%'
or variable_name like'daemon_memcached_%'
or variable_name like'%_daemon_memcached'
or variable_name like'%_daemon_memcached_%';

The seemingly redundant boundary checks are included to guard against false positives when future introduction of non-InnoDB variables happens to contain the string "innodb" (e.g. "RinnoDB" or "InnoDbex").

当未来引入非InnoDB变量恰好包含字符串“innodb”(例如“RinnoDB”或“InnoDbex”)时,包括看似冗余的边界检查以防止误报。

#4

Try This

  SHOW ENGINE INNODB STATUS\G

#1

show variables like 'innodb%';

#2