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
