<div>
by default the connections timeout is 8 hours. you can increase it.<br />
You can also using connection refresh mechanism, before its time out.<br />
<br />
c3p0 library would help you in this regard.<br />
<br />
<br />
<br />

</div>


by default the connections timeout is 8 hours. you can increase it.
You can also using connection refresh mechanism, before its time out.

c3p0 library would help you in this regard.





<div>
<div class="content wysiwyg-content">
Hi:<br />
<br />
I am building a high scale back-end daemon. <br />
<br />
The backend database for logging purpose is MySQL.<br />
<br />
Code and everything works fine. Currently on my Ubuntu desktop<br />
MySQL server works fine.......but at night sometime server goes to sleeps meaning<br />
no client connect is possible and also API based connection does not work<br />
<br />
When I try connecting though command line prompt I get the following messages:<br />
<br />
ERROR 2006 (HY000): MySQL server has gone away<br />
No connection. Trying to reconnect...<br />
<br />
What's the way to have MySQL server up and running during long period of less activity or inactivity.<br />
<br />
Best Regards,<br />
<br />
-Sunnybrad<br />

</div>
</div>


Hi:

I am building a high scale back-end daemon. 

The backend database for logging purpose is MySQL.

Code and everything works fine. Currently on my Ubuntu desktop
MySQL server works fine.......but at night sometime server goes to sleeps meaning
no client connect is possible and also API based connection does not work

When I try connecting though command line prompt I get the following messages:

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...

What's the way to have MySQL server up and running during long period of less activity or inactivity.

Best Regards,

-Sunnybrad


MySQL Server Timeout

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.