When bulk loading large volumes of data into MDM, you may encounter the
transaction and deadlock issues since too many threads on the server side are trying to
obtain database connections.
Procedure
-
Browse to the file
<$INSTALLDIR>/conf/mdm.conf and open it.
-
Configure the following two parameters according to your needs:
#To avoid connection pool and database overload, default value is 25
bulkload.concurrent.database.requests=30
#Control how many milliseconds to wait before retry, default value is 200
bulkload.concurrent.wait.milliseconds=300
In this example, we set the maximum number of concurrent database requests to
30 and the request retry wait time to
300 milliseconds.
-
Save your changes into the file.