Expedition Freezes due to mysql process goes to 100%

Announcements

Changes to the LIVEcommunity experience are coming soon... Here's what you need to know.

Reply
Gaurav.Singh
L1 Bithead

Expedition Freezes due to mysql process goes to 100%

"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
L4 Transporter

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
L1 Bithead

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

Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!