How can I enable MySQL’s slow query log without restarting MySQL?

by

Try SET GLOBAL slow_query_log = 'ON'; and perhaps FLUSH LOGS;

This assumes you are using MySQL 5.1 or later. If you are using an earlier version, you’ll need to restart the server. This is documented in the MySQL Manual. You can configure the log either in the config file or on the command line.

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. MySQL select 10 random rows from 600K rows fast
  3. How do you use the “WITH” clause in MySQL?
  4. mysql error 1364 Field doesn’t have a default values
  5. SQL: What is the default Order By of queries?
  6. MySQL Split Comma Separated String Into Temp Table
  7. How to group by week in MySQL?
  8. Can I use a function for a default value in MySql?
  9. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  10. Mysql order by specific ID values
  11. How do I check if a column is empty or null in MySQL?
  12. MySQL versus PDO [duplicate]
  13. Mysql string split [duplicate]
  14. Increment a database field by 1
  15. Measuring actual MySQL query time
  16. Am I Using JDBC Connection Pooling?
  17. MySQL VARCHAR Lengths and UTF-8
  18. mysql transaction – roll back on any exception
  19. Row number per group in mysql
  20. Find and replace entire MySQL database
  21. Resetting ROOT password in MySQL 5.6
  22. How do I refer to capture groups in a MySQL regex?
  23. What is the default MySQL JOIN behaviour, INNER or OUTER?
  24. How to get the mysql table columns data type?
  25. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  26. CREATE command denied to user？
  27. What is the MAX number if I store int(255) in MySQL?
  28. How to initialize mysql container when created on Kubernetes?
  29. Find duplicates in the same table in MySQL
  30. Auto-increment is not resetting in MySQL

Leave a Comment