mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
62e320c86d
The 10.5 version of the patch. Removing DEFAULT from INFORMATION_SCHEMA columns. DEFAULT in read-only tables is rather meaningless. Upgrade should go smoothly. Also fixes: MDEV-20254 Problems with EMPTY_STRING_IS_NULL and I_S tables
111 lines
3.1 KiB
Text
111 lines
3.1 KiB
Text
DESC INFORMATION_SCHEMA.THREAD_POOL_GROUPS;
|
|
Field Type Null Key Default Extra
|
|
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
|
|
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_STATS;
|
|
Field Type Null Key Default Extra
|
|
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
|
|
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) FROM INFORMATION_SCHEMA.THREAD_POOL_STATS;
|
|
SUM(POLLS_BY_LISTENER)
|
|
2
|
|
SELECT SUM(POLLS_BY_WORKER) FROM INFORMATION_SCHEMA.THREAD_POOL_STATS;
|
|
SUM(POLLS_BY_WORKER)
|
|
0
|
|
DESC INFORMATION_SCHEMA.THREAD_POOL_WAITS;
|
|
Field Type Null Key Default Extra
|
|
REASON varchar(16) NO NULL
|
|
COUNT bigint(19) NO NULL
|
|
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;
|
|
DESC INFORMATION_SCHEMA.THREAD_POOL_QUEUES;
|
|
Field Type Null Key Default Extra
|
|
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 NULL
|
|
# restart: with restart_parameters
|
|
connect con1, localhost, root,,test;
|
|
connection con1;
|
|
connect con2, localhost, root,,test;
|
|
connection con2;
|
|
connect extra_con,127.0.0.1,root,,test,$extra_port,;
|
|
connection con1;
|
|
SELECT SLEEP(1000);
|
|
connection extra_con;
|
|
connection con2;
|
|
DO 1;
|
|
connection extra_con;
|
|
KILL QUERY con1_id;
|
|
disconnect extra_con;
|
|
connection con1;
|
|
disconnect con1;
|
|
connection con2;
|
|
disconnect con2;
|
|
connection default;
|