diff options
Diffstat (limited to 'mysql-test/main/thread_pool_info.result')
| -rw-r--r-- | mysql-test/main/thread_pool_info.result | 89 |
1 files changed, 89 insertions, 0 deletions
diff --git a/mysql-test/main/thread_pool_info.result b/mysql-test/main/thread_pool_info.result new file mode 100644 index 00000000000..802e2f3a7ec --- /dev/null +++ b/mysql-test/main/thread_pool_info.result @@ -0,0 +1,89 @@ +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 +SELECT COUNT(*)=@@thread_pool_size FROM INFORMATION_SCHEMA.THREAD_POOL_GROUPS; +COUNT(*)=@@thread_pool_size +1 +SELECT SUM(CONNECTIONS) FROM INFORMATION_SCHEMA.THREAD_POOL_GROUPS; +SUM(CONNECTIONS) +1 +SELECT SUM(THREADS) > 0 FROM INFORMATION_SCHEMA.THREAD_POOL_GROUPS; +SUM(THREADS) > 0 +1 +SELECT SUM(ACTIVE_THREADS) > 0 FROM INFORMATION_SCHEMA.THREAD_POOL_GROUPS; +SUM(ACTIVE_THREADS) > 0 +1 +SELECT SUM(QUEUE_LENGTH) FROM INFORMATION_SCHEMA.THREAD_POOL_GROUPS; +SUM(QUEUE_LENGTH) +0 +SELECT SUM(IS_STALLED) FROM INFORMATION_SCHEMA.THREAD_POOL_GROUPS; +SUM(IS_STALLED) +0 +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 +CONNECTION_ID bigint(19) unsigned NO 0 +QUEUEING_TIME_MICROSECONDS bigint(19) NO 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 +SELECT SUM(DEQUEUES_BY_LISTENER+DEQUEUES_BY_WORKER) > 0 FROM INFORMATION_SCHEMA.THREAD_POOL_STATS; +SUM(DEQUEUES_BY_LISTENER+DEQUEUES_BY_WORKER) > 0 +1 +SELECT SUM(POLLS_BY_LISTENER+POLLS_BY_WORKER) > 0 FROM INFORMATION_SCHEMA.THREAD_POOL_STATS; +SUM(POLLS_BY_LISTENER+POLLS_BY_WORKER) > 0 +1 +FLUSH THREAD_POOL_STATS; +SELECT SUM(DEQUEUES_BY_LISTENER+DEQUEUES_BY_WORKER) FROM INFORMATION_SCHEMA.THREAD_POOL_STATS; +SUM(DEQUEUES_BY_LISTENER+DEQUEUES_BY_WORKER) +1 +SELECT SUM(POLLS_BY_LISTENER+POLLS_BY_WORKER) FROM INFORMATION_SCHEMA.THREAD_POOL_STATS; +SUM(POLLS_BY_LISTENER+POLLS_BY_WORKER) +2 +DESC INFORMATION_SCHEMA.THREAD_POOL_WAITS; +Field Type Null Key Default Extra +REASON varchar(16) NO +COUNT bigint(19) NO 0 +SELECT REASON FROM INFORMATION_SCHEMA.THREAD_POOL_WAITS; +REASON +UNKNOWN +SLEEP +DISKIO +ROW_LOCK +GLOBAL_LOCK +META_DATA_LOCK +TABLE_LOCK +USER_LOCK +BINLOG +GROUP_COMMIT +SYNC +NET +SELECT COUNT FROM INFORMATION_SCHEMA.THREAD_POOL_WAITS WHERE REASON='Sleep'; +COUNT +0 +SELECT SLEEP(0.01); +SLEEP(0.01) +0 +SELECT COUNT FROM INFORMATION_SCHEMA.THREAD_POOL_WAITS WHERE REASON='Sleep'; +COUNT +1 +FLUSH THREAD_POOL_WAITS; |