{"id":389,"date":"2021-07-23T12:28:57","date_gmt":"2021-07-23T12:28:57","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/how-to-enable-the-slow-query-log-in-mysql-or-mariadb\/"},"modified":"2021-07-23T12:28:57","modified_gmt":"2021-07-23T12:28:57","slug":"how-to-enable-the-slow-query-log-in-mysql-or-mariadb","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/how-to-enable-the-slow-query-log-in-mysql-or-mariadb\/","title":{"rendered":"How to Enable the Slow Query Log in MySQL\u00ae or MariaDB"},"content":{"rendered":"<\/p>\n
\n
<\/div>\n
\n

Overview<\/h2>\n

Enabling the Slow Query Log for MySQL\u00ae or MariaDB can be a useful tool to diagnose performance and efficiency issues affecting your server. By identifying queries that are particularly slow in their execution, you can address them by restructuring the application that triggers your queries. You can also rebuild the queries themselves to ensure that they are constructed as efficiently as possible.<\/p>\n

For more information about the MySQL slow query log, read the MySQL 5.7 Reference Manual: The Slow Query Log documentation.<\/p>\n

Enable the Slow Query Log<\/h2>\n

To enable the Slow Query Log for MySQL or MariaDB:<\/p>\n

    \n
  1. \n

    Log in to your server as the root<\/code> user via SSH.<\/p>\n<\/li>\n

  2. \n

    Open the my.cnf<\/code> file with a text editor and add the following block of code under the mysqld<\/code> section:\n<\/p>\n

    \n
    slow_query_log =<\/span> 1<\/span>\nslow-query_log_file =<\/span> \/var\/log\/mysql-slow.log\nlong_query_time =<\/span> 2<\/span><\/code><\/pre>\n<\/div>\n
    \n
    Note:<\/div>\n
    \n
    In MySQL 5.6 and older, use the log-slow-queries<\/code> variable instead of the slow-query_log_file<\/code> variable.<\/p>\n<\/p><\/div>\n<\/div>\n<\/li>\n
  3. \n
    Create the \/var\/log\/mysql-slow.log<\/code> file and set its user as the mysql<\/code> user. To do this, run the following commands:\n<\/p>\n
    \n
    touch \/var\/log\/mysql-slow.log\nchown mysql:mysql \/var\/log\/mysql-slow.log<\/code><\/pre>\n<\/div>\n<\/li>\n
  4. \n
    Restart MySQL or MariaDB. To do this, run the following command:\n<\/p>\n
    \n
    \/usr\/local\/cpanel\/scripts\/restartsrv_mysql<\/code><\/pre>\n<\/div>\n<\/li>\n
  5. \n
    Start monitoring the slow query logfile. To analyze and print the file\u2019s summary, run the mysqldumpslow<\/code> command. For example, to print all slow queries that the system previously recorded, run the following command:\n<\/p>\n
    \n
    mysqldumpslow -a \/var\/log\/mysql-slow.log<\/code><\/pre>\n<\/div>\n<\/li>\n<\/ol>\n
    For a complete list of options to use with the mysqldumpslow<\/code> command, read MySQL\u2019s mysqldumpslow article.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
    Overview Enabling the Slow Query Log for MySQL\u00ae or MariaDB can be a useful tool to diagnose performance and efficiency issues affecting your server. By identifying queries that are particularly slow in their execution, you can address them by restructuring the application that triggers your queries. You can also rebuild the queries themselves to ensure …<\/p>\n","protected":false},"author":1,"featured_media":390,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/389"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=389"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/389\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/390"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}