[induslady]

Hello,

Sorry for coming in with my issue. I too need expert advice from forum runners here on solving the issues I face running my forum site on a VPS.

I originally was on a shared server with Startlogic, received MySQL database errors like max_resources exceeded and too many connections, etc.

Then moved to a VPS server with Liquid web. This server runs only 20 instances including mine. I don't receive database errors now. But of-late my server has been spiking with load issues. I keep getting httpd service failures frequently (every hour) that causes the site to on and off displaying 'This page could not be displayed' error in the browser.

My host keeps saying that I am overloading the server.

I want to know the following:
1. What is the variable or combination of variables that they see to tell the server is loaded and it is causing the httpd to fail?
2. Is it the number of visitors peaking that causes server load?
3. Is it the number of queries or browser requests that peak causing server load?

I am not able to believe that I need a dedicated server with more RAM/CPU because I see more bigger boards (with >1 million posts and >100,000 members and > 500 simultaneous active users) being run well on VPS server with similar configurations as given below.

Please look into my site statistics, server config, system variables set-up given below and let me know what is going wrong. What is that I need to watch to understand about what is causing the server load?
--------------------------------------------------------------------------------------------------------
Here are my site stats:

Threads: 10,749, Posts: 145,561, Members: 11,156
Most users ever online was 301, 14th September 2007 at 04:28 PM.
Currently Active Users range: 100 - 350
(25% would be users and 75% guests)
Guests - mostly are Google spider, Yahoo spider, MSN bot, etc.

Here are my server config:
VPS 1 server and it has 20 instances
cpu speed/type single or dual cpus): Dual CPU Dual Core
how much memory installed: 8GB of RAM.
384MB is guaranteed for me.
hard drive type/configuration: SCSI RAID 5
linux distributor version: CentOS 4.4
apache/IIS version: apache 1.3.37
PHP version: php 4.4
MySQL version: mysql 4.1

I am currently running vb 3.6.3 and vbSEO 3.0.1c (non-encrypted version of SEO)
I have less than a handful of hacks installed from here which are mostly template customizations

I also placed a server optimisation request in vbulletin.com and changed my.cnf settings accordingly. The my.cnf settings are as given in the below post:
http://www.vbulletin.com/forum/showp...78&postcount=9

I have wait_timeout - 28800

These are the settings in httpd.conf
KeepAlive: On
MaxKeepAliveRequests: 100
KeepAliveTimeout: 1
MinSpareServers: 10
MaxSpareServers: 15
StartServers: 10
MaxClients: 150
MaxRequestsPerChild: 1000

My server's recent top stats is as given in this post:
http://www.vbulletin.com/forum/showp...8&postcount=29

--------------------------------------------------------------------------------------------------------

Please help me with troubleshooting my server load issue.

I am also keen to know if there is someone available on a hourly pay basis to take a look at my server and optimize it to run my forum board without issues. I can hire their service for once to take a look at what's happening and set things straight.

Thank you. Appreciate responses.