Hi Ken I have had a look on FreeBSD.org and can only find a ref to polling as a subroutine that is used if the system crashing. What douse this number? And so how will it effect MySQL? Thanks Simon
-----Original Message----- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: 16 July 2002 16:07 To: Oleg Borodkin; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL FreeBSD LinuxThreads Hi Oleg, I have similar problems on FreeBSD with one or two slow queries hogging the CPU. I am running native threads. I am looking at a parameter in the kernel (/usr/src/sys/i386/conf/LINT). It is the HZ parameter and has to do with polling frequency. The default is 100, I am experimenting with values from 1000 to 5000. You might give this a try. You will need to build a new kernel. I am not sure this will have any effect on MySQL. This is only a suggestion. Best of Luck, Ken ----- Original Message ----- From: "Oleg Borodkin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 15, 2002 3:24 PM Subject: MySQL FreeBSD LinuxThreads > Hello, > > I have noticed that MySQL server almost hangs up the system while > processing a big table (perl script using fetchrow). > I didn't experienced this before - may be it's because of LinuxThreads? > > MySQL launches 38 running processes, but shows only 10 mysql query > threads (they are all sleeping except 2 or 3). > > Thanking you in advance, > Oleg Borodkin > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
