diff options
| author | Vladislav Vaintroub <wlad@montyprogram.com> | 2013-05-08 20:37:17 +0200 |
|---|---|---|
| committer | Vladislav Vaintroub <wlad@montyprogram.com> | 2013-05-08 20:37:17 +0200 |
| commit | f33178b99a0b88eb513b95ac4b74ca3d3f1d70b7 (patch) | |
| tree | b2e1397fe731832327019e5951f3bfdf29f989d2 /mysql-test/r/log_slow.result | |
| parent | e013bf9f0e2ffd05de5bfe95c4102e61b08ac06a (diff) | |
| download | mariadb-git-f33178b99a0b88eb513b95ac4b74ca3d3f1d70b7.tar.gz | |
MDEV-4206 : log all slow statements (do not use filters), if log_slow_filter is empty.
Diffstat (limited to 'mysql-test/r/log_slow.result')
| -rw-r--r-- | mysql-test/r/log_slow.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/log_slow.result b/mysql-test/r/log_slow.result index 75e92e7a0b5..318dfa7568d 100644 --- a/mysql-test/r/log_slow.result +++ b/mysql-test/r/log_slow.result @@ -56,5 +56,18 @@ insert_id int(11) NO NULL server_id int(10) unsigned NO NULL sql_text mediumtext NO NULL flush slow logs; +set long_query_time=0.1; +set log_slow_filter=''; +set global slow_query_log=1; +set global log_output='TABLE'; +select sleep(0.5); +sleep(0.5) +0 +select count(*) FROM mysql.slow_log; +count(*) +1 +truncate mysql.slow_log; +set @@long_query_time=default; +set global slow_query_log=default; set @@log_slow_filter=default; set @@log_slow_verbosity=default; |