Answer the question
In order to leave comments, you need to log in
Why can't optimize mysql?
Good day to all! Guys, something does not work out to optimize mysql. Yesterday I even contacted technical support, they were busy for several hours and it was useless, even the site began to work more slowly. Now the my.cnf configs are theirs and I know what I need, for example, to increase "max_connections to 70", I just left everything as it is to show you. But many configs that "phpmyadmin" advises to fix do not react in any way, you add or subtract, they still ask you to add or subtract to infinity. Before that, I optimized it a couple of times with the help of mysqltuner and the phpmyadmin adviser, but this time something didn’t work. Now mysqltuner asks to correct a couple of configs, but it still won't solve the problem. Okay, let's get down to business:
System 2 CPU/2 GB RAM/30 GB SSD. mysql Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2, PHP 7.0.33
my.cnf
phpmyadmin All Status Variables phpmyadmin
advisor Enabled logging slower a
few days ago...
Thanks!
Answer the question
In order to leave comments, you need to log in
Boy, it's not enough what you said.
Would you describe what kind of project you have, maybe you should change the server in principle?
But that's okay.
Be sure to study this section, if it comes to that!
https://ruhighload.com/mysql
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question