Why is MySQL nearly twice as fast on Linux?

JG amd64list at jpgsworld.com
Sat May 22 13:56:04 PDT 2004


At 08:48 PM 5/22/2004 +0300, you wrote:
>JG wrote:
>
>>
>>>It would be interesting if mysql is cpu-bound or disk bound in your 
>>>tests and if disk-bound
>>
>>
>>
>>Anyway, I would be happy to do some disk I/O benchmarks as well.
>>
>>What program would you suggest for testing on both OS's ?
>I was more suggesting toward running gstat when the mysql benchmark is 
>running.
>
>Pete


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)







More information about the freebsd-threads mailing list