Differences

This shows you the differences between two versions of the page.

--- mysql_slow_query [2016/02/01 17:13] – luke7858
+++ mysql_slow_query [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 === Slow Query Logs ===
+Checking the slow query logs via mysql prompt.
+\\
+\\Note: You CAN enable the slow query logging on runtime. A mysql restart will flush the changes made via runtime. If you wish for persistence then add it to the /etc/my.cnf file:
+<sxh bash>
+mysql> SHOW GLOBAL VARIABLES LIKE 'slow\_%';
++---------------------+-------------------------------+
+| Variable_name       | Value                         |
++---------------------+-------------------------------+
+| slow_query_log      | ON                            |
+| slow_query_log_file | /path/to/slow_query.log       |
++---------------------+-------------------------------+
+</sxh>
+Set the logs to another path:
+<sxh bash>
+mysql> SET GLOBAL slow_query_log_file = '/path/to/slow_query.log';
+</sxh>
+<sxh bash>
+mysql> SET GLOBAL slow_query_log = 'ON';
+</sxh>
+\\
+Via the command line:
+\\
+\\
 You can check to see if slow query logging is currently enabled. The following command assumes you have configured .my.cnf file:
 <sxh bash>
-show full variables like "%slow%";
+show variables like "%slow%";
 </sxh>
 Or you can run the following from the command line:
@@ Line 53: / Line 76: @@
 \\
 **__NOTE__**: To enable to variables without restarting the service, use a combination of both techniques above.
+\\
 \\
 === Run-time Configuration ===