Server overload problems

[Jan Klerks]

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]

you could try by lowering the buffers.

don't forget to restart mysql after that for the changes to take effect.

 

[Jan Klerks]

Any examples? Thanks,

 

[anand]

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]

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.

 

[Jan Klerks]

Yep, upgrading server sure did the trick.

 

[fishfreek]

A gig of ram should be the minimum for hosting active database intensive websites.