Why is MySQL nearly twice as fast on Linux?

[Petri Helenius]

JG wrote:

>
> While the benchmarks are running, gstat basically looks like this:
>
> amd64f# gstat
> dT: 0.502  flag_I 500000us  sizeof 288  i -1
>  L(q)  ops/s    r/s   kBps   ms/r    w/s   kBps   ms/w   %busy Name
>     0      0      0      0    0.0      0      0    0.0    0.0| ad0
>     0      0      0      0    0.0      0      0    0.0    0.0| ad0s1
>     0      0      0      0    0.0      0      0    0.0    0.0| acd0
>     0      0      0      0    0.0      0      0    0.0    0.0| amrd0
>     0      0      0      0    0.0      0      0    0.0    0.0| amrd1
>     0      0      0      0    0.0      0      0    0.0    0.0| ad0s1a
>     0      0      0      0    0.0      0      0    0.0    0.0| ad0s1b
>     0      0      0      0    0.0      0      0    0.0    0.0| ad0s1c
>     0      0      0      0    0.0      0      0    0.0    0.0| ad0s1d
>     0      0      0      0    0.0      0      0    0.0    0.0| ad0s1e
>     0      0      0      0    0.0      0      0    0.0    0.0| amrd0s1
>     0      0      0      0    0.0      0      0    0.0    0.0| amrd1s1
>
> With the exception of a few split-second ticks to the amrd1
> drive (the mysql data drive)
>
Which means that either your dataset fits into the memory you have 
allocated for mysql or your are CPU bound or both.
How does top -H look when running the test?

Pete