topic Expedition Freezes due to mysql process goes to 100% in Expedition Discussions

Expedition Freezes due to mysql process goes to 100%

Gaurav.Singh — Fri, 22 Jan 2021 11:53:57 GMT

"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?"

Re: Expedition Freezes due to mysql process goes to 100%

azuniga — Fri, 22 Jan 2021 16:06:28 GMT

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.

Re: Expedition Freezes due to mysql process goes to 100%

Gaurav.Singh — Mon, 25 Jan 2021 04:32:06 GMT

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