Do you have a question? Post it now! No Registration Necessary. Now with pictures!
February 15, 2006, 4:15 am
rate this thread
server.Here are my specs
Dual P4 2.8G
Redhat Ent. Linux 3 ES
mysql verson 3.23.58
Here is what I have in my /etc/my.cnf (I found these settings in a
set-variable = thread_cache=128
set-variable = thread_concurrency=4
set-variable = myisam_sort_buffer_size=64M
set-variable = key_buffer=784M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
I often see the cpu usage above 80% when running top. Can someone
suggest what I need to tweak in order to help this poor server out? I
run a clan website for gaming and rarely have more than 100 people on
at a time, most times it is less than 50.
I am not a mysql guru, I am a network guy, so be gentle.
- » Why does GROUP_CONCAT() function fail in MySQL 4.1.12 in this query?
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum