MySQL dual proc?

[csousley]

Does anyone know if MySQL is built multi threaded? Will it take advantage of a second processor?

I know I could probubly find this answer if I looked long enough, but I'm on a deadline. So I apologize if this is covered in MySQL docs...

Thanks

-Cy

[Sxooter]

Yes and yes.

However, you don't need to be multi-threaded to support more than one processor. Postgresql is multi-process not multi-threaded, but can easily use >1 processor. The only requirement is that you need to be issuing more than one query at a time to use that second processor.

[[deleted]]

" The only requirement is that you need to be issuing more than one query at a time"

In other words: an OS that can handle multi-cpu machines will distribute the workload across it's available CPU's automatically. Any program that can devide it's own workload into sub-processes (mysql,postgres, apache etc) will find it's processes distributed across all available CPU's by the OS.