Multithreading: mysql_ping() error.
Posted by: Alexandre Kalendarev
Date: April 02, 2013 07:40AM

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.

Options: ReplyQuote

Written By
Multithreading: mysql_ping() error.
April 02, 2013 07:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.