In the MySQL 5.7 manual, I read that the thread cache has a size determined by the
thread_cache_size system variable.
The default value is 0 (no caching), which causes a thread to be set up for each new connection and disposed of when the connection terminates.
But what exactly is a "thread"?
A connection thread becomes inactive when the client connection with which it was associated terminates.
Again, I can't understand what is a "thread" that I'm reading about.
Threads_created: The number of threads created to handle connections.
What the word "thread" refers to in this case?
Threads_cached: The number of threads in the thread cache.
Again this word "thread".
Threads_connected: The number of currently open connections.
I can't understand what is a thread. It is not connection I guess...
But what is it? Maybe it's only a matter of translation in my language, but I can't make up my mind to understand what is a "thread"