So. As it is known, mysqld it “one process – is a lot of threads”.In approached enough understanding thread it when process copies itself, and parental process transfers to threads what that a task for the decision.
Creation thread differs from usual fork () basically that fork generates +1 process whereas division on threads uses other, more productive technology of branching without cloning of the data in memory.
At each connection of the client, mysql creates thread which this connection processes.
“Optimization and tuning of the threads in MYSQL.”Continue reading