On 8/31/2012 3:14 PM, Martín Marqués wrote:
How can I get queries to get logged in mysqld? I tried adding these lines to /etc/my.cnf on tag [mysqld] with no luck (yes I restarted the daemon): long_query_time=0 general_log=1 general_log_file = /var/log/mysql.log Any ideas?
For mysql-5.5.27 on Fedora 17 I have: general-log = OFF slow_query_log = ON log_queries_not_using_indexes = OFF general_log_file = /var/log/mysqld/general.log log-error = /var/log/mysqld/error.log slow_query_log_file = /var/log/mysqld/slow_query.log I'm still trying to make sense of MySQL's use of dash vs underscore. You can turn the log file on/off from the command line with program mysql: mysql> set GLOBAL general_log=OFF; Bill -- users mailing list users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines Have a question? Ask away: http://ask.fedoraproject.org
