VPS Upgrade or Optimization

This forum was started back in 2006. Over the years, it has grown enormously that in one time, 500+ users were online. Current statistics indicate that there are


936239 Posts
18839 Topics
19075 Members

The forum has been moved from one web host to another as it has outgrown its hosting requirements.Currently it is being hosted on a VPS with the following specs


Dedicated RAID-10 Disk Space 30 GB
Dedicated Monthly Bandwidth 300 GB
Dedicated DDR3 RAM 256 MB
Burstable DDR3 RAM 512 MB
Shared CPU x4 3.00+Ghz

A couple of weeks back, the web host has suspended the VPS as it allegedly overloading the server using more than its burstable memory allocation. The web host wants that the VPS be optimized or upgraded.

Help from web hosting forums suggest that the VPS need to be upgraded into at least 1 GB of dedicated memory. That is an expensive option thus must be the option. First, server optimization must be implemented.

The optimization are as follows:
1. Switch from Apache to LightTPD - Memory usage reduction 35-40%
2. Optimized MySQL by changing the default configuration - Memory usage reduction 30%

Now to memory usage varies from 15% to 40% depending on the number of online users. Another optimization being done is to reboot the server at least once every two days.

The MySQL configuration used is shown below (my.cnf):


[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
skip-bdb
skip-innodb

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

About the Author

Ver Pangonilo
A Filipino Engineer, Registered Professional Engineer of Queensland (RPEQ) - Australia and Professional Electrical Engineer (PEE) - Philippines with extensive experience in concept select, front-end engineering, HV & LV detail design, construction and commissioning of Hazardous and Non-Hazardous Area electrical installations in water and waste water pipeline and pumping facilities, offshore platforms, hydrocarbon process plants and pipelines including related facilities. Hazardous area classification and design certification (UEENEEM015B, UEENEEM016B, UEENEEM017B).
Facebook Auto Publish Powered By : XYZScripts.com