How to configure Mysql slow queries & error log

Question:- How to configure Mysql slow queries & error log

Answer:- edit my.cnf and following line under [mysqld]

  1. log-error=/var/log/mysql/mysql-error.log
  2. slow-query-log=/var/log/mysql-slow.log
  3. long-query-time=1
  4. save the above file and restart mysql

Comments are closed.