firewire
Fri 8th Feb '02, 6:40pm
We have upgraded our dedicated mysql server to 1 GB RAM.
I was wondering if we could tweak the mysql settings to optimize performance. There are 81 processes running (it's ok, persistent connections enabled, forum is quite busy :) ). CPU usage is always low (up to 30% during rush hours, P3-500)
RAM stats:
sql:~ # free -m
total used free shared buffers cached
Mem: 753 740 12 0 4 532
-/+ buffers/cache: 204 549
Swap: 133 0 133
Current setting is:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer=64M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=8M
set-variable = net_buffer_length=32K
set-variable = myisam_sort_buffer_size=8M
set-variable = join_buffer=6M
set-variable = record_buffer=6M
set-variable = table_cache=1024
set-variable = max_connections=300
set-variable = thread_cache_size=128
#log-bin
server-id = 1
Thanks for your advice :)
I was wondering if we could tweak the mysql settings to optimize performance. There are 81 processes running (it's ok, persistent connections enabled, forum is quite busy :) ). CPU usage is always low (up to 30% during rush hours, P3-500)
RAM stats:
sql:~ # free -m
total used free shared buffers cached
Mem: 753 740 12 0 4 532
-/+ buffers/cache: 204 549
Swap: 133 0 133
Current setting is:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer=64M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=8M
set-variable = net_buffer_length=32K
set-variable = myisam_sort_buffer_size=8M
set-variable = join_buffer=6M
set-variable = record_buffer=6M
set-variable = table_cache=1024
set-variable = max_connections=300
set-variable = thread_cache_size=128
#log-bin
server-id = 1
Thanks for your advice :)