Sinisa,
SM> > These are daemon programs ... not exiting. I've about 10 programs
SM> > initialising a connection and then looping, doing some updates on
SM> > table while receiving data from another input.
SM> >
SM> > The schema is :
SM> >
SM> > 1. Connecting to Mysql
SM> > 2. reading data (from a file for example)
SM> > 3. updating Mysql table
SM> > 4. if any error, do a mysql_ping() in order to re-connect if
SM> > disconnected
SM> > 5. loop to 2.
SM> >
SM> > SM> Also, please try our 2.7 binary, just to rule out build problmes.
SM> >
SM> > I will try now.
SM> >
SM> > Alex.
SM> >
SM> >
SM> >
SM> Well, the above provides some more light !
SM> Increase wait timeout to some HUGE value. Same for net_read_timeout
SM> and net_write_timeout.
SM> Also, if signal 14 happens again check if the corresponding daemon is
SM> still running.
If I had a thread on my daemons which executes a mysql_ping() each
30 secondes and increase net_read_timeout to 60 will it be ok ? Does
a mysql_ping() reset net_read and net_write timer ?
Alex.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
