arjen_lentz: MySQL thread cache
It should be noted however that creating and destroying threads on some platforms is a very very cheap operation. Linux with NPTL (esp on x86) is one such platform.
(even without NPTL on x86 it’s stil pretty cheap).
On PPC with LinuxThreads it’s quite expensive.
On PPC with MacOS X it’s also very expensive.
I think i’ve blogged about this previously.
But users on MacOS X, Windows and Linux without NPTL should certainly consider using the thread cache. Otherwise, if you’re on x86 with NPTL you probably don’t have to bother – or at least you notice a very small benefit.
It’s still extra work. Maybe it doesn’t make a difference to your, but if you’re creating several thousand threads a second when you dont need to, it’s just stupid.
You wouldn’t tell Apache to keep 0 threads hanging around, so why do it with your MySQL.