What is the best combination of MySQL DB and Python 3 multiprocessing?

Question

MySQL

I am currently using pymysql. Everything was fine until the moment when it became necessary to parallelize the load.
when using multiprocessing.Poll() the script started to hang.
The only thing that could cause this behavior is using pymysql in subprocesses.
I have one connection to the database, global.
Advise how best to proceed: Use a different connector to the database (which one?) Or create a new connection to the database each time (which, as I understand it, will worsen performance)? Requests are expected up to 5 per second. In the future, I think max up to 10. I
tried to use multiprocessing.Lock () in subprocesses, but this did not give any result.
I understand that this is a bug in pymysql? I would even report it, but I'm not sure if this is not the expected behavior .. maybe I'm doing something wrong?)

Answer 1

are you using exec() or multiexec() ?