Multithreading: mysql_ping() error.

[Alexandre Kalendarev]

I create connection pool with mysql option MYSQL_OPT_RECONNECT = 1 and use one uniq connection by one thread. But, my MySQL server is overload and I have error 2013: "Lost connection to MySQL server during query query" sometimes.

So, I use mysql_ping() before each query execution (mysql_query) and sometimes I have SIGSEG error.

Can I use mysql_ping() in the worker thread, if it use uniq connections ( the each thread use only one connection from connection pool)



Edited 1 time(s). Last edit at 04/04/2013 06:16AM by Alexandre Kalendarev.