Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
None
-
None
-
Ubuntu 18.10;MariaDB 10.1.29;
Description
Hi
My MariaDB 10.1.29 is not logging slow query.
Here are config:
| log_slow_admin_statements | OFF |
|
| log_slow_filter | |
|
| log_slow_rate_limit | 1000 | |
| log_slow_slave_statements | OFF |
|
| log_slow_verbosity | |
|
| slow_launch_time | 2 | |
| slow_query_log | ON |
|
| slow_query_log_file | /var/log/mysql/mariadb-slow.log |
|
| long_query_time | 5.000000 | |
| log_output | FILE,TABLE |
|
and in status command ,I can see slow queries are more than 0:
MariaDB [(none)]> status
|
--------------
|
mysql Ver 15.1 Distrib 10.1.29-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 |
|
|
Connection id: 67 |
Current database:
|
Current user: root@localhost |
SSL: Not in use
|
Current pager: stdout
|
Using outfile: '' |
Using delimiter: ;
|
Server: MariaDB
|
Server version: 10.1.29-MariaDB-6ubuntu2 Ubuntu 18.10 |
Protocol version: 10 |
Connection: Localhost via UNIX socket
|
Server characterset: utf8mb4
|
Db characterset: utf8mb4
|
Client characterset: utf8mb4
|
Conn. characterset: utf8mb4
|
UNIX socket: /var/run/mysqld/mysqld.sock
|
Uptime: 1 hour 8 min 5 sec |
|
|
Threads: 28 Questions: 166151 Slow queries: 701 Opens: 196 Flush tables: 1 Open tables: 190 Queries per second avg: 40.673 |
but in slow log file and in mysql.slow_log,there is nothing at all.
anyone can give some help?
Thx!