Not the answer you need?
Register and ask your own question!

Threads_cached is ZERO

Lelik1985Lelik1985 EntrantCurrent User Role Beginner
I have 6 nodes of Percona XtraDB Cluster with version
Server version: 5.6.19-67.0-56 Percona XtraDB Cluster (GPL), Release 25.6, wsrep_25.6.r4111

i noticed that there is no cached threads

| Threads_cached | 0 |
| Threads_connected | 1366 |
| Threads_created | 3916 |
| Threads_running | 1

in config thread_cache_size = 1024


  • jjhjjh Entrant Inactive User Role Beginner

    I've noticed the same thing. Sometimes restarting mysql or whole server "fixes" thread cache, but not always.
    Any ideas how to debug why this is happening ?

    mysqladmin -r -i 3 ext | grep Threads_created
    Shows that threads are created all the time.


    Is thread_cache_size= and one-thread-per-connection supported or is it better to try w/pool-of-threads ?

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.