Question: Automate the following - - - ENABLE SLOW QUERIES - - - 1 . Turn on slow query logset global slow _ query _ log

Automate the following
--- ENABLE SLOW QUERIES ---1. Turn on slow query logset global slow_query_log ='ON';2. Set the amount of time a query needs to run before being loggedset global long_query_time =2;3. Exit the pod4. Enter the pod mysql session5. Check the slow query log is ON & path to slow query log fileshow variables like '%slow%';6. Check the long query execution timeshow variables like '%long_query_time%';7. Queries will be populated in slow query log file.--- DISABLE SLOW QUERIES ---8. Turn off slow query logset global slow_query_log = 'OFF';9. Set the 'long_query_time' variable back to default valueset global long_query_time =10;10. Exit the pod

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!