How to enable MySQL Query Log?

by

First, Remember that this logfile can grow very large on a busy server.

For mysql < 5.1.29:

To enable the query log, put this in /etc/my.cnf in the [mysqld] section

log   = /path/to/query.log  #works for mysql < 5.1.29

Also, to enable it from MySQL console

SET general_log = 1;

See http://dev.mysql.com/doc/refman/5.1/en/query-log.html

For mysql 5.1.29+

With mysql 5.1.29+ , the log option is deprecated. To specify the logfile and enable logging, use this in my.cnf in the [mysqld] section:

general_log_file = /path/to/query.log
general_log      = 1

Alternately, to turn on logging from MySQL console (must also specify log file location somehow, or find the default location):

SET global general_log = 1;

Also note that there are additional options to log only slow queries, or those which do not use indexes.

More Related Contents:

  1. How to show the last queries executed on MySQL?
  2. Log all queries in mysql
  3. How to see log files in MySQL?
  4. MySQL/Writing file error (Errcode 28)
  5. CakePHP – get last query run
  6. left join query keep a column empty
  7. How to do a regular expression replace in MySQL?
  8. Rank function in MySQL
  9. Count the number of occurrences of a string in a VARCHAR field?
  10. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  11. mysql Foreign key constraint is incorrectly formed error
  12. Unknown Column In Where Clause
  13. MySQL match() against() – order by relevance and column?
  14. MySQL query String contains
  15. Entity-Attribute-Value Table Design
  16. Mysql localhost != 127.0.0.1?
  17. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  18. Capitalize first letter. MySQL
  19. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  20. MySQL remote connection fails with “unknown authentication method”
  21. SQL Group By with an Order By
  22. Import MySQL database into a SQL Server
  23. How does MySQL’s ORDER BY RAND() work?
  24. How create json format with group-concat mysql?
  25. Get Insert Statement for existing row in MySQL
  26. DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
  27. Can’t access mysql from command line on a Mac
  28. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  29. How to escape apostrophe (a single quote) in MySql?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment