mysql get set variable value

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;
Feedback