Emergency

Threads_cached is zero

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Nice post. Thanks for sharing!
    Last edited by scott.nemes; 03-31-2014, 11:00 AM. Reason: Ad

    Comment


    • #17
      Hi All,

      Did any one find out the reason why thread_cached is not working.

      I am also facing the same issue.

      Galera 3 node cluster running on the following version

      Server version: 5.6.15-56-log Percona XtraDB Cluster (GPL), Release 25.5, Revision 759, wsrep_25.5.r4061

      +---------------------+
      | @@thread_cache_size |
      +---------------------+
      | 100 |
      +---------------------+

      +-------------------+----------+
      | Variable_name | Value |
      +-------------------+----------+
      | Threads_cached | 0 |
      | Threads_connected | 48 |
      | Threads_created | 11378557 |
      | Threads_running | 1 |
      +-------------------+----------+

      Thank you,
      Trimurthy

      Comment


      • #18
        I am also facing the same issue after upgrading percona cluster from 5.5 to 5.6.

        Code:
        mysql> show variables like '%thread_cach%';show status like '%threads%';
        +-------------------+-------+
        | Variable_name     | Value |
        +-------------------+-------+
        | thread_cache_size | 300   |
        +-------------------+-------+
        1 row in set (0.00 sec)
        
        +-------------------------+---------+
        | Variable_name           | Value   |
        +-------------------------+---------+
        | Delayed_insert_threads  | 0       |
        | Slow_launch_threads     | 0       |
        | Threadpool_idle_threads | 0       |
        | Threadpool_threads      | 0       |
        | Threads_cached          | 0       |
        | Threads_connected       | 817     |
        | Threads_created         | 8954166 |
        | Threads_running         | 2       |
        +-------------------------+---------+
        8 rows in set (0.00 sec)
        Anyone concluded to something about this?

        Comment

        Working...
        X