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
