I want to enable slow query logging in MySQL Galera.
In order to do so, I have enabled it through
log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 1 log-queries-not-using-indexes
Then, I tried to restart one server
sudo services mysql restart
The galera node fails to restart and writes to error.log:
mysqld_safe WSREP: Failed to recover position: 2015-08-29 12:07:37 27805 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2015-08-29 12:07:37 27805 [Note] Plugin 'FEDERATED' is disabled. 2015-08-29 12:07:37 27805 [ERROR] Function 'innodb' already exists 2015-08-29 12:07:37 27805 ...
Once I remove the query logging from
my.cnf, the server starts just fine and joins the cluster OK.
Is there a special procedure in enabling the query log in Galera? If so, how to do it?