mysql – how to enable query logs

on

The steps to enable mysql query logs on Mysql 5.7 (should work on other versions also) on Linux

  • Edit /etc/my.cnf and add the following
    general_log=1
    general_log_file=/var/log/mysqlquery.log
  • Ensure /var/log has write permission for mysql user
    sudo chmod 777 /var/log
  • Restart mysql
    sudo systemctl restart mysqld

Suggested posts:

  1. Enable query log without restarting mysql on Linux
  2. Mysql – how to enable query log
  3. How to find mysql query rate on Linux
  4. WordPress mysql query to get all custom keys and values for a post
  5. How to check the performance of a plugin using mysql query log
  6. Mysql query to find all yoast meta description
  7. WordPress mysql query to get all posts with a missing custom field
  8. WordPress mysql query to get all posts with a specific custom field
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged ,