Threads_created

USAGE

DETAILS

The Threads_created status variable shows the number of new threads created. For information about how to reuse threads, see "thread_cache_size".

Compute Thread Cache Miss Rate

The thread cache miss rate can be computed using the Threads_created and Connections status variables:

If you divide Threads_created by Connections, that shows the thread cache miss rate:

 SELECT threads_created, connections,
    (threads_created / connections) AS thread_cache_miss_rate
 FROM
    (SELECT gs1.VARIABLE_VALUE AS threads_created
    FROM information_schema.GLOBAL_STATUS gs1
    WHERE gs1.VARIABLE_NAME LIKE 'Threads_created') tc
JOIN
    (SELECT gs2.VARIABLE_VALUE AS connections
    FROM information_schema.GLOBAL_STATUS gs2
    WHERE gs2.VARIABLE_NAME LIKE 'Connections') c;

If the above query is executed at different times, the results can be interpreted in the following way:

  • If thread_cache_miss_rate stays constant or grows and approaches 1, the current thread cache size is not large enough to keep up with new connection requests.

  • If thread_cache_miss_rate shrinks and approaches 0, the current thread cache size is either equal to or larger than needed to keep up with new connection requests. To determine whether it is larger than needed, the Threads_cached status variable can also be monitored to determine whether the thread cache consistently contains too many cached threads.

For information about how to configure the thread cache, see "thread_cache_size".

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

Show Value with SHOW STATUS

SHOW GLOBAL STATUS statement can show the global value:

SHOW GLOBAL STATUS
   LIKE 'Threads_created';

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_created';

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_created';

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

11.4 Enterprise

  • Not present.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

Release Series

History

11.4 Enterprise

  • Not present.

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES