pool_of_threads.test 1.93 KB
Newer Older
1 2 3 4
# Start with thread_handling=pool-of-threads
# and run a number of tests

-- source include/have_pool_of_threads.inc
5 6
# Slow test, don't run during staging part
-- source include/not_staging.inc
7 8
-- source include/common-tests.inc

9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83

# Test that we cannot have more simultaneous connections than
# --thread-pool-size on the standard port, but _can_ have additional
# connections on the extra port.

# First set two connections running, and check that extra connection
# on normal port fails due to--thread-pool-size=2
connection default;
send SELECT sleep(5);

connect(con2,localhost,root,,);
connection con2;
send SELECT sleep(5);
--sleep 1

--disable_abort_on_error
--disable_result_log
--disable_query_log
connect(con3,localhost,root,,);
--enable_query_log
--enable_result_log
--enable_abort_on_error
let $error = $mysql_errno;
if (!$error)
{
  --echo # -- Error: managed to establish more than --thread-pool-size connections
}
if ($error)
{
  --echo # -- Success: more than --thread-pool-size normal connections not possible
}

connection default;
--reap
connection con2;
--reap

# Now try again, but this time use the extra port to successfully connect.

connection default;
send SELECT sleep(5);

connection con2;
send SELECT sleep(5);
--sleep 1

connect(extracon,127.0.0.1,root,,test,$MASTER_EXTRA_PORT,);
connection extracon;
SELECT 'Connection on extra port ok';

connect(extracon2,127.0.0.1,root,,test,$MASTER_EXTRA_PORT,);
connection extracon2;
SELECT 'Connection on extra port 2 ok';

--disable_abort_on_error
--disable_result_log
--disable_query_log
connect(extracon3,127.0.0.1,root,,test,$MASTER_EXTRA_PORT,);
--enable_query_log
--enable_result_log
--enable_abort_on_error
let $error = $mysql_errno;
if (!$error)
{
  --echo # -- Error: managed to establish more than --extra-max-connections + 1 connections
}
if ($error)
{
  --echo # -- Success: more than --extra-max-connections + 1 normal connections not possible
}

connection default;
--reap
connection con2;
--reap