 |  |
SCENARIO: I have run in to the issue where I wanted to change some configuration on our production MySQL server but did not want to restart MySQL since its in production.
One of the parameters we like to change time to time is the “log_slow_queries” so we can see what queries are slow in production environment. But obviously we don’t want to restart mysql server so we start up mysql client and type:
Once you are done checking for slow queries, you can reset it back to whatever value you want by repeating the command with higher number (default is 10).
There are many more variables you can change. Type:
show variables
in the mysql client to see the list and what all those variables are set to.
SOURCE | LINK (Crazytoon.com) | LANGUAGE | ENGLISH |