Home / server / Questions / 1149836
Accepted
kylex
Asked: 2023-12-15 15:46:20 +0800 CST

DigitalOcean managed MySQL 8 database has massive amount of "threads created"

  • 772

I've read and re-read DO's description of threads created and can't for the life of me figure out what's going on. Is this really implying that 650000 threads are being created every second? That can't be right.

Someone help me decipher what this graph implies please.

enter image description here

digital-ocean

1 Answers

  1. Best Answer

    "Threads created" is a standard status value MySQL servers provide.

    The number of threads created to handle connections. If Threads_created is big, you may want to increase the thread_cache_size value. The cache miss rate can be calculated as Threads_created/Connections.

    As far as I know is not per second but rather an incremental "counter" that (re-)starts at zero whenever MySQL is started and then only increases (like the odometer in a car) and not a "gauge" that goes up and down whenever load changes (like the speedometer in car).

    A really large number of "threads created" and a steeper incline would suggest a more heavily loaded database with numerous new and/or concurrent connections and many active queries. The server can't re-use existing threads and must actively create new ones. That has a performance penalty.

    When the number of "threads created" increases more slowly, a large value could maybe also suggest that it has been a long time since the MySQL server was last restarted.

    • 2