Multiple insert from different threads simultaneously without locking tables?

Question

I am facing issue with mysql table locks. I want to insert multiple records in a table from various threads . On this the first threads which starts inserting data into table acquires table locks and others threads has to wait for the first threads to finish. Which is an overhead for the applications. I want to solve this issue. I want to allow all the threads to insert bulk records at the same time into the same table . Is it possible in mysql , If yes , then how?? Please guide me.

Thanks,

Nitesh Kumar

http://stackoverflow.com/questions/4355046/java-insert-multiple-rows-into-mysql-with-preparedstatement — Bhavik Shah, Oct 18 '12 at 05:31

score 0 · Answer 1 · answered Oct 18 '12 at 04:51

0

it seems like your problem is about Isolation Level

Check the connection Isolation Level settings may be it can help

http://dev.mysql.com/doc/refman/5.1/en/dynindex-isolevel.html

answered Oct 18 '12 at 04:51

Ozgur

258
3
13

score 0 · Answer 2 · edited Jun 20 '20 at 09:12

0

MySQL allows INSERT DELAYED. The row is scheduled for insertion and the database call returns. Starting with 5.5.7, it even supports delaying multi-row inserts.

edited Jun 20 '20 at 09:12

Community

1
1

answered Oct 18 '12 at 04:55

John Dvorak

26,799
13
69
83

Multiple insert from different threads simultaneously without locking tables?

2 Answers2