Completed

Mysql CPU over 300%, due to Magento Indexer

Hello,

Please bid only if you know what it might be the reason for this problem. Indexing catalog_category_product can take up to 3 hours, having only 11.000 Products. This process causes mysql to consume a lot of CPU.

Configurable products when added to a category can make that category not to been accessible anymore and the reindexing is not completing the task.

Enviroment:

Nginx

Redis

Magento 2.3.3

Dedicated server.

Thank you,

Skills: Magento, Linux, MySQL, Nginx, PHP

See more: mysql cpu usage, mysql cpu usage tuning, optimizing mysql cpu usage, mysql cpu system, php mysql cpu usage, mysql cpu performance, mysql cpu using, mysql cpu, linux mysql cpu, 200 mysql cpu load, mysql cpu usage quad, tune mysql cpu usage, debian mysql cpu usage, reduce mysql cpu load, troubleshoot mysql cpu usage, magento tiered pricing across configurable products

About the Employer:
( 18 reviews ) Tecuci, Romania

Project ID: #22129040

Awarded to:

bMagento

Hello, I am a magento developer. I will do this for you. You will pay me after your work completed, No any payment required first. Thanks, Bhavin

$50 USD in 1 day
(22 Reviews)
3.6

11 freelancers are bidding on average $91 for this job

hawkscodes

Hi, I can start right now. I understood the issue and will fix it. I have +8 years of experience in Magento and also have +5 years of experience as a Linux Administrator. Please share the Root Access. Regards Veda More

$50 USD in 1 day
(96 Reviews)
6.0
shivam31

Dear Sir, Hope you are doing well. I understood your requirement about CPU consuming full capacity in your magento store. I have rich experience in Magento, PHP, Website design, CSS, Javascript, etc. I can start the w More

$50 USD in 1 day
(118 Reviews)
5.8
ubedarab

Hi, can I help you ? I am Magento developer & designer since 2009, I will do fix it. can we discuss about your requirement ? waiting for your reply. bye.

$100 USD in 1 day
(62 Reviews)
5.6
rishuwork17

I can fix magento CPU issue,I am AWS and google cloud certified server and Linux expert having  5 years of experience on migration of website . I have good hands on command line and Cpanel, DNS related queries, I have More

$40 USD in 1 day
(60 Reviews)
4.9
magesuperltd

Hello, Do you have flat catalog/products enabled? And is the DB on the same server? I have over 7 years of experience in eCommerce Development and over 6 years in Magento. Looking forward to hearing from you. Since More

$50 USD in 1 day
(36 Reviews)
5.0
websiteappdev

Hello, I have 10 years of experience in PHP, Wordpress, Codeigniter, Laravel, Python, Django, JavaScript, Shopify, Magento, OpenCart, Angular.JS, HTML, CSS. Please have a glance here on my previous work. [login to view URL] More

$40 USD in 7 days
(3 Reviews)
2.6
Honestypays1216

Hello. I will help you to complete this project. You can check my profile and notice that I am skillful enough for this project. Wish further discussion via chat. Thanks.

$500 USD in 1 day
(0 Reviews)
0.0
f7mike

Hello, Dear client. I am a experienced Database manager with 10+ years experience. I have managed and optimized several websites database and speed up server. I have ever been worked with huge database with over 1TB si More

$30 USD in 2 days
(0 Reviews)
0.0
anviverma111

HI I am experienced in PHP Linux Magento etc I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your reply

$40 USD in 7 days
(0 Reviews)
0.0
apovalyaev

What is your main task? Restrict CPU usage? I had BSc and MSc degree in Applied Mathematics and Informatics (gpa 4.8). Also undertaken postgraduate studies in Information and Navigation Systems (PhD candidate). I had More

$50 USD in 7 days
(0 Reviews)
0.0