Any one have any recommendations on a reliable review and optimization of my server. I know the basics but I am looking for someone experienced to optimize my server based on my particular use case. The problem is, in the past I have paid people for a few hours of work and they didn't really do anything besides basic config stuff I already know how to do and the optimizations didn't really make any difference in the speed and load management of my server.
Is this type of thing best to look for on Upwork or Freelancer or is it really better to just take the extra time myself to dig in and try to spend the time myself. I am a Linux admin but I am trying to get out of the part of the management where I have to do all the work so I can focus more on the clients and getting new business so I don't really want to spend 10-15 hours digging around internet and following all different recommendations. I went through that all about 5 years ago and there were so many different recommendations. One person would say "Do yada yada yada" Then a different person would say "That only helps with page speed, not with load on server" etc.
I have a dedicate server that has two ecommerce sites using Woocommerce. I am wanting to optimize the server for one of the sites that has much higher level of traffic. I use litespeed with mysql and my main problem in the past has been when I start to get a lot of concurrent users during sales it really starts to drag. I know you can't make Woo handle thousands of concurrent users if you don't have the proper resources so I am just looking to be able to max out my concurrent users with what I have (Ryzen 9 9950X, 128GB Ram). I am using php 8.2 and upgrading to the HPOS filesystem to try to help speed up Woo.
So what do you guys think? Look for a stack developer on Upwork or Freelancer, look here, or just dig in and try to tweak it as I go?
Thanks
Short answer: With your specs (Ryzen 9 9950X, 128GB RAM), hardware isn't your problem. It's 100% configuration and architecture. But hiring randomly on Upwork will likely waste your time again.
The real issues to investigate:
Database bottleneck - WooCommerce generates brutal queries. You need:
MySQL slow query log analysis
Proper indexing on wp_postmeta and order tables
InnoDB buffer pool sizing (should be ~70-80GB with your RAM)
Object caching - Redis or Memcached for persistent object cache (NOT page cache). This is critical for concurrent users.
PHP-FPM tuning - Calculate proper pm.max_children based on your actual memory. Most "experts" just copy-paste values.
Session handling - WooCommerce sessions kill performance. Consider custom session handlers or database cleanup.
Connection pooling - ProxySQL between PHP and MySQL can help massively.
My recommendation:
Don't hire generic server admins
Find someone who specifically does WooCommerce performance profiling (not just "optimization")
Or spend 3-4 focused hours with New Relic/Blackfire.io to identify the actual bottleneck first
HPOS is good, but won't fix concurrent user issues if your database queries aren't optimized
You have enterprise-level hardware. The problem is almost certainly unoptimized database queries under load.