Monday, December 27, 2021

command to get the parameter values in MySQL?

 


mysql> SHOW VARIABLES LIKE '%slow_query_log%';

--------------

SHOW VARIABLES LIKE '%slow_query_log%'

--------------


+---------------------+------------------------+

| Variable_name       | Value                  |

+---------------------+------------------------+

| slow_query_log      | ON                     |

| slow_query_log_file | <server_name>-slow.log |

+---------------------+------------------------+

2 rows in set (0.00 sec)

No comments:

Post a Comment