Re: Benchmark MySQL Performance On FreeBSD And Linux

2005-12-15 Thread Rink Springer
> And you should disable these options, it may increase ~10% again: > > -cpu I486_CPU > -cpu I586_CPU > cpu I686_CPU A recent discussion on -STABLE warned against removing I586_CPU, refer to http://lists.freebsd.org/pipermail/freebsd-stable/2005-December/02069

Re: Benchmark MySQL Performance On FreeBSD And Linux

2005-12-15 Thread Gea-Suan Lin
Hi, In http://blog.gslin.org/archives/2005/12/12/252/ we test more cases, and summary some important conclusions: * SCHED_ULE (kernel options) is faster than SCHED_4BSD. * Use kern.timecounter.choice=TSC (sysctl) will be faster than ACPI-fast or ACPI-safe. (about 10% again) And I notice you u

Re: Benchmark MySQL Performance On FreeBSD And Linux

2005-12-15 Thread huang leo
hi, I experience the crashes myself. I used super-smack remotely to connect MySQL with 200 clients first. After the test was done and the connections were closed, we connected MySQL with 300 clients immediately. Then the MySQL restarted. The error log of MySQL is: mysqld in free(): error: modified

MySQL Deadlocks (Was: Re: Benchmark MySQL Performance On FreeBSD And Linux)

2005-12-15 Thread Eric Hodel
On Dec 15, 2005, at 8:07 PM, Greg 'groggy' Lehey wrote: On Friday, 16 December 2005 at 11:20:12 +0800, huang leo wrote: We had evaluated MySQL performance on FreeBSD and Linux. The result is attached. Thank you! This is some of the most plausible information I've seen in a while. I'm for

Re: Benchmark MySQL Performance On FreeBSD And Linux

2005-12-15 Thread Greg 'groggy' Lehey
On Friday, 16 December 2005 at 11:20:12 +0800, huang leo wrote: > > We had evaluated MySQL performance on FreeBSD and Linux. The result is > attached. Thank you! This is some of the most plausible information I've seen in a while. I'm forwarding it to a MySQL internal list, and I expect we'll dis