Threads_cached
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 threads cached in the thread cache.
DETAILS
The Threads_cached status variable shows the number of threads cached in the thread cache. For information about how to set the maximum size, see "thread_
Interaction with Thread Pool
When thread_handling=pool-of-threads is set, the Threads_cached status variable's value is always 0.
EXAMPLES
Show Value with SHOW STATUS
SHOW GLOBAL STATUS statement can show the global value:
SHOW GLOBAL STATUS
LIKE 'Threads_cached';
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_cached';
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_cached';