New answers tagged log
Also needed: log_output = 'FILE' Meanwhile, you have possibly thrown lots of stuff into the table mysql.general_log. Do SELECT * FROM mysql.general_log LIMIT 11;
You may use the mcaffee audit plugin https://github.com/mcafee/mysql-audit/wiki/Installation there you can filter hosts in logging. You could also refuse all hosts specifying a mysql User with an appropriate Host. ('user'@'allowedHostIpRange').
ELK Stack is a good choice, even though i use elastic search + gray log for logging purposes. Experience with elastic search, several hundreds of GB are not an issue, u can in any case, easily increase capacity adding new nodes to it. Graylag has an API which you could use in any other app
I faced the similar issue some days ago, few suggestions. Check the output of the following command: show variables like '%general%'; If the output listing general log file and still it is not logging queries, modify the following parameters. general_log = ON general_log_file = /var/log/mysql/mysql.log Still if it is not working, check ...
Top 50 recent answers are included