arjen_lentz: MySQL thread cache

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.

One thought on “arjen_lentz: MySQL thread cache

  1. 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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.