Server Using Swap... Why Is That?
I'm on a new server with the following specs:- P4 2GHz
- 1 GB RAM
- 80 GB 7200RPM Drive
- RH Linux 7.2
- PHP 4.3.0
- MySQL 3.23.41
Recently the server would get slow for brief moments so I SSH'd in and checked out top and saw this:
Code:
2:09pm up 3 days, 20:28, 1 user, load average: 0.48, 0.68, 0.63 133 processes: 130 sleeping, 3 running, 0 zombie, 0 stopped CPU states: 26.7% user, 6.0% system, 0.0% nice, 67.2% idle Mem: 1031184K av, 1016808K used, 14376K free, 0K shrd, 78936K buff Swap: 1044216K av, 5236K used, 1038980K free 802480K cached
Here's my my.cnf:
Code:
[mysqld] port = 3306 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking set-variable = max_connections=450 set-variable = key_buffer=16M set-variable = myisam_sort_buffer_size=64M set-variable = join_buffer=1M set-variable = record_buffer=1M set-variable = sort_buffer=2M set-variable = table_cache=1024 set-variable = thread_cache_size=256 set-variable = wait_timeout=9600 set-variable = connect_timeout=10 set-variable = max_allowed_packet=16M set-variable = max_connect_errors=10 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] open_files_limit=8192 err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout
http://www.evolutionm.net/dbstats.php
Thanks,
Mark