Note also there are methods to control loads under MySql. You can use limits from the environment shell to keep the load averages down.
People may say this is not in good form, or style, but it works for me. There are several methods you can use within the my.cnf to streamline the MySql server performance. set-variable = key_buffer=16K set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K If tweaking those doesn't seem to help then limit the shell that MySql is running in. shell>ulimit=4096 shell>export ulimit shell>mysqld restart There are many methods along these lines, so please research it. Also , perhaps the loads are a function of the sql query. You might be able to use a Perl wrapper, and get your loads down. I do this by using sleep within the Perl program. Perform query. sleep 10; perform query. sleep 10; Hope this helps, ~Kelly W. Black -----Original Message----- From: heath boutwell [mailto:heathboutwell@;yahoo.com] Sent: Tuesday, November 05, 2002 7:19 AM To: [EMAIL PROTECTED] Subject: RE: Thread Thrashing and 3.23.53a After a weekend of pretty heavy usuage (150-200 queries per sec) I can say the "thread thrashing" has been fixed with the latest binary. Our load averages however, are still 2-3x what they were with the older binary. Even when mysql isn't being queried at all (when apache is shut down) the load average hovers around 1.3 or so. We never saw load averages higher than 3 or so under max usage with the older binary but we saw 7 or higher over the weekend. Very strange. The end result is that I will either try compiling from source or go back to an older binary since I can't diagnose the cause of the higher load averages. Thanks to everyone on the list for their help and suggestions. __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ --------------------------------------------------------------------- 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
