|
Did you know that... using a CPU with HyperThreading turned on actually makes your MySQL database server slower?
Reason... Well, with real multi-core or multi-CPU, MySQL's connection threads get nicely spread. With HT it looks like you have multiple cores, but you don't really. This possibly causes more overhead given MySQL's multi-threaded architecture? Perhaps others have more insightful clarifications. Anyhow, HT makes things slower on a MySQL server system. Just turn it off and you'll see!

