Tag Info

New answers tagged

1

[mysqld] # Set Slow Query Log long_query_time = 1 slow_query_log = 1 slow_query_log_file = /usr/log/slowquery.log log_queries_not_using_indexes = 1 #Set General Log general_log = on general_log_file=/usr/log/general.log Note that enabling general_log on a production server has overhead you should avoid it. You can check problematic queries from slow log.


2

If you use these two lines in my.cnf, I find that it works fine. This will log all queries to the server, from any source, not just PHP/PHPMyAdmin. Paul... [mysqld] general_log = on general_log_file=/users/ugrad/linehanp/mydb/logfile.txt



Top 50 recent answers are included