| How to enable slow query log MySQL?
As the name suggest slow query log this will slow down the performance of query or overall server performance. And this can be huge in size. Below are five steps to enable slow query logs in python
(1)In first step we need to do login in server by using SSH.
(2)In second step on command line we need to use below command:-
mysql -u root -p
(3)In third step we need to type MySQL root password.
(4)In fourth step to enable slow query log we need to run below command as mySQL prompt:-
SET GLOBAL slow_query_log = 'ON'
(5)We have some additional option when we using slow query log. | | |