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] log-error=/var/log/mysql/mysql-error.log slow-query-log=/var/log/mysql-slow.log long-query-time=1 save the above file and restart mysql


How to configure Mysql & which file we have to change

Question:- How to configure Mysql & which file we have to change Answer:-   Downlaod binary files from http://www.mysql.com Copy the folder to /usr/local/ path Copy the my-huge.cnf file from support … Continue Reading →