Expedition Freezes due to mysql process goes to 100%

[Gaurav.Singh]

"Sometimes when we do a merge job, the mysqld process goes to 100% on a single core and Expedition freezes and throws an error, forcing us to reboot the server. Mysqld doesn't utilize any other cores, even though more cores are available. Is there a way to enable the process to load balance across multiple cores?"

[azuniga]

Hello @Gaurav.Singh 

This is a limitation in the way expedition is currently set up from the development side, I would suggest you expand your parser_max_execution_memory to roughly 80% of the memory you allocated to expedition itself.

You can find this under settings>Custom Params>Parser_max_execution_memory

This should help greatly during your merge or import functions.

[Gaurav.Singh]

Thank you @azuniga , I will try your suggestion. I will let you know in few days if that helped for my project.