PDA

View Full Version : To enable slow query logging of mysql



sparktechs
01-11-2007, 04:45 AM
Enter the following lines in /etc/my.cnf and restart mysql

# enable slow query log
#This is a great tool for checking what queries take too long
log-slow-queries=/tmp/slow_queries.log
log-update = /var/lib/mysql/updates.log

Oracle
05-17-2009, 02:17 AM
MySQL has built-in functionality that allows you to log SQL queries to a file , You can enable the full SQL queries logs to a file or only slow running queries log. It is easy for us to troubleshoot/ debug the sql statement if SQL queries log enable , The slow query log is used to find queries that take a long time to execute and are therefore candidates for optimization.

To enable you just need to add some lines to your my.cnf file, and restart. Add the following:

To enable slow Query Log only
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1

After enabling slow query, mysqld writes a statement to the slow query log file and it consists of all SQL statements that took more than long_query_time seconds to execute. The time to acquire the initial table locks is not counted as execution time. mysqld only log after SQL statements has been executed and after all locks have been released, so log order might be different from execution order. The minimum and default values of long_query_time are 1 and 10, respectively.

To enable full Log Query
log=/var/log/mysqldquery.log

The above will log all queries to the log file.

enjoy...........

ronaldwilcox
04-25-2017, 05:01 AM
How we use CHECK constraint in SQL?

earlfields
09-20-2017, 05:54 AM
Syntax for /etc/my.cnf in Red Hat 9:

[mysqld]
long_query_time=1
log-slow-queries=/var/log/mysql/log-slow-queries.log

You must create the file manually and change owners this way:

mkdir /var/log/mysql
touch /var/log/mysql/log-slow-queries.log
chown mysql.mysql -R /var/log/mysql

AdrianG001
04-18-2022, 08:12 AM
Enable the Slow Query Log
Log in to your server as the root user via SSH.
Open the my.cnf file with a text editor and add the following block of code under the mysqld section: ...
Create the /var/log/mysql-slow.log file and set its user as the mysql user. ...
Restart MySQL or MariaDB. ...
Start monitoring the slow query logfile.