From 307ca6935669ae9621aa36239ff3803b60640622 Mon Sep 17 00:00:00 2001 From: Vladislav Vaintroub Date: Sun, 26 May 2019 13:35:07 +0200 Subject: Add some variables to the generic threadpool, that could help to analyze stalls etc better. - thread_pool_exact_stats - uses high precision timestamp for the time when connection was added to the queue. This timestamp helps calculating queuing time shown in I_S.THREADPOOL_QUEUES entries. - If thread_pool_dedicated_listener is on, then each group will have its own dedicated listener, that does not convert to worker. With this variable on, the queueing time in I_S.THREADPOOL_QUEUES , and actual queue size in I_S.THREADPOOOL_GROUPS will be more exact, since IO request are immediately dequeued from poll, without delay. Part of MDEV-19313. --- .../sys_vars/r/sysvars_server_notembedded.result | 28 ++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'mysql-test/suite/sys_vars/r') diff --git a/mysql-test/suite/sys_vars/r/sysvars_server_notembedded.result b/mysql-test/suite/sys_vars/r/sysvars_server_notembedded.result index aa75bb6e2f1..8d7bf6356aa 100644 --- a/mysql-test/suite/sys_vars/r/sysvars_server_notembedded.result +++ b/mysql-test/suite/sys_vars/r/sysvars_server_notembedded.result @@ -5346,6 +5346,34 @@ NUMERIC_BLOCK_SIZE NULL ENUM_VALUE_LIST one-thread-per-connection,no-threads,pool-of-threads READ_ONLY YES COMMAND_LINE_ARGUMENT REQUIRED +VARIABLE_NAME THREAD_POOL_DEDICATED_LISTENER +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT If set to 1,listener thread will not pick up queries +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT OPTIONAL +VARIABLE_NAME THREAD_POOL_EXACT_STATS +SESSION_VALUE NULL +GLOBAL_VALUE OFF +GLOBAL_VALUE_ORIGIN COMPILE-TIME +DEFAULT_VALUE OFF +VARIABLE_SCOPE GLOBAL +VARIABLE_TYPE BOOLEAN +VARIABLE_COMMENT If set to 1, provides better statistics in information_schema threadpool tables +NUMERIC_MIN_VALUE NULL +NUMERIC_MAX_VALUE NULL +NUMERIC_BLOCK_SIZE NULL +ENUM_VALUE_LIST OFF,ON +READ_ONLY NO +COMMAND_LINE_ARGUMENT OPTIONAL VARIABLE_NAME THREAD_POOL_IDLE_TIMEOUT SESSION_VALUE NULL GLOBAL_VALUE 60 -- cgit v1.2.1