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.
- 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=300In 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.