crackyourinterview.com


To improves our performance please Like Share Subscribe(Will boost us)

Default time to log a query in slow query log and can we change that in MySQL?
Question Posted on 20 Jul 2021Home >> DataBase >> MySQL >> Default time to log a query in slow query log and can we change that in MySQL?

Default time to log a query in slow query log and can we change that in MySQL?
Yes, we can change the default time to log a query in MySQL. By default it will take more then 10 seconds to run. We can change this interval. And below is the command to change the time:-
SET GLOBAL long_query_time = n;
In above command we can put number in place of n to set the time to log query in slow query log.
0
0



.


Most Visited Questions:-

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...




Other Important Questions

Can we use "Order BY" in delete statement in MySQL Query?

Difference between char_length and Length in MySQL?

What are different tables and default database present in MySQL?

Way to clear screen in MySQL in Window operating system?

Who was started and owned MySQL?






@2014-2022 Crackyourinterview (All rights reserved)
Privacy Policy - Disclaimer - Sitemap