mysql scaling questions

[Boris Samorodov]

On Sat, 1 Dec 2007 17:33:34 +0100 Gergely CZUCZY wrote:

> I am using sysbench, with read-write tests.
> The test-table has 10M tuples, and i'm querying it for two minutes.
[...]
> The testbox has a dual opteron 246, 12G of memory and a 3ware-9550 with
> two disks in a mirror for the rootfs (also this is where the mysql datafiles
> were, except for the ZFS setup). The freebsd has mysql-5.0.45_1.

> As you see for the best case linux outperforms fbsd7 around twice,
> this means that i couldn't reproduce jeff@'s results.

3ware driver is under GIANT at 7.x. I don't know if it's the same for
linux.


WBR
-- 
Boris Samorodov (bsam)
Research Engineer, http://www.ipt.ru Telephone & Internet SP
FreeBSD committer, http://www.FreeBSD.org The Power To Serve