cancel
Showing results for 
Search instead for 
Did you mean: 

High CPU Usage (mysql)

Highlighted

High CPU Usage (mysql)

so my server over the past 48 hours has been pretty much running at the below CPU usage. clearly something with MySQL but i can't figure out whats the cause. yesterday the store wasn't accessible and we had to restart web services for the store to come back online. Capture.PNG

 

the high CPU usage stays at those levels for hours at the time and sometimes come down but shortly after it will start spiking up.

 

what information should i be providing here to help in assessing the issue and fixing it.

 

Thanks in advance!

 

 

8 REPLIES 8
Highlighted

Re: High CPU Usage (mysql)

Capture.PNG

Highlighted

Re: High CPU Usage (mysql)

Hi @nusquare 

 

Can you try below solutions mentioned in the post for the issue 

https://digitalstartup.co.uk/t/high-cpu-usage-caused-by-mysql-very-specific-issue/230

 

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

Highlighted

Re: High CPU Usage (mysql)

The first thing to do is to find out what MySQL processes are running which are eating up CPU. 

 

You can use the SHOW PROCESSLIST; MySQL command to find out what MySQL processes are running at the moment. 

Highlighted

Re: High CPU Usage (mysql)


@Nishu Jindal wrote:

Hi @nusquare 

 

Can you try below solutions mentioned in the post for the issue 

https://digitalstartup.co.uk/t/high-cpu-usage-caused-by-mysql-very-specific-issue/230

 

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!



Thanks for your reply, unfortunately I have changed the variables to match the new server settings and that didn't solve my problem.

Highlighted

Re: High CPU Usage (mysql)


@JLHC wrote:

The first thing to do is to find out what MySQL processes are running which are eating up CPU. 

 

You can use the SHOW PROCESSLIST; MySQL command to find out what MySQL processes are running at the moment. 


Please find the output below:

Capture.PNG

 

 

Highlighted

Re: High CPU Usage (mysql)

I Googled the keyword "INSERT INTO search_tmp" and I found:-

https://github.com/magento/magento2/issues/15545

https://magento.stackexchange.com/questions/227386/magento2-unknown-query-insert-into-search-tmp

 

Did you perform mass attribute values update recently? 

Highlighted

Re: High CPU Usage (mysql)


@JLHC wrote:

I Googled the keyword "INSERT INTO search_tmp" and I found:-

https://github.com/magento/magento2/issues/15545

https://magento.stackexchange.com/questions/227386/magento2-unknown-query-insert-into-search-tmp

 

Did you perform mass attribute values update recently? 


i did update some attribute of the products but that was a bit before the issue started.

Highlighted

Re: High CPU Usage (mysql)


@nusquare wrote:

@JLHC wrote:

I Googled the keyword "INSERT INTO search_tmp" and I found:-

https://github.com/magento/magento2/issues/15545

https://magento.stackexchange.com/questions/227386/magento2-unknown-query-insert-into-search-tmp

 

Did you perform mass attribute values update recently? 


i did update some attribute of the products but that was a bit before the issue started.


It looks like the processes are still running now based on what you provided. 

 

You may want to monitor that and see if they stop or continue to run.