Re: Performance Issues - errno 12 on MySQL5.0.45/Windows Server 2003

[Rick James]

"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())."

Normally the commandline "mysql" is 'interactive', and a Perl script is not interactive. So if you are wondering about the timeout affecting your script, and you do this in mysql:
SHOW VARIABLES LIKE 'wait_timeout';
you don't get the value that affects your script.

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_interactive_timeout
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_wait_timeout