summaryrefslogtreecommitdiff
path: root/mysql-test/r/connect.result
diff options
context:
space:
mode:
authorunknown <anozdrin/alik@quad.>2008-03-13 12:02:12 +0300
committerunknown <anozdrin/alik@quad.>2008-03-13 12:02:12 +0300
commitc167501bfb10d21a72bdf61ff59dc155280bc45e (patch)
tree7331aeb237ddb504aa5df416bc0bfb644a796fd1 /mysql-test/r/connect.result
parentb279be388e1d8208396ada701d3015b9d7cbbc4c (diff)
downloadmariadb-git-c167501bfb10d21a72bdf61ff59dc155280bc45e.tar.gz
Fix for Bug#35074: max_used_connections is not correct.
The problem was that number of threads was used to calculate max_used_connections. The fix is to use number of active connections. mysql-test/r/connect.result: Update result file. mysql-test/t/connect.test: - Add a test case for Bug#35074: max_used_connections is not correct; - Make a test case for Bug#33507 more stable. sql/mysqld.cc: Use number of connections insetad of threads to calculate max_used_connections.
Diffstat (limited to 'mysql-test/r/connect.result')
-rw-r--r--mysql-test/r/connect.result34
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/r/connect.result b/mysql-test/r/connect.result
index de4eb28c500..c323bdf5998 100644
--- a/mysql-test/r/connect.result
+++ b/mysql-test/r/connect.result
@@ -162,14 +162,48 @@ root
# -- Resetting variables...
SET GLOBAL max_connections = 151;
+
+# -- Stopping Event Scheduler...
SET GLOBAL event_scheduler = OFF;
+# -- Waiting for Event Scheduler to stop...
# -- That's it. Closing connections...
# -- Restoring default connection...
+# -- Waiting for connections to close...
+
+DROP USER mysqltest_u1@localhost;
+
# -- End of Bug#33507.
+# -- Bug#35074: max_used_connections is not correct.
+
+FLUSH STATUS;
+
+SHOW STATUS LIKE 'max_used_connections';
+Variable_name Value
+Max_used_connections 1
+
+# -- Starting Event Scheduler...
+SET GLOBAL event_scheduler = ON;
+# -- Waiting for Event Scheduler to start...
+
+# -- Opening a new connection to check max_used_connections...
+
+# -- Check that max_used_connections hasn't changed.
+SHOW STATUS LIKE 'max_used_connections';
+Variable_name Value
+Max_used_connections 2
+
+# -- Closing new connection...
+
+# -- Stopping Event Scheduler...
+SET GLOBAL event_scheduler = OFF;
+# -- Waiting for Event Scheduler to stop...
+
+# -- End of Bug#35074.
+
# ------------------------------------------------------------------
# -- End of 5.1 tests
# ------------------------------------------------------------------