I have about the same problems as this fellow, having a high swap causing the server load averaged to go up. (running a vBulletin 3 on it)
I have:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) III CPU 1133MHz
Processor #1 speed: 1135.366 MHz
Processor #1 cache size: 256 KB
Memory Information
Memory: 509632k/523136k available (1269k kernel code, 11052k reserved, 90k data, 220k init, 0k highmem)
This is my current my.cnf setting
[mysqld]
set-variable = max_connections=300
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=2M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=64
set-variable = wait_timeout=1800
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
Anyone has any suggestions of this is correct?
I have:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) III CPU 1133MHz
Processor #1 speed: 1135.366 MHz
Processor #1 cache size: 256 KB
Memory Information
Memory: 509632k/523136k available (1269k kernel code, 11052k reserved, 90k data, 220k init, 0k highmem)
This is my current my.cnf setting
[mysqld]
set-variable = max_connections=300
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=2M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=64
set-variable = wait_timeout=1800
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
Anyone has any suggestions of this is correct?