{"id":2850,"date":"2023-02-02T15:52:01","date_gmt":"2023-02-02T10:22:01","guid":{"rendered":"https:\/\/trysiteprice.com\/blog\/?p=2850"},"modified":"2023-02-02T15:52:01","modified_gmt":"2023-02-02T10:22:01","slug":"how-to-set-and-enable-mariadb-slow-query-log","status":"publish","type":"post","link":"https:\/\/trysiteprice.com\/blog\/how-to-set-and-enable-mariadb-slow-query-log\/","title":{"rendered":"How to set and enable MariaDB slow query log"},"content":{"rendered":"
\n
\n
\n
\n
\n
\n

To enable and set up the slow query log in MariaDB, you need to modify the configuration file my.cnf<\/code> and restart the MariaDB service.<\/p>\n

Here are the steps to enable the slow query log in MariaDB:<\/p>\n

    \n
  1. Open the my.cnf<\/code> configuration file:<\/li>\n<\/ol>\n
    \n
    <\/div>\n
    sudo nano \/etc\/my.cnf
    \n<\/code><\/div>\n<\/div>\n
      \n
    1. Add the following lines to the configuration file:<\/li>\n<\/ol>\n
      \n
      <\/div>\n
      [mysqld]
      \nslow_query_log = 1
      \nslow_query_log_file = \/var\/log\/mysql\/mariadb-slow.log
      \nlong_query_time = 2
      \nlog_queries_not_using_indexes = 1
      \n<\/code><\/div>\n<\/div>\n