Getting times out despite server settings

[expired user #5305]'s profile image [expired user #5305] posted 13 years ago in General Permalink
SQL Error (2013): Lost connection to MySQL server during query

I keep getting this error after 5 mins when running long select statements despite the fact that my wait_timeout is 28800 and my interactive_timeout is 28800.

Any suggestions?
[expired user #4063]'s profile image [expired user #4063] posted 13 years ago Permalink
Check and see if this information will help you:

http://dev.mysql.com/doc/refman/5.5/en/gone-away.html
http://dev.mysql.com/doc/refman/5.5/en/mysql-select-db.html

Please also specify what exactly you are doing
[expired user #5305]'s profile image [expired user #5305] posted 13 years ago Permalink
I'm running a select statement on the server that takes longer than 5 minutes to run. Heidi gets disconnected after 5 mins despite wait_timeout is 28800 and interactive_timeout is 28800

Please login to leave a reply, or register at first.