How to check my InnoDB settings?

Question

Is there a MySQL command that I can execute that will show parameters like innodb_file_format , or a configuration file that I have to check?

MySQL Version: 5.5.32

Answer 1

show variables like 'innodb%';

Answer 2

show variables like 'inno%' should display all innodb settings that were in effect at the time the request was run.

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

Answer 3

The other answers are only half correct, because not all InnoDB variables start with innodb_ . See the manual for a complete list of possible InnoDB variables that your settings may have.

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

To reset 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_%'; 

Redundant border checks appear to be included to protect against false positives when future non-InnoDB variable entries contain the string “innodb” (for example, “RinnoDB” or “InnoDbex”).

Answer 4

try it

  SHOW ENGINE INNODB STATUS\G 

Answer 5

you can see this page, and I hope this is what you are looking for: here is the page