Date: Tue, 15 Jun 2004 16:20:38 -0700 (PDT) From: Julian Elischer <julian@elischer.org> To: mike <mike@mike2k.com> Cc: freebsd-threads@freebsd.org Subject: Re: Possible Threading problem with -CURRENT / MySQL? Message-ID: <Pine.BSF.4.21.0406151619180.50415-100000@InterJet.elischer.org> In-Reply-To: <Pine.LNX.4.53.0406141119100.3417@sql01.internal.mikehost.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, 14 Jun 2004, mike wrote: > welcome to our hell. we've been experiencing mysql problems on freebsd 5.x > as well. it sounds like scheduler/threading is to blame but we were not > able to give sufficient or proper motivation to the folks who could > examine this deeper - we even offered $500 cash to whomever stepped up to > help resolve this. > > linux runs almost 2x as fast on the same hardware with no configuring - > and we get nearly the same results running in single CPU mode vs. dual CPU > mode on fbsd... something is definately fubar with the mysql+fbsd5.x > combination. > > You complained about this some time ago and you have still not responded with the information I suggest.. ---- quote from my previous mail--------------- I'm not saying I can help particularly but the problem is that the people who can help are generally not interested in databases.. what needs to happen is for some analysis to be made as to where the time is being spent.. I vaguely remember you saying htat teh cpu was not piegged when you had this problem... You didn't indicate whether the disks were at 100%. to check this you should try running systat -vmstat while noticing the slowdown and try see what is at 100%. if it turns out that you are NOT seeing disk or CPU limitted then the next step would be to take a snapshot of operations using ktrace -d -p (pid) for 20 second followe by krtace -C to turn it off again. then looking at the output may give an idea of what operations are taking too long, and what is waiting on what.. ---------------------------------------------- Julian
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0406151619180.50415-100000>