Threads_connected
This page is part of MariaDB's Documentation.
The parent of this page is: Status Variables for MariaDB Enterprise Server
Topics on this page:
Overview
Shows the number of client connections currently connected.
DETAILS
The Threads_connected status variable shows the number of client connections currently connected.
Interaction with Thread Pool
When thread_handling=pool-of-threads is set, the Threads_connected status variable's value does not reflect the actual number of threads, because the client connections would share threads from the thread pool.
EXAMPLES
Show Value with SHOW STATUS
SHOW GLOBAL STATUS statement can show the global value:
SHOW GLOBAL STATUS
LIKE 'Threads_connected';
Since this status variable is only global scope, SHOW STATUS and SHOW SESSION STATUS also show the global value.
Information Schema
The information_schema.GLOBAL_STATUS table can be queried to obtain the global value:
SELECT *
FROM information_schema.GLOBAL_STATUS
WHERE VARIABLE_NAME LIKE 'Threads_connected';
This status variable is only global scope, so the information_schema.SESSION_STATUS table can also be queried to obtain the global value:
SELECT *
FROM information_schema.SESSION_STATUS
WHERE VARIABLE_NAME LIKE 'Threads_connected';