What is the default MySQL wait_timeout and interactive_timeout value?

Question

I changed these timeouts globally with:

SET GLOBAL wait_timeout=30; SET GLOBAL interactive_timeout=30

and noticed that I have another application running which got problems with these "low" timeouts. So I would like to undo this and only apply it to the specific database.

Answer 1

Referring to the MySQL Manual the default values for wait_timeout and for interactive_timeout are - 28800.

On thread startup, the session wait_timeout value is initialized from the global wait_timeout value or from the global interactive_timeout value, depending on the type of client (as defined by the CLIENT_INTERACTIVE connect option to mysql_real_connect()). See also interactive_timeout.