instructions - how to enable mysql sloq query log

[shoulders]

defaults

• slow_query_log = OFF = uses words rather than 0 and `1

Enable slow query log

• https://stackoverflow.com/questions/22609257/how-do-i-enable-the-mysql-slow-query-log
• https://www.geeksforgeeks.org/mysql/how-to-enable-mysql-query-log/
• Check all of my links aswell

Check slow query log is on**

 mysql -e "SHOW VARIABLES LIKE 'slow_query_log';"
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| slow_query_log | ON    |

 

=============

mysql -e "SHOW VARIABLES LIKE 'slow_query_log_file';"
+---------------------+-------------------------------+
| Variable_name       | Value                         |
+---------------------+-------------------------------+
| slow_query_log_file | /var/lib/mysql/slow-query.log |
+---------------------+-------------------------------+

change length of queries that are logged

As per your request, we raised the long_query_time to 5 seconds.We have successfully resumed the MySQL service. 

+-----------------+----------+
| Variable_name   | Value    |
+-----------------+----------+
| long_query_time | 5.000000 |
+-----------------+----------+