search

Releem / mysqlconfigurer

Releem is a simple MySQL tuning tool to improve database performance and reduce servers costs.
https://releem.com
GNU General Public License v3.0
254 stars 26 forks source link

issue while attempting to apply the recommended changes #226

Closed drupaladmin closed 5 months ago

drupaladmin commented 9 months ago

I had a weird issue today, while attempting to apply the recommended changes it threw and error, however, it seems like it applied the changes:

=== [root@rs9-nyc ~]# /bin/bash /opt/releem/mysqlconfigurer.sh -a

20231117-07:14:37 Applying the recommended MySQL configuration...

20231117-07:14:37 Copying file /opt/releem/conf/z_aiops_mysql.cnf to directory /etc/mysql/releem.conf.d/... Please confirm the MySQL service restart? (Y/N) y

20231117-07:14:39 Restarting MySQL with the command ' /usr/bin/systemctl restart mysql'...

Waiting for mysql service to start 120 seconds |

20231117-07:15:23 MySQL service failed to start in 120 seconds! Check the MySQL error log!

20231117-07:15:23 Try to roll back the configuration application using the command:

20231117-07:15:23 bash /opt/releem/mysqlconfigurer.sh -r

20231117-07:15:26 Sending a notification about the application of the config was completed successfully

Nothing related in the error log

drupaladmin commented 5 months ago

The root cause of that issue is long MySQL restart. We've fix that when you applying through the agent. Please use this command to apply bash /opt/releem/mysqlconfigurer.sh -s auto