mariadb, mysql and percona 5.5 general query and slow query logging
mariadb, mysql and percona 5.5 general query and slow query logging
- https://dev.mysql.com/doc/refman/5.5/en/log-destinations.html
- https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_general_log_file
- https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_slow_query_log_file
mysql> select @@general_log;
+---------------+
| @@general_log |
+---------------+
| 1 |
+---------------+
mysql> select @@general_log_file;
+-------------------------------+
| @@general_log_file |
+-------------------------------+
| /var/lib/mysql/data/query.log |
+-------------------------------+
mysql> select @@slow_query_log;
+------------------+
| @@slow_query_log |
+------------------+
| 1 |
+------------------+
mysql> select @@slow_query_log_file;
+------------------------------------+
| @@slow_query_log_file |
+------------------------------------+
| /var/lib/mysql/data/mysql-slow.log |
+------------------------------------+