Any of my actions to the database periodically hang for 4-5 seconds. For example, clicks in phpmyadmin on tables or editing data, external queries also lag: several queries are normal, but one of 5-10 queries will hang for several seconds. This was not observed on servers without hestia, what could be the reason?
Did you look at the usual mysql logs?
Also try https://github.com/haydenjames/mysqlmonitor-script it will give you a breakdown of whats going on.
Also there is this you can run which is a read-only script GitHub - BMDan/tuning-primer.sh: MySQL Tuning-Primer.sh, updated and improved
I’ve had incredible amount of performance improvement after following recommendations given I had 20GB unused memory on my box.
1 Like