7/27 I have an actual technical question here. My MySQL DBA tells me
that I can't expect a MySQL port to be able to run effectively
on more than a two CPU box, he says that the extra CPUs will
sit there unused. Is this true? I have a bunch of new quad core
servers that I would like to use as Database machines. -ausman
\_ It's not that simple. If you stress test your new fancy multi core
machine, you'll see that mysql doesn't really use all of those
cores as much as you want. one way to really use everything is
shard your data, and run several instances of mysql on one
machine, then you'll really use all of the cores ! - danh
\_ http://forums.mysql.com/read.php?24,53893,262315#msg-262315
(you can probably get it to use four cores) -tom
\_ I realize MySQL is free, but what a POS!
\_ is this a troll? What do you want? I've had no problem
loading multiple CPUs, yes, you can't have more than one
CPU working a a single SQL query, but this has never been
a problem for me. What do you use?
\_ Have you ever gone beyond 4?
\_ Yes, was not benchmarking and can't be sure how much
more throughput I was getting vs. 4 but I have had 8
cores processing at near 100% utilization.
\_ Well, a modern database should be properly multithreaded.
Oracle and MS SQL Server are. A database that slows
down when you throw more CPUs at it is a POS. |