Mysql config
I have a single p3 550, 512megs of ram, RedHat 6.2, PHP 4 server and I'm running my msg board off this machine. Well the board is running really slow. This is the top info (I know this is horrible)
7:20pm up 3 min, 1 user, load average: 5.38, 2.66, 1.02
91 processes: 87 sleeping, 4 running, 0 zombie, 0 stopped
CPU states: 23.5% user, 25.7% system, 47.3% nice, 3.3% idle
Mem: 517220K av, 314100K used, 203120K free, 232016K shrd, 7100K buff
Swap: 130024K av, 0K used, 130024K free 209940K cached
(I just rebooted this)
This is the mysql startup I use
/usr/local/mysql/bin/safe_mysqld -O key_buffer=20M -O max_connections=200 -O sort_buffer=4000000 -O table_cache=64 -O record_buffer=4M
Can anyone tell me what I should change
Thanks for answering my questions.... now I'll try to return the favor :)
I would try to change your startup command to the following:
/usr/local/mysql/bin/safe_mysqld -O key_buffer=96M -O max_connections=250 -O sort_buffer=6M -O table_cache=250 -O record_buffer=6M -O join_buffer=6M
Try this for a day or so, then feel free to follow up with how things are going and update 'top' info.
-Chris
#If you have any other info about this subject , Please add it free.# |