If you have multiple threads accessing the same connection remember to make sure that only one thread enters mysql_query() mysql_connect() or mysql_store_result() after you store the result another thread will be able to use that connection without problems.
-Eric On Wed, 30 Jun 2004 11:01:35 +0000, darren <[EMAIL PROTECTED]> wrote: > > Hi all, > > I am writing a multi-threaded client that requires shared access to a single MySQL > connection. The environment is Redhat 7.3 with the patched > mysql-3.23.58-2.71.i386.rpm installed and compiled with -l libmysqlclient_r. > > The connection is made from the main thread and a MYSQL_RES* myres declared from the > child thread is used to fetch results back to the thread. I get a Segmentation fault > the first instance my child thread (only one) accesses MYSQL_RES through > mysql_num_rows(myres). (gdb informed me that this is due to mysql_num_rows from > libmysqlclient_r.so.10) > > I have read a few docs about writing MySQL multi-threaded clients and have called > my_init() in my main prog and my_thread_init() at the first line of my thread > handler. > > Any ideas? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]