-
- Item
- 7 February 2011
- Jaymon
mysql get set variable value #mysql #learned #db
If you want to know what value your mysql currently has for a given variable, you can do in the mysql commmand line: $ show variables where variable_name='VALUE'; so, if you want to see how long innodb will wait for a lock: $ show variables where variable_name='innodb_lock_wait_timeout'; And to see all variables, you can: $ show variables;