getting kicked off my server after 1 day of launch!

[Sarge]

Guys I run a fairly large site, and I pay 99 dollars a month for service, plus 3 x15 for 15 domains I have parked and host.

I am hosting with Burst.net, and they are decent.... been with them for 1 year

They said my server load was 110

I only use 20 gb traffic a month and the server has dual pentinum 3 5xx processors with 512 of ram

MY board only has 1100 members and tops online counts 0f 110 users at once

After 1 day of switching from my ubb to vbulletin they said I was using too much mysl and I needed a dedicated server! How is this??

I cannot believe my site would need a dedicated server!
WTF? The host has 25 other accounts on this server, and how could mysql be messing things up that bad??

I am pissed. I can't afford a dedicated server. What can my host do to fix this?

[Sarge]

I only get about 500,000 page views a month BTW

[Freddie Bingham]

Considering what sort of machine the MySQL is running on (and how it is configured), 110 users can bring it down. If they expect to share this server with 25 users than you won't be able to have 110 users online. 110 users is definately in the area where a dedicated server may be needed. If you can't afford it than perhaps look to share with a couple other forum owners who also have similiar traffic. A strong machine could handle 300 (and up) users with no problems.

[JWS]

Hmmm.... I run on one of HostPro's Freedom 500x accounts and I consistently have about 120-130 users online (our max has been 170). The machine I'm on has about ~20-30 smaller-account users and 5 Freedom 500x user accounts. We usually sail along at around .5-1.7 for a CPU load and have a pretty amazing response time when loading pages.

We've got roughly 4000 users and about 183,000 posts. The machine that we're on is a Dual Pentium III 600 with 1GB of RAM.

Originally posted by freddie
Considering what sort of machine the MySQL is running on (and how it is configured), 110 users can bring it down. If they expect to share this server with 25 users than you won't be able to have 110 users online. 110 users is definately in the area where a dedicated server may be needed. If you can't afford it than perhaps look to share with a couple other forum owners who also have similiar traffic. A strong machine could handle 300 (and up) users with no problems.

[Martin]

freddie and I share a server that peaks out at over 200 users for several hours at a time, plus freddie runs an IRC/Java chat on his site and the load is rarely over 0.80

our machine is a bit beefier than that, but there's not a reason in the world that your server should be over that unless they have a lot of other people on it running server intensive software or they have the configuration totally screwed.

with that many concurrent users, though, most people are not going to allow you to host without a dedi-server.

which version of vB are you running, and what versions of PHP and mySQL are they running?

If they are running the latest of both, you should try upgrading to 2.0.0 and turn persistent connections off in the config.php. this should help out some in decreasing the server load and the load on mySQL.

[Sarge]

We are both using the latest software.
I am using 2.0 beta 3

The other 25 accounts also use mysql.... so maybe that is the problem.

I don't regret switching from my ubb, but my ubb never caused havoc on my server like this

[thewitt]

Are you using the connect option or the pconnect option for database connectivity? I was using pconnect and my ISP screamed at me. My MySQL connection was never going away, so they considered me a bad citizen. I've changed to connect and now I'm a good server citizen again - at least for a while.

[Nicholas Brown]

Originally posted by thewitt
Are you using the connect option or the pconnect option for database connectivity? I was using pconnect and my ISP screamed at me. My MySQL connection was never going away, so they considered me a bad citizen. I've changed to connect and now I'm a good server citizen again - at least for a while.

*lol*

[Sarge]

Originally posted by thewitt
Are you using the connect option or the pconnect option for database connectivity? I was using pconnect

I have no clue.. I did a basic install...etc


How to I check and change it ot the connect option??
Thanks in advance

[Martin]

as I said in my ealier post, look in config.php for the pconnect option (towards the bottom) and set it to 0

[Sarge]

Thanks I just changed it!

[thewitt]

You might also need to kill the persistent process.

Try running:

$ mysqladmin -uuser -ppass processlist

Where user and pass are your username and password.

If there is a large value in the "Time" field, you might want to kill that process with:

$ mysqladmin -uuser -ppass kill id

where ID is the reported ID of the persistent database connection from the processlist command.

This will disconnect your persistent connection from the database. All new connections will exit when they are finished.

Good luck,

-Tim

[White Knight]

I just wanted to thank everyone for explaining the pconnection. I have just lowered my cpu usage from 1.00 to .40.. i love it.. thanks so much

I wish there was a area to find tricks on speeding up the server and cpu usage

[YellowKard]

You said after 1 day you got kicked off, mabey it was because of the switch you were using a whole bunch of CPU on the server, are you sure it wouldn't have settled down?

[PimpDaddy1]

Originally posted by Martin
as I said in my ealier post, look in config.php for the pconnect option (towards the bottom) and set it to 0


Hey what does this do? Why should we do and is there any reason why is it set to "1" in the default configuration?

Thanks for your help.

[Martin]

with a beefy server with a medium sized vB, pconnect is the preffered option. it reduces the number of connections to the mySQL database, but it also increases your load slightly.

the reason the switch was put in was because a lot of hosting companies don't allow for persistent connections and this lets people set it for virtual accounts without having to change the code.

[thewitt]

I suspect that my ISP does not recognize the difference between a persistent connection to the database and a problem with an account. I think this persistent connection is simply one of the red flags they use to determine that an account is a poor citizen. I do not believe that pconnect from my test environment caused any performance problems on the server at all. I changed it though, and I'll do as they ask and keep it that way.