Folks, Following some advices, I have decided to give FreeBSD a shot. So, I got one test machine (P4 2.0GHz, 512MB), installed FreeBSD 5.2.1 on one disk, and OpenBSD 3.5 on the other (both 40GB 7200RPM IDE disks) -- so I could compare the results.
MySQL (4.0.20) is compiled from source, using the very same config options as possible... I have followed the advice from Jeremy Zawadony's site, and compiled FreeBSD using LinuxThreads. With that, everything was pointing out that FreeBSD+LinuxThreads would outperform OpenBSD+pthread. Honestly, I am not sure if the binaries provided by MySQL.com would be a good way to really test this, since they do not offer binaries for OpenBSD 3.5 and FreeBSD 5.2.1. But if needed, I am willing to try everything. I am no test engineer, I can not say that this is 100% accurate, or even if this is the right way to test MySQL performance. Maybe you guys can tell me how to test this better. I have chosen Super-smack for this, using the standard smacks. I have run each test three times in a row, and then, three times with a fresh boot in between. Definitively, I am very impressed with the results -- I can make them available if needed. There is an amazing coherence in those results. And the most amazing thing is: OpenBSD is performing better than FreeBSD! Please, I am not trying to say that OpenBSD is better... the fact is that OpenBSD is not able to handle my database anymore, and I am trying to find another OS. Facing this new scenario, I am going to give Linux a shot -- definitively, this one is going to outperform OpenBSD. Using the same hardware, and the same options (as possible). Does anyone have a hint for this? Again, thanks a lot! Best regards, RV Tec Quick results: OpenBSD 3.5 super-smack -d mysql select-key.smack 50 100000 Query Barrel Report for client smacker1 connect: max=53ms min=33ms avg= 43ms from 50 clients Query_type num_queries max_time min_time q_per_s select_index 10000000 43 7 5686.01 364.867u 217.078s 29:19.04 33.0% 0+0k 104+4io 0pf+0w super-smack -d mysql update-select.smack 50 100000 Query Barrel Report for client smacker connect: max=52ms min=30ms avg= 42ms from 50 clients Query_type num_queries max_time min_time q_per_s select_index 5000000 28 8 2867.73 update_index 5000000 33 8 2867.73 298.203u 171.242s 29:03.84 26.9% 0+0k 104+4io 0pf+0w FreeBSD 5.2.1 super-smack -d mysql select-key.smack 50 100000 Query Barrel Report for client smacker1 connect: max=13002ms min=33ms avg= 10956ms from 50 clients Query_type num_queries max_time min_time q_per_s select_index 10000000 12 0 3811.89 426.858u 518.244s 43:43.59 36.0% 112+502k 4+0io 7pf+0w super-smack -d mysql update-select.smack 50 100000 Query Barrel Report for client smacker connect: max=39ms min=26ms avg= 30ms from 50 clients Query_type num_queries max_time min_time q_per_s select_index 5000000 16 0 1737.15 update_index 5000000 17 0 1737.15 334.275u 374.935s 47:58.63 24.6% 112+501k 57+0io 9pf+0w -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
