percona-discussion team mailing list archive

[Aleksandr Kuzminsky <aleksandr.kuzminsky@xxxxxxxxxxx>]

Public bug reported:

I set to log every 3-rd session, but instead all sessions are logged:

SET GLOBAL long_query_time = 0;
SET GLOBAL log_slow_rate_limit=3;
SET long_query_time = 0;
SET log_slow_rate_limit=3;

SELECT * FROM t1 WHERE id = 2;
connect (conn1,localhost,root,,test);
connect (conn2,localhost,root,,test);
connection conn1;
SELECT * FROM t1 WHERE id = 2;
connection conn2;
SELECT * FROM t1 WHERE id = 2;
connection default;

Here is a slow log:

# User@Host: root[root] @ localhost []
# Thread_id: 2  Schema: test
# Query_time: TIME  Lock_time: TIME  Rows_sent: 1  Rows_examined: 1  Rows_affected: 0  Rows_read: 2
SET timestamp=TIME;
SELECT * FROM t1 WHERE id = 2;
# User@Host: root[root] @ localhost []
# Thread_id: 3  Schema: test
# Query_time: TIME  Lock_time: TIME  Rows_sent: 1  Rows_examined: 1  Rows_affected: 0  Rows_read: 2
SET timestamp=TIME;
SELECT * FROM t1 WHERE id = 2;
# User@Host: root[root] @ localhost []
# Thread_id: 4  Schema: test
# Query_time: TIME  Lock_time: TIME  Rows_sent: 1  Rows_examined: 1  Rows_affected: 0  Rows_read: 2
SET timestamp=TIME;
SELECT * FROM t1 WHERE id = 2;

** Affects: percona-patches
     Importance: Undecided
         Status: New

-- 
log_slow_rate_limit doesn't work
https://bugs.launchpad.net/bugs/379042
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona patches.

Status in Patches for MySQL by Percona: New

Bug description:
I set to log every 3-rd session, but instead all sessions are logged:

SET GLOBAL long_query_time = 0;
SET GLOBAL log_slow_rate_limit=3;
SET long_query_time = 0;
SET log_slow_rate_limit=3;

SELECT * FROM t1 WHERE id = 2;
connect (conn1,localhost,root,,test);
connect (conn2,localhost,root,,test);
connection conn1;
SELECT * FROM t1 WHERE id = 2;
connection conn2;
SELECT * FROM t1 WHERE id = 2;
connection default;

Here is a slow log:

# User@Host: root[root] @ localhost []
# Thread_id: 2  Schema: test
# Query_time: TIME  Lock_time: TIME  Rows_sent: 1  Rows_examined: 1  Rows_affected: 0  Rows_read: 2
SET timestamp=TIME;
SELECT * FROM t1 WHERE id = 2;
# User@Host: root[root] @ localhost []
# Thread_id: 3  Schema: test
# Query_time: TIME  Lock_time: TIME  Rows_sent: 1  Rows_examined: 1  Rows_affected: 0  Rows_read: 2
SET timestamp=TIME;
SELECT * FROM t1 WHERE id = 2;
# User@Host: root[root] @ localhost []
# Thread_id: 4  Schema: test
# Query_time: TIME  Lock_time: TIME  Rows_sent: 1  Rows_examined: 1  Rows_affected: 0  Rows_read: 2
SET timestamp=TIME;
SELECT * FROM t1 WHERE id = 2;