Have you trace “big queries”? Or complex queries? Have you
got explanation of what query do for you?
Are you sure that your db has all indexes for fast access data?
Have you analyzed your db tables at all? Or queries?
Have you checked that your db has all indexes? Maybe there are some stupid plugins who do extremely big & complex queries in infinite loop and lock your db? Who knows?
For example I know that plugin called Ultimate Membership - bugged for many many years, provoke dramatical load on db, and nobody care to add proper indexes to dbs, or fixes for that.
Do you see how many things i just started to point before ever touching your config files?
That the key.
In short, you need not touching default config in hestiaCP which is great.
But instead to install trace/debug software to understand what is going on.
And measure the time for queries, for load, what is going on, response times, and so on.
All tools for that above mentioned.
Also, are you sure that your db not broken? Repaired? Or optimized?
This is just example.
Done all of that, and nothing helped?
Who said that your server is good?
What about testing your hardware first?
How to understand that your server is okay?
Single Core performance must be > 600, ideally more than 1k
IOPS > 1k, ideally more - better for small chunks of data
Nothing else does not really matter.
Does not help?
What version of software do you use?
Do you know that perfromance difference between php versions between 8.0 and 8.1 and 8.2 different?
Are you using latest version? Opcache enabled?
How about caching? Lets talk about caching thing for your queries.
If your mysql answers is slow, and you done all things above.
What about adding a Redis to your server & redis plugin for your WP?
Redis will be like a layer between your app & mysql and will cache popular queries and give them instantly pre-made answers from memory. Which dramatically boosts performance.
Have you tried all of that?
Your changes in config file above - is VERY bad.
These changes will increase loading, and will add more problems to your VPS & projects. Do not do that.
The time when you need to tune default settings in mysql - it’s when you tried all above, and you know for sure that after changes and your analysis - your server got faster.
You increased caches, but you do not understand how it works. In result when there will be a lot of cache - your db will dramatically slow, because will read data from swap. because of luck of memory & big loops of searching operations due to big cache sizes.
DO NOT DO THAT.
HestiaCP default configs = great.
Try to first understand what is the reason that slow down your website.
This is okay results for 10+ yearso ld hardware to have 600 bench for CPU.
But modern CPU can in single thread do 1500 benches.
At least something.
About 300 points in previous bench - this is not really bad, this is ALARM, ALERT to run away from such provider. This is big sign of extremal level of oversharing CPU among clients on the same node near to you.
Also, optionally it can be because someone on the your node abused CPU too much, and support not really care about that until you report to them.
Your current 600 points ± okay for that CPU. So probably it’s ok for now.
But if after some time you will notice performance degradation - just run away from the provider anywhere else. To any other provider, not a big one, but some small/medium sized provider.
Ideally on ryzen-like CPU, or modern intel cpus.
And you will notice very big performance jump.
One of the VPS providers we’ve used for years is Racknerd and have never had an issue with them.
They have dozens of locations so you may want to reach out to their support team and notify them of the issue you’re having and/or request they move you to another machine or another location that may not experience the issues you’re describing.
Please note that geekbench values varies on a KVM VPS since it runs over a hypervisor and as a guest machine. If you want the exact geekbench values, it should be a dedicated server with dedicated hardware resources.
just move away from this shit provider. Really.
Do not try to argue. They’re cheap because they’re oversell.
Imagine you have real hardware PC for example 8 cores and 32GB ram.
Now imagine that you make 8 VPS, and allocate each of your CPU core to each VPS.
You got total 8 VPS.
And performance awesome or best possible.
How usually VPS providers do:
They allocate to 1 CPU core around 4-6 clients.
Because 4-6 clients at the same time usually most of the time not running CPU intensive tasks. But if all clients at the same time will do that, it will affect everyone. But chance that this will happen if allocated for example 5 clients per CPU core = pretty low.
But imagine that you allocate not 5, but for example 15 clients on the same CPU core with fixed 3.2Ghz for example?
What about 30 clients?
How about 50?
Or even 70?
How fast will apps running on the same real PC insiode 560 virtualboxes running at the same time on 8 cpu cores only? I think you got idea.
They doing the same.
Just avoid them.
Purchase adequate VPS in adequate price range like 5-7-10 usd / mo and pay for that.
When you paying like annually payment below 20 usd for 1GB / year = something for sure not okay with the VPS.
Because IP price ~15 usd / year sometimes for some providers.
5 usd for resources left that need to rent/puchase/delvier allocate to you from your $20 per year? Really?
nah. Something for sure wrong
Guys above already mentioned good providers like hetzner, ovh.
There are also linode, vultr, extravm, lunanode, alphaVPS
You’re forced to pay minimum 5-10 usd / mo for VPS with decent performance.
Or you will face trash that racknerd offer to you for cheaper price.
Its up to you.
141 bench - awful. This is not shit, this is below shit.
If i was on your position - i will for sure say some kind words to this provider, and do refund (depends on price for vps).
Because this is not a performance at all. This is totally crap shit.
Sorry for cursing.
I am trying to balance between the cost and the performance because I am not running a business or making a profit from my website. However, I have found very good deals on hetzner for a huge boost in performance.
I argued with them and they asked for the SSH details to look as a “courtesy”. Then after few minutes I received an email from them “Emergency Power Maintenance”.
Additional Information: We have identified a failing PDU, which can cause power stability issues in production. Therefore, on-site technicians will be replacing the rackmountable PDU that these 3 servers are connected to.
Due to the nature of the issue causing symptoms that could be negatively impactful to production, we will be proceeding with this emergency maintenance as soon as possible (at any point within the next two hours of this e-mail).
When I asked the support if this is related to my issue they replied
That may have been related since the servers were earlier receiving an unstable power connection. The maintenance has now been completed. How do things look now on your end?
After the maintenance the performance have improved but it is less than what I had on 17.03.2023
I will keep eye on hetzner auction for a good deal