Re: mysql benchmarks

2005-12-13 Thread Jin Guojun [VFFS]
Peter Pentchev wrote: On Fri, Dec 09, 2005 at 08:05:37PM -0800, Jin Guojun [VFFS] wrote: David Xu wrote: Gustavo A. Baratto wrote: Since the last post just had freebsd numbers, I'm re-posting it including Linux as well. Both linux and freebsd numbers were taken from the same

Re: Benchmark for MySQL 5.0 + FreeBSD 6-STABLE

2005-12-13 Thread Ivan Voras
Gea-Suan Lin wrote: 3*2*2*2 = 24 cases: I made a reference to your results in http://wikitest.freebsd.org/moin.cgi/MySQL I hope it's ok. ___ freebsd-performance@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-performance To

[LONG] vmstat: What I/O is blocked and how to fix it?

2005-12-13 Thread Mark Bucciarelli
[Originally sent to freebsd-questions, then I remembered this list (to which I am not subscribed, so please CC me on any replies.] m --- Begin Message --- On two occasions recently, vmstat has showed me that a number of processes are blocked due to I/O. At the same time, the number of disk tra

Re: mysql benchmarks

2005-12-13 Thread David Xu
Peter Pentchev wrote: So, if both systems use gettimeofday, then slow may be somewhere else. E... I think David might have meant that the original poster should simply set kern.timecounter.hardware to 'TSC', not i8254 or something else. This would not change whether MySQL uses getti

Re: mysql benchmarks

2005-12-13 Thread Peter Pentchev
On Fri, Dec 09, 2005 at 08:05:37PM -0800, Jin Guojun [VFFS] wrote: > David Xu wrote: > > >Gustavo A. Baratto wrote: > > > >>Since the last post just had freebsd numbers, I'm re-posting it > >>including > >>Linux as well. Both linux and freebsd numbers were taken from the > >>same box: > > > > >

Re: Benchmark for MySQL 5.0 + FreeBSD 6-STABLE

2005-12-13 Thread Gea-Suan Lin
Hello, I put text file in: http://files.gslin.org/Misc/mysql5-freebsd6-bench.txt And... I'll try to modify the theme :) On Tue, Dec 13, 2005 at 08:41:48AM +1030, Greg 'groggy' Lehey wrote: > On Monday, 12 December 2005 at 12:59:32 +0800, Gea-Suan Lin wrote: > > 3*2*2*2 = 24 cases: > > > > # Comp