Re: How scaleable is MySQL 5's Innodb with multi-core CPU's?

2007-01-04 Thread Sid Lane
what do you consider a high number of updates/sec? I'm the DBA for a popular website in that league (well, maybe not google or yahoo but certainly ticketmaster) and we average ~210 DMLs/sec with peaks in excess of 1,000. we use a mixture of myisam for static (or infrequently updated) reference t

Re: How scaleable is MySQL 5's Innodb with multi-core CPU's?

2007-01-02 Thread Jochem van Dieten
On 1/1/07, mos wrote: At 12:49 PM 1/1/2007, Jochem van Dieten wrote: >On 1/1/07, mos wrote: http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/ http://tweakers.net/reviews/649/6 Has this been fixed? As the article on the MySQL Performance Blog mention

Re: How scaleable is MySQL 5's Innodb with multi-core CPU's?

2007-01-01 Thread mos
At 12:49 PM 1/1/2007, Jochem van Dieten wrote: On 1/1/07, mos wrote: Is there a problem with InnoDb scaling with multi-processor CPU's? Apparently after reading the Tweakers.net article, with only 40 simultaneous users the performance of MySQL 5 will collapse. http://www.mysqlperformanceblog.

Re: How scaleable is MySQL 5's Innodb with multi-core CPU's?

2007-01-01 Thread Jochem van Dieten
On 1/1/07, mos wrote: Is there a problem with InnoDb scaling with multi-processor CPU's? Apparently after reading the Tweakers.net article, with only 40 simultaneous users the performance of MySQL 5 will collapse. http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-

How scaleable is MySQL 5's Innodb with multi-core CPU's?

2007-01-01 Thread mos
Is there a problem with InnoDb scaling with multi-processor CPU's? Apparently after reading the Tweakers.net article, with only 40 simultaneous users the performance of MySQL 5 will collapse. http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/ http://t