Hi Joe, I'm actually going through this same issue on 4.5 box right now running Mysql max.. i've submitted ticket into support @ mysql since i bought it.. I guess this seems to be common thing in Bsd Hope we can all figure whats wrong with it.. -Frankie
----- Original Message ----- From: "Joe Maimon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 9:28 AM Subject: Mysqld runs with high cpu load on freebsd 4.4 > Hey All, > > We recently picked up a box running a web site with mysql on freebsd. > The cpu load gets pegged high realy quickly under its normal load. This > wasnt always the case.My designers do not believe it to be the queries > shown in the slow query log, which return quickly on development > platforms (winnt) and appear to be highly optimized. I have tried the > port version, a compiled from source version, and the binary off the web > site. > > The system is a PIII 800 with 1G RAM. > > While soaking the cpu, the mysqladmin processlist return minimal > activity happening. The mysqld spends most of its time in the poll > stage. Disk I/O seems minimal. The web site response slows down > considerably. > > Restarting the mysqld daemon puts the load back down, but within minutes > its bouncing back up there and after about an hour it stabilizes at ~70 > percent or higher. > > This is the contents of the my.cnf I have been playing with. I havent > seen much performance difference no matter what values I put in here. > > [mysqld] > #port = 3306 > #socket = /tmp/mysql.sock > skip-locking > set-variable = max_connections=100 > set-variable = key_buffer=512M > set-variable = max_allowed_packet=2M > set-variable = table_cache=1000 > set-variable = sort_buffer=32M > set-variable = record_buffer=4M > set-variable = myisam_sort_buffer_size=92M > set-variable = thread_cache=32 > set-variable = tmp_table_size=128M > #set_variable = log-slow-queries > # Try number of CPU's*2 for thread_concurrency > set-variable = thread_concurrency=6 > log-bin > server-id = 1 > > Has anyone come across a freeBSD 4.4 issue - possibly with the thread > library? Short of putting in a test box, is there a conclusive way to > determine that its the queries/configuration causing this not the box? > > Joe > > > --------------------------------------------------------------------- > 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
