If I were to enable MySQL logging by doing the following, what are the advantages and disadvantages? What do you do personally?
general_log_file = /var/log/mysql/mysql.log general_log = 1 log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 2 log-queries-not-using-indexes
On one hand it is good for security. However, I've heard that it slows down MySQL a lot and has performance impacts. It also causes a lot of disk IO which further slows the server down.