From: Sven U. <utc...@in...> - 2009-11-09 14:08:57
|
Hello Miklos, > On Fri, 19 Dec 2008, Sven Utcke wrote: > > what is the recommended way to make queries to MySQL (from FUSE, of > > course) in a thread-save way? Preferably I would like to call > > mysql_init() and mysql_real_connect() exactly once for each thread and > > then use the same thread-local MYSQL *mysql throughout all functions > > in that thread. But, alas, I have no clue how to achieve that, so > > that at the moment each function opens and closes it's own connection, > > which is quite some overhead... > > You can store the mysql pointer in a thread-specific data. See the > manual page for following functions: > > pthread_key_create() > pthread_key_destroy() > pthread_setspecific() > pthread_getspecific() I would like to call mysql_close() on thread-termination --- how would I do that? Alternatively: anybody knows what happens if I do not call mysql_close? Would mysql keep the connection open indefinitely? Sven -- _ ___ ___ ___ __| |/ __|| __|/ __| The dCache File System / _` | (__ | _| \__ \ An archive file-system for PB of data \__,_|\___||_| |___/ http://www.desy.de/~utcke/Data/ |