Home / server / Questions / 406119
In Process
samwell
Asked: 2012-07-10 09:33:54 +0800 CST

Is there a way to log every query with MySQL?

  • 772

My MySQL server has been unusually been using a higher load of CPU. So I looked around how to log each queries and I found a lot of tutorials that were saying the same thing: http://www.howtogeek.com/howto/database/monitor-all-sql-queries-in-mysql/

I followed the tutorial but the log file did not contain any queries. One thing I thought I should mention is that, the /var/logs/ the folder mysql did not exist, so I made the folder and created a log file called mysql.log in it.

A little background of my box:

  • Arch Linux
  • Nginx
  • PHP/Ruby/Python/Perl
  • MySQL
mysql arch-linux

2 Answers

  1. By default mysql keep logs in the working directory, usually /var/db/mysql. All you need to enable logging is to set variable general_log to "ON". Also, you can set general_log_file variable to the desired place.

    SET @@global.general_log = 1;
SET @@global.general_log_file = '/where/to/store/log/file.txt';
    • 1

  2. Check out the Slow Query Log option.

    You can find detailed information on dev.mysql.com

    • 1