0

How to enable MySQL Slow Query Log

Hi i want to enable MySQL Slow Query Log, but i don't want to restart my Database Service. How can i do that?

hobbs
asked Aug 13, 2018
1 Answer
0

To enable MySql Slow query log Enter the MySQL shell and run the following command:

set global slow_query_log = 'ON';

View More
linuxhelp
answered Jan 29, 2019
Your Answer
||||
​x
 
​
100:0

Related Tutorials in How to enable MySQL Slow Query Log

Related Tutorials in How to enable MySQL Slow Query Log

How To Install AnyDesk on Centos 7
How To Install AnyDesk on Centos 7
Apr 2, 2018
How to install Tiki Wiki CMS Groupware on CentOS 7
How to install Tiki Wiki CMS Groupware on CentOS 7
May 31, 2018
How to install PHP ImageMagick on CentOS 7
How to install PHP ImageMagick on CentOS 7
Nov 4, 2017
How to Upgrade and Downgrade the PHP Versions on CentOS 7.6
How to Upgrade and Downgrade the PHP Versions on CentOS 7.6
Jun 4, 2019
How to install Apache from Source Code on CentOS 7
How to install Apache from Source Code on CentOS 7
Oct 21, 2017
How to enable or disable repositories in CentOS
How to enable or disable repositories in CentOS
Mar 28, 2018
How to install Apache JMeter in CentOS 7
How to install Apache JMeter in CentOS 7
Mar 24, 2017
How to install AWStats on CentOS 7
How to install AWStats on CentOS 7
Dec 8, 2017

Related Forums in How to enable MySQL Slow Query Log

Related Forums in How to enable MySQL Slow Query Log

CentOS
connor class=
How To Completely Remove Apache package On CentOS 7.6
May 14, 2019
CentOS
ceriaimmaculate class=
setfacl : command not found
Jan 3, 2018
MySQL
rolando class=
Mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Table 'performance_schema.session_variables' doesn't exist (1146)
May 9, 2019
MySQL
isaiah class=
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
Feb 8, 2017
CentOS
mason class=
Error getting authority: Error initializing authority: Could not connect: No such file or directory (g-io-error-quark, 1)
Nov 20, 2018
CentOS
landon class=
Command to find SNMP Version
May 28, 2018
CentOS
arjitharon class=
cannot start minio service help
Mar 10, 2018
Apache tomcat
AadrikaAnshu class=
Cannot find ./catalina.sh The file is absent or does not have execute permission This file is needed to run this program
Jun 17, 2019

Related News in How to enable MySQL Slow Query Log

Related News in How to enable MySQL Slow Query Log