Re: Multiprocessor boxes, was cluster 'solutions' for openbsd

[Lars Fricke <lars_(_dot_)_fricke_(_at_)_web_(_dot_)_de>]

> A query that took 7 seconds on the 1-CPU box took
> only .7 seconds on the 2-CPU box.

Well, there has to be another reason for the Performance boost. If there is not an serious programming error in MySQL you should not get a 1000% boost using 2 CPUs instead of one. 

Would it be possible for you to test the FreeBSD-box with one CPU for comparison? 

Did you use the same software environment in both boxen? Same MySQL, same keys(index) for the tables? Does EXPLAIN SELECT... show the same execution plans for the queries?

I have some experience with *err* MSSQL on different platforms and _very_ often a bad performance has its reasons in a suboptimal database design or a bad choice of indexes or too much normalisation. 

Even 700ms execution time on your hardware seems _a lot_ for me. Perhaps you should check your queries if there is not a dumb table scan because of a forgotten index involved.

But perhaps you have done that already. just my 2c ;)

> it's not OpenBSD that's running it anymore.
> (I still use 100% OpenBSD on our other 20 boxes 
> around the office, fileservers, webservers, etc.)

You also feel the need to apologize using other tools? sweet ;)

Ciao,

Lars

-- 
Lars Fricke
tip:  http://www.openbsd.org