Jochem van Dieten wrote: > On 12/19/06, David Sparks wrote: >> I noticed an interesting benchmark at tweakers.net that shows mysql not >> scaling very well on hyperthreading and multicore cpus (see links at end >> of email). >> >> Does anyone know what engine they are using for their tests? (Innodb, >> myisam, berkdb heheh) > > InnoDB, the first installment of the series of tests had the following > configuration: http://tweakers.net/reviews/620/2
I don't see where they say what engine they use, I just see that they slightly tuned up a few Innodb parameters. They also tuned up myisam parameters so the configuration section doesn't really answer that question. > And I would venture that these results are not because they did > horrible things to their MySQL configuration. On the second > installment of the series http://tweakers.net/reviews/633/7 engineers > from Sun were brought in and they consulted with engineers from MySQL > and on the last installment Peter Zaitsev of the MySQL Performance > Blog did a review of their configuration: > http://tweakers.net/reviews/660/6 So its confirmed that mysql has serious problems scaling on concurrent hardware (both hyperthreading, multicore, and multiple cpu). This sucks ... our newest DB server is 2x dualcore. ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]