I’m hoping someone from this forum to help me quick solve our server problem.
Long story short, our old DB admin/designer leave our company last year. And since then we don’t really have a DB admin.
Which is fine, at least the server is running all good without him till few weeks ago. All the queues takes 10 to 20 times longer to get get result.
I’m guessing the config need some kind of fine tune after a year.
Please feel free to let us know what we need to do.
The server is still on a P4 631 with 2G ram. Linux 2.4.20-8. MySQL 3.23
About 4G data, tables range from 300MB to 1MB.
Read/Write ratio is 0.002
Here’s the setting:
# The MySQL server
port = 3306
socket = /var/lib/mysql/mysql.sock
set-variable = key_buffer=384M
set-variable = max_allowed_packet=3M
# Modified on 2007-10-23
#set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
server-id = 1
log-update = /home/mysql/log/mysqllog
Point the following paths to different dedicated disks
#tmpdir = /tmp/
Remove the next comment character if you are not familiar with SQL