egghelp/eggheads community

mysql server gone away

2011-02-04T13:39:49-04:00

thommey ..
The checksqlalive snipplet, can you expand on it so that if it returns 1, it does nothing, if it returns NOTHING it would restart the mysql server.

Statistics: Posted by kenh83 — Fri Feb 04, 2011 1:39 pm

mysql server gone away

2010-09-17T18:13:48-04:00

woops, sorry, should've been:

Code:

bind time - * checksqlalive proc checksqlalive {args} {   mysql::ping $::dbhandle }

Statistics: Posted by thommey — Fri Sep 17, 2010 6:13 pm

mysql server gone away

2010-09-17T10:19:36-04:00

cant find the correct args

Tcl error [checksqlalive]: wrong # args: should be "checksqlalive"

:S

Statistics: Posted by ultralord — Fri Sep 17, 2010 10:19 am

mysql server gone away

2010-09-16T06:30:42-04:00

ahhh it was easy thanks for great help

Statistics: Posted by ultralord — Thu Sep 16, 2010 6:30 am

mysql server gone away

2010-09-15T07:56:02-04:00

Let your mysql database handle be in the global $dbhandle variable.

Code:

bind time - * checksqlaliveproc checksqlalive {} {  mysql::ping $::dbhandle}

That will not only check if the connection is alive every minute but also automatically reconnect if it timed out. (Alternatively, do that before every sql statement you execute). See also mysql reference manual.

Statistics: Posted by thommey — Wed Sep 15, 2010 7:56 am

mysql server gone away

2010-09-15T07:06:17-04:00

hello i make my script but days now i have that problem when i run the proc sometimes not always it says on telnet

::mysql::sel/db server: MySQL server has gone away

after .rehash is working of course does anyone now how i can fix it.. or make .rehash if that problem appear?

Statistics: Posted by ultralord — Wed Sep 15, 2010 7:06 am