Date: Sun, 01 Jan 2006 22:24:30 +1100 From: Michael Vince <mv@roq.com> To: huang leo <leo.huang.gd@gmail.com> Cc: freebsd-performance@freebsd.org Subject: Re: Benchmark MySQL Performance On FreeBSD And Linux Message-ID: <43B7BBEE.5020701@roq.com> In-Reply-To: <a0cd7c070512151920s67ca6cd6h@mail.gmail.com> References: <a0cd7c070512151920s67ca6cd6h@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
huang leo wrote: >Hi, all: > >We had evaluated MySQL performance on FreeBSD and Linux. The result is >attached. > >We are longing for your feedbacks! > > >Best regards, > >Leo Huang > Really good work. I gave your results some thought and was thinking that maybe you should check to see if you reached the default 1500 threading limit of libthr and maybe it needs to be increased, I set mine to 40000 like below. kern.threads.max_threads_per_proc=40000 kern.threads.max_groups_per_proc=40000 I was thinking it would be good to show threading usage activity with some kind of 1 second loop doing ps -auxwH | grep -c 'mysql' or something like that so we could see what limits its getting to, and so I can have an idea of what I can compare it to on my own servers. Just a suggestion. Regards, Mike
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?43B7BBEE.5020701>