On 01/01/06, Michael Vince <mv@xxxxxxx> wrote:
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
Well sorry if I am completely wrong here, but that test seems to indicate
there is a general stability problem with libpthread. My own experience
backs up their results since on a production web server with heavy forums I
have had mysql lockups until I tinkered with the threading settings.