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