Page 1 of 1
Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 4:52 pm
by ybswya
Recently, no changes have been made to the website, and there were no issues before.
However, I've noticed that when opening new web pages, the CPU usage spikes to 100%, while the memory remains normal at 34% without any changes. Upon checking, it was found that MYSQL is occupying 73% of the CPU usage.
The server has 10 cores and 20G of memory, which should be more than sufficient for the current website usage.
Any urgent help would be HIGHY appreciated!
OC 3.0.3.8
PHP 7.4 + MYSQL 8.0.24 + APACHE2.4
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 4:56 pm
by paulfeakins
Feel free to drop us an email for a quick estimate:
info@antropy.co.uk
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 5:21 pm
by alanjones
Hello there
Greetings!!!
I've reviewed your requirements and I'm ready to assist you. If you'd like to discuss this further, please don't hesitate to reach out to me using the contact information provided below.
E- alanjones(dot)tis(at)gmail(dot)com
Skype - live:.cid.6a62b7b34d1aa390
Looking forward to hearing from you
Regards
Alan Jones
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 8:00 pm
by ianradnor089
Hello @ybswya,
Greetings!
I have reviewed your requirements and would be delighted to assist you with this work.
Please feel free to contact me with your contact details to discuss this further.
Email: ianradnor088(at)gmail(dot)com
Skype: live:ianradnor088
Looking forward to hearing from you.
Regards
Ian
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 8:09 pm
by SohBH
Hi, default theme or Journal 3 theme?
Journal 3 theme is resource-intensive, it is running out of resources.
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 8:32 pm
by ybswya
SohBH wrote: ↑Fri Dec 01, 2023 8:09 pm
Hi, default theme or Journal 3 theme?
Journal 3 theme is resource-intensive, it is running out of resources.
Yes, how should I fix this problem?
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 8:37 pm
by SohBH
Get a suitable theme without page builder, or build a custom one based on default theme.
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 8:49 pm
by SohBH
Journal 3 extensively alters the structure of Opencart, it is best to backup database before making changes. We provide Opencart services to customize any theme (excluding those with page builders) based on your preferences.
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 8:54 pm
by JackSm
Hello,
Greetings!
I've reviewed your requirements and I'm prepared to assist you.
Feel free to reach out:
Email: jack(at)technogiq(dot)com
Skype: live:.cid.a0f06a69cf1c6478
Looking forward to hearing from you.
Regards,
Jack Smith
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Dec 01, 2023 10:14 pm
by JAY6390
The first thing to do would be to restart the server and see if that makes any difference. After that, I'd check your access logs and see if theres any spidering or IP addresses constantly accessing pages. Quite often these issues arise from content spiders trying to scrape all of your website.
I highly doubt it's Journal based on your specs to be honest, as you have got plenty of RAM
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Sat Dec 02, 2023 1:30 am
by JNeuhoff
Could have been caused by a DoS attack, check your server's raw access log. See also
this forum thread.
The Journal3 framework will indeed make your website several times slower than the OpenCart framework, because it's of poor quality, but as others have pointed out in this case it's not the main cause for your MySQL load issue.
Re: Urgent help : MYSQL is using over 70% of the CPU, causing many web pages to be unable to open.
Posted: Fri Jan 19, 2024 12:42 am
by mwhorse46
Hi, there!
Greetings!
I think the problem is related to extensions(plugin) or used theme's inefficient coding so we have to consider about project for optimizing.
Hope we will work together.
When we work together, I can handle your problem within good time.
Best regards.
email is
needmefordev@gmail.com
skype is live:.cid.d7b95ce01f4a9c66