Jan Klerks

Member
Mar 30, 2004
6
0
151
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?
 

anand

Well-Known Member
Nov 11, 2002
1,433
1
168
India
cPanel Access Level
DataCenter Provider
Originally posted by Jan Klerks
Any examples? Thanks,
You wrote it yourself ;)

[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M


Reduce the above values and see. Most of the time these values need to be tested where it is being implemented depending on the mysql load.
 

cronjob78

Member
Feb 24, 2004
14
0
151
I had a problem like this with a phpBB message board and was going to upgrade to vBulletin as I thought the problem was specific to phpBB. vBulletin say the minimum amount of RAM you should have is 1GB. I had 128 MB so upgraded in preparation for the change over last week.

The server is running fine now and the load rarely gets near 1.0. The messag eboards are never slow. It costs about $40/month for the extra RAM for me but its worth it. Do it and let us know how you get on. I might even go for 2GB.
 

fishfreek

Well-Known Member
Jan 2, 2004
238
0
166
A gig of ram should be the minimum for hosting active database intensive websites.