New related comments
Number of comments in the last 48 hours
Monitoring mysql status
Location of mysql startup script
Best operating system settings for mysql throughput
How to log all mysql database modifications
This article has not been rated yet. After reading, feel free to leave comments and rate it.
Question:How can we log changes done to our mysql production database? People here use the mysql shell as their client.
Answer:You can specify tee=/var/logs/mysql_cli.log in the mysql shell config file (my.cnf) and it will log all CLI session content (input and output) to this file.
Considering that these CLI modifications can be very powerful, you really should log them.
This does not help if some users use a web front end e.g. phpmyadmin.