Slow Performance with Multi-threaded app

[Minesh Desai]

My application is a java 1.7, multi-threaded application with MySQL 5.6 as the backend.

Application reads data from files and writes it to corresponding tables in multithreaded fashion. The performance is great when all threads are inserting records on different tables, but the application or rather inserts slows down as soon as all the threads starts inserting into the same table.

Each thread has its own prepared statement in batch mode with commit interval of 100 records. "rewriteBatchedStatements=true" property is already added during establishing the connection.

MySQL Driver: com.mysql.jdbc.Driver
MySQL Storage engine: InnoDB

Any information / suggestions that can help improve performance will be highly appreciated.

Thanks...