I was studying about how and how much memory allocated to each connection thread and found below MySQL tutorial:
http://dev.mysql.com/doc/refman/5.1/en/memory-use.html
There is a point mentioned as below which I am unable to understand.
- When a thread is no longer needed, the memory allocated to it is released and returned to the system unless the thread goes back into the thread cache. In that case, the memory remains allocated.
My concerns are the following:
- Does it mean thread occupied the memory even system is using threads from cache?
- A cache in thread still use memory?