Mysql CPU over 300%, due to Magento Indexer


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.




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:
( 25 reviews ) Tecuci, Romania

Project ID: #22129040

Awarded to:


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
(23 Reviews)

10 freelancers are bidding on average $50 for this job


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
(122 Reviews)

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
(103 Reviews)

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
(65 Reviews)

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
(77 Reviews)

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
(48 Reviews)

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
(6 Reviews)

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
(2 Reviews)

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)

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)