MySQL on GNU/Linux appears to be able to either run multiple processes, or one process and multiple threads. We've noticed a significant CPU penalty for multiple processes, probably from the context switching overhead. The trouble was, one of our servers wouldn't use threads; it wanted to use multiple processes. This article explains how we got it to use threads instead.
Jul
17
2006