Diagnose WooCommerce CPU Spikes

$500-3000 CAD

Open

Posted less than a minute ago

•

Ends in 23 hours

$500-3000 CAD

Paid on delivery

Our WooCommerce store (≈13 k products, live for five years) keeps maxing out CPU on a brand-new CloudLinux 9.6 box (8 GB RAM / 8 cores, MySQL 8). Even idle, MySQL alone burns ±3 cores and visitors frequently hit 508 resource-limit or “Error establishing database connection” messages. Everything obvious has already been tried—plugin and core updates, transient cleanup, product lookup table regeneration, session and scheduled-action purges, WP-Cron offloaded to system cron, table optimization and overhead removal, unused tables dropped. None of that moved the needle. I now suspect the bottleneck sits in our database layer and query patterns. Beyond cleaning out stale data I haven’t run indexing reviews, query rewrites, or any real profiling; the MySQL slow-query log is still untouched. I need a specialist who can • capture and analyze slow/expensive queries (slow-query log, EXPLAIN, Performance Schema, Query Monitor, or your preferred tools) • propose and apply the right fixes—index additions, query refactors, WooCommerce hook adjustments, or selective plugin hardening—without breaking storefront functionality • document each change and its effect, aiming to bring average CPU usage well below the current ceiling and eliminate the 508/db-connection errors Please outline your diagnostic approach, the tooling you’ll rely on, and similar WooCommerce/MySQL rescues you’ve handled. Once the load drops and stability is confirmed, we’ll wrap up with a short hand-off report so I can keep the site healthy going forward.

Database Administration

System Administration

WooCommerce

WordPress

Project ID: 39731852

About the project

1 proposal

Open for bidding

Remote project

Active 8 secs ago

Place your bid

Bid amount

CAD

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

1 freelancer is bidding on average $1,800 CAD for this job

@TappitWeb

Hi, This is very doable, I can get it working cleanly and reliably. I understand the critical nature of optimizing the database layer and query patterns for your WooCommerce store to eliminate CPU bottlenecks and database connection errors. I would start by thoroughly analyzing slow/expensive queries using tools like EXPLAIN and Performance Schema. I'd then propose and implement fixes such as index additions and query refactors while ensuring storefront functionality remains intact. My experience includes successfully handling similar WooCommerce/MySQL challenges and documenting changes for future maintenance. While I’m new to Freelancer, I’ve delivered solid results for clients in the same space. Let’s connect. I’d love to move forward with your project. Regards, Ernst

$1,800 CAD in 14 days