MySQL Forums
Forum List  »  Newbie

Parallel writes to database
Posted by: Mohamad Bairakdar
Date: June 29, 2023 10:53AM

I'm having trouble running multiple processes that write to a database at once (same table but different records). I'm able to run one process and have my program write to the database, but when I try to run more processes, I can't connect to the database. In particular, I get:

OSError: [Errno 113] No route to host

I'm guessing this has to do with database locks, but I'm not experienced enough with this to know for sure.

Here is how I start the mysql server:
mysqld_safe --socket=mysql.sock --log-error=mysql.log --datadir=mysql_data --transaction-isolation=READ-COMMITTED &

I initially didn't have `--transaction-isolation=READ-COMMITTED`, but I added it because I thought it might help, but it didn't.

I was wondering if I can get some guidance on how to make this work.

Options: ReplyQuote

Written By
Parallel writes to database
June 29, 2023 10:53AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.