The client library is almost thread-safe. The biggest problem is
that the subroutines in
net.c that read
from sockets are not interrupt safe. This was done with the
thought that you might want to have your own alarm that can
break a long read to a server. If you install interrupt handlers
SIGPIPE interrupt, the socket
handling should be thread-safe.
New in 4.0.16: To not abort the program when a connection
terminates, MySQL blocks
SIGPIPE on the first
mysql_connect(). If you want to have your own
SIGPIPE handler, you should first call
mysql_server_init() and then install your
handler. In older versions of MySQL
was blocked, but only in the thread safe client library, for
every call to
In the older binaries we distribute on our Web site (http://www.mysql.com/), the client libraries are not normally compiled with the thread-safe option (the Windows binaries are by default compiled to be thread-safe). Newer binary distributions should have both a normal and a thread-safe client library.
To get a threaded client where you can interrupt the client from
other threads and set timeouts when talking with the MySQL
server, you should use the
libraries and the
net_serv.o code that the
If you don't need interrupts or timeouts, you can just compile a
thread-safe client library
and use this. See Sección 24.2, “La API C de MySQL”. In this case, you don't
have to worry about the
file or the other MySQL libraries.
When using a threaded client and you want to use timeouts and
interrupts, you can make great use of the routines in the
thr_alarm.c file. If you are using routines
mysys library, the only thing you
must remember is to call
my_init() first! See
Sección 24.2.11, “Descripción de funciones de la API C para el control de subprocesos”.
All functions except
by default thread-safe. The following notes describe how to
compile a thread-safe client library and use it in a thread-safe
manner. (The notes below for
mysql_real_connect() actually apply to
mysql_connect() as well, but because
mysql_connect() is deprecated, you should be
mysql_real_connect() thread-safe, you
must recompile the client library with this command:
shell> ./configure --enable-thread-safe-client
This creates a thread-safe client library
libmysqlclient_r. (Assuming that your OS has
This library is thread-safe per connection. You can let two
threads share the same connection with the following caveats:
Two threads can't send a query to the MySQL server at the
same time on the same connection. In particular, you have to
ensure that between a
mysql_store_result() no other thread is
using the same connection.
Many threads can access different result sets that are
If you use
mysql_use_result, you have to
ensure that no other thread is using the same connection
until the result set is closed. However, it really is best
for threaded clients that share the same connection to use
If you want to use multiple threads on the same connection,
you must have a mutex lock around your
mysql_store_result() call combination.
mysql_store_result() is ready, the
lock can be released and other threads may query the same
If you program with POSIX threads, you can use
pthread_mutex_unlock() to establish and
release a mutex lock.
You need to know the following if you have a thread that is calling MySQL functions which did not create the connection to the MySQL database:
When you call
mysql_connect(), MySQL creates a
thread-specific variable for the thread that is used by the
debug library (among other things).
If you call a MySQL function, before the thread has called
mysql_connect(), the thread does not have the
necessary thread-specific variables in place and you are likely
to end up with a core dump sooner or later.
The get things to work smoothly you have to do the following:
my_init() at the start of your
program if it calls any other MySQL function before calling
mysql_thread_init() in the thread
handler before calling any MySQL function.
In the thread, call
pthread_exit(). This frees
the memory used by MySQL thread-specific variables.
You may get some errors because of undefined symbols when
linking your client with
most cases this is because you haven't included the thread
libraries on the link/compile line.
Ésta es una traducción del manual de referencia de MySQL, que puede encontrarse en dev.mysql.com. El manual de referencia original de MySQL está escrito en inglés, y esta traducción no necesariamente está tan actualizada como la versión original. Para cualquier sugerencia sobre la traducción y para señalar errores de cualquier tipo, no dude en dirigirse a firstname.lastname@example.org.