Re: [fuse-devel] Thread-save MySQL queries from FUSE

[Sven U. <utc...@in...>]

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/