Optimizing MySQL on Dedicated Servers for WordPress: Resolving Backend Performan

  • Resolved raha1988ab

    (@raha1988ab)


    1 month, 2 weeks ago

    We are currently managing our dashboard with 999 orders, and it’s critical for us because we handle approximately 500-600 new orders daily. It’s essential to have smooth access to a large number of these orders. However, we’re experiencing backend performance degradation, which is impacting our operations.

    To monitor our system performance, we are using the New Relic agent/API, and we’ve noticed a significant number of connections to the MySQL server.

    Is there any possibility of optimizing the MySQL database on our server?

    Our infrastructure includes a dedicated/co-located HPE G10 server equipped with 256 GB of RAM, dual Intel Xeon CPUs, and HPE NVMe2 SSDs configured in RAID 0/1 for performance and redundancy.

    Thank you.

    Admin, please remove this line, but tell me why every post I published show me this warning?

    Your post is being held for moderation by our automated system and will be manually reviewed by a volunteer as soon as possible.

    No action is needed on your part at this time, and you do not need to resubmit your message.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello raha1988ab,

    Thank you for contacting WooCommerce support.

    Thank you for the detailed information about your situation. Managing such a large volume of daily orders can put pressure on the backend, and it’s great to hear that you’re already monitoring performance with New Relic.

    If you can provide specific data or slow queries that New Relic has flagged, along with relevant screenshots, I’d be happy to take a closer look and offer more targeted advice.

    Looking forward to your reply!

    Thread Starter raha1988ab

    (@raha1988ab)

    Hello @doublezed2

    I’m not fully familiar with newrelic but I have install that in our server

    would you please guide me on where I should look and give you screenshot ?

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    I’d be happy to guide you through finding the relevant information in New Relic. Here is the article to guide you on how to check the health issue and potential error.
    https://docs.newrelic.com/docs/apm/apm-ui-pages/monitoring/view-your-applications-index/

    Alternatively I would suggest you contact the New Relic support and asked them to help you to find specific data or slow queries that New Relic has flagged, along with relevant screenshots.

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.