mysql performance test results under FreeBSD-7.0-CURRENT

[Ganbold]

Kris Kennaway wrote:
> On Thu, Mar 30, 2006 at 03:59:05PM +0900, Ganbold wrote:
>   
>> Thyer, Matthew wrote:
>>     
>>> A couple of things I have noticed in the kernel messages:
>>>
>>> 	WARNING: WITNESS option enabled, expect reduced performance.
>>>
>>>       
>> Yes, I left this option in case if there comes something wrong.
>>     
>
> Then your performance numbers are useless, sorry.
>   

I removed WITNESS and INVARIANTS options from kernel and tested again.

http://www.mnbsd.org/ftp/mysql_test_results.txt

I hope it will be useful to someone now.

Ganbold

>   
>>> You need to use the 80 core conductor cables instead of the old standard
>>> 40 core conductor IDE cables to get the best performance from your hard
>>> drives.  Just use another cable like you already have connected to the
>>> 40GB drive.
>>>  
>>>       
>> That is true, I don't have any UDMA100 cables right now:(
>>     
>
> Ditto.
>
> Sorry, but benchmarking is hard.
>
> Kris