Hello, I have been looking into some Access Violations I am getting with a
client app accessing a MySQL database on an NT 4.0 box. I have read the
article “24.1.5 How to make a Thread – Safe Client” but I am still some what
confused. Is there a limit to the number of threads one database connection
can handle. I have an app that uses the mysql_real_connect function to
create a connection and I have several threads that can use this single
connection to read several tables and write to a single log table. It would
appear that I have to use a mutex for every SQL Statement executed even if
the statement only issues a read query. The article states that one must
recompile the client library with a directive to achieve a thread safe
client. My question is wouldn’t this be done by default, and if not will
this fix my issue?
