Mysql Connection Timeout for 8hrs

vignesh4sh · 02-27-2013, 06:19 AM

Hi,
Mysql connection timeout for 8hrs once. Everytime i need to start the mysql.

I have changed the configuration my.cnf file
vi /etc/mysql/my.cnf

Quote:

wait_timeout = 31536000

But still i getting the connection timeout issue.

Quote:

mysql> SHOW GLOBAL VARIABLES LIKE "%wait%";

| innodb_lock_wait_timeout | 50 |
| innodb_spin_wait_delay | 6 |
| lock_wait_timeout | 31536000 |
| performance_schema_events_waits_history_long_size | 10000 |
| performance_schema_events_waits_history_size | 10 |
| wait_timeout | 31536000

Please need suggestions
Thanks

Habitual · 02-27-2013, 06:46 AM

Timeout comes from what exactly?
a program (PHP script)?

Where is the mysql service|daemon located? Local machine?

You set the max value for wait_timeout, did you restart mysqld?

vignesh4sh · 02-27-2013, 07:18 AM

Thanks for reply,

Times out comes for tomcat application and php.
Mysql service running in server

I added wait_timeout = 31536000 in configuration file

Thanks

Habitual · 02-27-2013, 02:13 PM

did you restart mysqld?

vignesh4sh · 03-13-2013, 12:14 AM

I fixed the issue.I was not added interactive_timeout in configuration. so that i was getting that issue.

Quote:

sudo vi /etc/mysql/my.cnf

Add
wait_timeout = 31536000
interactive_timeout = 31536000

Restart the Mysql.
sudo service mysql restart

To check the timeout in mysql

Quote:

mysql -u root -p

mysql > SHOW VARAIBLES LIKE %wait%;

It shows like wait_timeout = 31536000

similary
mysql > SHOW GLOBAL VARAIBLES LIKE %wait%;
mysql > SHOW SESSION VARAIBLES LIKE %wait%;

Thanks

Habitual · 03-13-2013, 06:09 AM

another symptom of http://www.linuxquestions.org/questi...rd-4175451572/ ?

---------- Post added 03-13-13 at 07:10 AM ----------

n/m then. good job fixing it!