How to maintain the MYSQL connection for the whole session.

[madhoriya22]

Hi,
In my web application I am using Mysql at backend. The problem is If I leaves the application Idle for sometime the connection to Mysql automatically closes.
Is there anyway by which I can maintain the connection for whole session in Mysql.

Thanks and regards,
madhoriya

[mwasif]

Increase mysql connection time out in php.ini, variable is mysql.connect_timeout.

[madhoriya22]

Increase mysql connection time out in php.ini, variable is mysql.connect_timeout.

Hi mwasif,
I am not using php. I am using using JSP and JDBC. Is it possible through query in Mysql.

Thanks and regards,
madhoriya

[mwasif]

You can change the value in query too
connect_timeout
Use this query to see the connection timeout.

SHOW VARIABLES LIKE 'connect_timeout';

This query will change the connection timeout to 60 seconds, change the time according to your needs.

SET GLOBAL connect_timeout=60;

This value will be reset when the MySQL server will be restarted.

Your MySQL must have SUPER priviliges to perform this query.

[madhoriya22]

You can change the value in query too
connect_timeout
Use this query to see the connection timeout.

SHOW VARIABLES LIKE 'connect_timeout';

This query will change the connection timeout to 60 seconds, change the time according to your needs.

SET GLOBAL connect_timeout=60;

This value will be reset when the MySQL server will be restarted.

Your MySQL must have SUPER priviliges to perform this query.

Hi mwasif,
I got it. Thanks.
The value first query is returnin is 5(min/sec i dont know).

Thanks and regards,
madhoriya

[mwasif]

The value first query is returnin is 5(min/sec i dont know).

Connection time out value is in seconds.

[Sweetbomb]

Greetings all,

I am a very very big Novice/Newbie to any type of scripting..

I am trying to run the SHOW query on my MySQL database but it keeps asking me to select "One" Column before the query will run...

I am not sure what to do... I need to find out the timeout on the Roster Master Module that is running on my Dragonfly CMS...

When I try to parse using the Roster Master module to the SOE guild roster's my database keeps timing out and does not allow me to pull in my guild rosters.

Any help is much appreciated.

Regards,

[Sweetbomb]

Greetings all,

I am a very very big Novice/Newbie to any type of scripting..

I am trying to run the SHOW query on my MySQL database but it keeps asking me to select "One" Column before the query will run...

I am not sure what to do... I need to find out the timeout on the Roster Master Module that is running on my Dragonfly CMS...

When I try to parse using the Roster Master module to the SOE guild roster's my database keeps timing out and does not allow me to pull in my guild rosters.

Any help is much appreciated.

Regards,

I was able to find the timeout it was 10... I tried the SET GLOBAL but it said that I needed Super privilege to be able to do this command... I sent an message to my host asking for their help with this part..

But, is there any other way that I can add the timeout into my MySQL database without such privileges?

Thanks,