Magento 1.9 MySQL High CPU Optimization

Job ID: 38614271

Budget: $30 – $100 USD

My Magento 1.9 store is experiencing high CPU load during specific operations: when an order is placed on the frontend, and when shipment tracking details and invoices are submitted on the backend. All these actions seem to be causing the issue, but the CPU load primarily spikes during the order process on the frontend and backend.

- There are 1,25,000 Orders on the store
- The actions or extensions involved when an order is placed on the frontend are all Magento default ones.
- There have been no recent changes or updates to my Magento setup.

I need a Magento expert with strong MySQL optimization skills to identify the root cause of this issue and implement a solution to alleviate the CPU load. Experience with Magento 1.9 is essential.
Related categories: PHP Linux Magento eCommerce MySQL