summaryrefslogtreecommitdiff
path: root/mysql-test/main/thread_pool_info.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/thread_pool_info.result')
-rw-r--r--mysql-test/main/thread_pool_info.result50
1 files changed, 25 insertions, 25 deletions
diff --git a/mysql-test/main/thread_pool_info.result b/mysql-test/main/thread_pool_info.result
index 53fa1d1255d..d79a4f8d50b 100644
--- a/mysql-test/main/thread_pool_info.result
+++ b/mysql-test/main/thread_pool_info.result
@@ -1,13 +1,13 @@
DESC INFORMATION_SCHEMA.THREAD_POOL_GROUPS;
Field Type Null Key Default Extra
-GROUP_ID int(6) NO 0
-CONNECTIONS int(6) NO 0
-THREADS int(6) NO 0
-ACTIVE_THREADS int(6) NO 0
-STANDBY_THREADS int(6) NO 0
-QUEUE_LENGTH int(6) NO 0
-HAS_LISTENER tinyint(1) NO 0
-IS_STALLED tinyint(1) NO 0
+GROUP_ID int(6) NO NULL
+CONNECTIONS int(6) NO NULL
+THREADS int(6) NO NULL
+ACTIVE_THREADS int(6) NO NULL
+STANDBY_THREADS int(6) NO NULL
+QUEUE_LENGTH int(6) NO NULL
+HAS_LISTENER tinyint(1) NO NULL
+IS_STALLED tinyint(1) NO NULL
SELECT COUNT(*)=@@thread_pool_size FROM INFORMATION_SCHEMA.THREAD_POOL_GROUPS;
COUNT(*)=@@thread_pool_size
1
@@ -28,17 +28,17 @@ SUM(IS_STALLED)
0
DESC INFORMATION_SCHEMA.THREAD_POOL_STATS;
Field Type Null Key Default Extra
-GROUP_ID int(6) NO 0
-THREAD_CREATIONS bigint(19) NO 0
-THREAD_CREATIONS_DUE_TO_STALL bigint(19) NO 0
-WAKES bigint(19) NO 0
-WAKES_DUE_TO_STALL bigint(19) NO 0
-THROTTLES bigint(19) NO 0
-STALLS bigint(19) NO 0
-POLLS_BY_LISTENER bigint(19) NO 0
-POLLS_BY_WORKER bigint(19) NO 0
-DEQUEUES_BY_LISTENER bigint(19) NO 0
-DEQUEUES_BY_WORKER bigint(19) NO 0
+GROUP_ID int(6) NO NULL
+THREAD_CREATIONS bigint(19) NO NULL
+THREAD_CREATIONS_DUE_TO_STALL bigint(19) NO NULL
+WAKES bigint(19) NO NULL
+WAKES_DUE_TO_STALL bigint(19) NO NULL
+THROTTLES bigint(19) NO NULL
+STALLS bigint(19) NO NULL
+POLLS_BY_LISTENER bigint(19) NO NULL
+POLLS_BY_WORKER bigint(19) NO NULL
+DEQUEUES_BY_LISTENER bigint(19) NO NULL
+DEQUEUES_BY_WORKER bigint(19) NO NULL
SELECT SUM(DEQUEUES_BY_LISTENER+DEQUEUES_BY_WORKER) > 0 FROM INFORMATION_SCHEMA.THREAD_POOL_STATS;
SUM(DEQUEUES_BY_LISTENER+DEQUEUES_BY_WORKER) > 0
1
@@ -57,8 +57,8 @@ SUM(POLLS_BY_WORKER)
0
DESC INFORMATION_SCHEMA.THREAD_POOL_WAITS;
Field Type Null Key Default Extra
-REASON varchar(16) NO
-COUNT bigint(19) NO 0
+REASON varchar(16) NO NULL
+COUNT bigint(19) NO NULL
SELECT REASON FROM INFORMATION_SCHEMA.THREAD_POOL_WAITS;
REASON
UNKNOWN
@@ -85,11 +85,11 @@ COUNT
FLUSH THREAD_POOL_WAITS;
DESC INFORMATION_SCHEMA.THREAD_POOL_QUEUES;
Field Type Null Key Default Extra
-GROUP_ID int(6) NO 0
-POSITION int(6) NO 0
-PRIORITY int(1) NO 0
+GROUP_ID int(6) NO NULL
+POSITION int(6) NO NULL
+PRIORITY int(1) NO NULL
CONNECTION_ID bigint(19) unsigned YES NULL
-QUEUEING_TIME_MICROSECONDS bigint(19) NO 0
+QUEUEING_TIME_MICROSECONDS bigint(19) NO NULL
# restart: with restart_parameters
connect con1, localhost, root,,test;
connection con1;