percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00646
[Bug 379042] Re: log_slow_rate_limit doesn't work
Yasufumi,
Please fix for 5.0.77 also
--
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: Fix Committed
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;
References