High CPU Usage (mysql)

[nusquare]

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.

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!

[nusquare]

[Nishu Jindal]

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!

[JLHC]

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. 

[nusquare]

---

@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.

[nusquare]

---

@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:

[JLHC]

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? 

[nusquare]

---

@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.

[JLHC]

---

@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.