Multithreaded programming with libmysql

Question

I'm using libmysql in a simple multithreaded app which will run on a uni-core embedded system processor. I read here that the client library is almost thread-safe.

Do I need to serialise my app (say, with a mutex)?

you should really read the page you linked. it has all the info. — Vinicius Kamakura
– Vinicius Kamakura, Commented Nov 14, 2014 at 18:36

jweyrich · Accepted Answer · 2014-11-14 18:48:56Z

3

Depends on what you're doing. In a simple scenario you'd just link against libmysqlclient_r and make sure you don't share a connection with multiple threads nor execute multiple queries "simultaneously" on a single connection.

Other requirements:

Before creating any threads, call mysql_library_init() to initialise the MySQL library;
On each thread call mysql_thread_init() to initialise thread-specific variables before using any MySQL related functions;
Before destroying a thread, call mysql_thread_end().

If your program is respecting these limitations, MySQL is your friend.

edited Nov 14, 2014 at 18:48

answered Nov 14, 2014 at 18:40

jweyrich

32.5k5 gold badges70 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multithreaded programming with libmysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related