Today, after restarting the server (heavy load on databases) I had a surprise. MySQL server did not start. I was looking for a solution and I couldn't find it. I found that you have to try, you can't go wrong.
2020-05-05 16:52:15 3570 [Note] Plugin 'FEDERATED' is disabled.
Unknown suffix '.' used for variable 'innodb-log-buffer-size' (value '0.25M')
2020-05-05 16:52:15 3570 [Warning] option 'innodb-log-buffer-size': signed value 0 adjusted to 262144
2020-05-05 16:52:15 3570 [ERROR] /www/server/mysql/bin/mysqld: Error while setting value '0.25M' to 'innodb-log-buffer-size'
2020-05-05 16:52:15 3570 [ERROR] Parsing options for plugin 'InnoDB' failed.
2020-05-05 16:52:15 3570 [ERROR] /www/server/mysql/bin/mysqld: unknown variable 'innodb_data_home_dir=/www/server/data'
2020-05-05 16:52:15 3570 [ERROR] Aborting
The solution is very simple. After logging in to aaPanel, we open the MySQL module, go to configuration, look for the item "innodb-log-buffer-size" and change from 0.25M to e.g. 4M. MySQL restart and everything works. This entry is intended to help users solve the problem.
