How to enable slow query log MySQL?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

How to enable slow query log MySQL?
Question Posted on 18 Jul 2021

Home >> DataBase >> MySQL >> How to enable slow query log MySQL?

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.

	0
	0


Input Your Comments Or suggestions(If Any)
Name
Email		(optional)
Comments

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?

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)