How to smoothly "restart" mysql

How to smoothly "restart" mysql note that the restart in the title is a mysql server in the production environment with quotation marks. Generally, it is necessary to avoid restarting as much as possible, but it is time-consuming to face the slow log of mysql in this scenario. The error log needs to be periodically cut out. Some parameters that affect performance need to be fine-tuned. We hope mysql can smoothly load new configurations without interrupting the service. In fact, you only need to send a-HUP signal to the mysqld process. After mysqld receives this signal, it will regenerate the log or use service mysqld reload, and some other parameters can be fine-tuned. It is recommended that you set it in the mysql CLI mode using the set global NAME = Value method, save it to/etc/my. cnf configuration file