Please increase process limit

[dinocol]

Hi recently i've been encountering the error 500 recently due to a 25 process limit even though there is an unlimited bandwidth advertised in your plan.. i hope you could increase it..

thanks..

[Keith W]

Bandwidth and the 25 process limit are two totally different things.

The 25 process limit is an acceptable level for shared hosting

[razewander]

And enlarge the limit in the future? to 50 ?

[striddy]

Originally Posted by razewander

And enlarge the limit in the future? to 50 ?

You can pay for a dedicated server and have this feature.

[GatorJacob]

Good Morning!

Unfortunately, this is something that we will not be able to do on our shared servers. The process limit is in place to keep the servers stable. If we raise it, it could cause serious stability issues for everyone on that server.

If you are needing a higher process limit, I would suggest upgrading to a dedicated server:
http://www.hostgator.com/dedicated.shtml

We might even have a few Un-managed servers that you could pick up. (You would have to email sales@hostgator.com for more information on that)

I hope this helps. Have a great day!

[dinocol]

unlimited bandwidth and storage space = BIG HUGE ADS
process limit = too small fine print to be noticed..


If I upgraded to a reseller plan, would there still be a process limit? or just a bandwidth limitation? it seems to be a reasonable upgrade than getting a dedicated server which costs too much $$$

[GvilleRick]

The reseller plans are also shared so the limits are in place. As mentioned in the other thread on this topic the limits are in place to insure server stability for all users on the server. The only solutions for running into the process limits are making sure the code is efficient or upgrading to a dedicated server. At some point sites outgrow shared hosting and the necessary limits on use of computing resources.

[Kelmas]

Originally Posted by GvilleRick

The only solutions for running into the process limits are making sure the code is efficient or upgrading to a dedicated server.

Even if the code is efficient and optimized you might run out process limit if your site has big traffic...

[GvilleRick]

Originally Posted by Kelmas

Even if the code is efficient and optimized you might run out process limit if your site has big traffic...

Exactly, as I mentioned at some point sites outgrow shared hosting. When that happens the only option is to upgrade to dedicated.

[Pazeh]

Reseller account might help you if you have more than one site on the shared account!!

cause on shared account all of your sites (domain) are bound to 25 limit, while in reseller every site (domain) has 25 process limit

[striddy]

Originally Posted by Pazeh

in reseller every site (domain) has 25 process limit

Every cpanel account, not every domain.

[rayminator]

Originally Posted by razewander

And enlarge the limit in the future? to 50 ?

maybe in the near future when they get the new improved servers who knows when might be in 25 to 50 years from now

the process limit is in place for a reason to keep the server from getting to much stress

[GatorDaveC]

A process limit of 25 is plenty. If you have a site that is trying to spawn more then 25 processes then you probably have a problem with your script.

You might have a problem where the script isn't ending, which is usually because of something being poorly coded, or if its fetching a remote URL many times.

The HostGator server currently only has between 3 and 6 processes running since the processes finish very quickly.

[gwyneth]

Originally Posted by GatorDaveC

A process limit of 25 is plenty. ...

The HostGator server currently only has between 3 and 6 processes running since the processes finish very quickly.

Great answer--another for the Grease Monkey set of responses.

[johnb]

Originally Posted by GatorDaveC

A process limit of 25 is plenty. If you have a site that is trying to spawn more then 25 processes then you probably have a problem with your script.

You might have a problem where the script isn't ending, which is usually because of something being poorly coded, or if its fetching a remote URL many times.

The HostGator server currently only has between 3 and 6 processes running since the processes finish very quickly.

I have been getting a 500 error at least once a day lately due to processes>25. I've looked over my code to make sure mysql_connect and mysql_close are being used.

However, I also have phpbb3, addsense and analytics. I was wondering if maybe the google bots are triggering the error?

Also, is there a way (report, error_log) to tell which processes are bad?

[gwyneth]

Originally Posted by johnb

However, I also have phpbb3, addsense and analytics. I was wondering if maybe the google bots are triggering the error?

It's a lot more likely to be phpbb3 mods and addons--which are you running?

[johnb]

I ended up deleting/reinstalling phpbb3 (still with adsense, analytics). I only have one module Topic Extraction (shows last 10 comments on other pages). It's a suspect at this point, I'm keeping a look at the error_log.

It's just frustrating as a resller not to be able to see which processes are running.

//fan of hostgator

[striddy]

Originally Posted by johnb

It's just frustrating as a resller not to be able to see which processes are running.

Using SSH you can run top to see what processes are running.

[GatorRSimoes]

Since you're running phpbb, you might consider using FastCGI. This would almost guarantee a reduction in the number of active processes your account has going at any one time.

Simply add the following line to your document root's .htaccess file (create one if it doesn't exist):

AddHandler fcgid-script .php

[johnb]

Originally Posted by GatorRSimoes

Since you're running phpbb, you might consider using FastCGI. This would almost guarantee a reduction in the number of active processes your account has going at any one time.

Simply add the following line to your document root's .htaccess file (create one if it doesn't exist):

AddHandler fcgid-script .php

Thank you for the help GatorRSimoes. I just put it in and I will let you know if it helps.

[Abomination]

Originally Posted by GatorDaveC

The HostGator server currently only has between 3 and 6 processes running since the processes finish very quickly.

Somehow I find it hard to believe those are your peak numbers. Did you take a glance at what was happening when you typed the post? Check the logs?

I'm using stock vB and am running out of connections with 40 people online, I know they click a lot of buttons, but still. I'm glad I found this thread and now know what I need to do in the future.

[Ren123]

40 seems too low too. My forum (phpBB2) has about 1500 visitors per day (top), and I have not seen the running processes go over 3 as GatorDaveC says also.

[GatorDaveC]

I made a quick script to check how many processes were running on the HG forums each second. Please remember, there could have been processes in between the sleep(1), but this shows you that the processes finish pretty much instantly.

72 people are using the forum at the moment.

Thu Sep 17 12:01:58 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:01:59 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:00 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:01 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:02 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:03 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:04 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:05 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:06 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:07 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:08 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:09 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:10 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:11 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:12 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:13 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:14 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:15 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:16 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:17 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:18 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:19 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:20 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:21 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:02:23 CDT 2009 processes (2) on HG forums
Thu Sep 17 12:02:24 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:25 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:26 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:27 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:28 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:29 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:30 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:31 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:32 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:33 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:34 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:35 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:36 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:37 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:38 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:39 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:40 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:41 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:42 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:43 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:44 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:45 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:46 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:47 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:48 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:49 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:50 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:51 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:52 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:53 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:54 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:55 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:56 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:57 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:58 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:02:59 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:00 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:01 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:02 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:03 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:04 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:05 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:06 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:07 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:08 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:09 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:10 CDT 2009 processes (1) on HG forums
Thu Sep 17 12:03:11 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:12 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:13 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:14 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:15 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:16 CDT 2009 processes (0) on HG forums
Thu Sep 17 12:03:17 CDT 2009 processes (1) on HG forums

Originally Posted by Abomination

Somehow I find it hard to believe those are your peak numbers. Did you take a glance at what was happening when you typed the post? Check the logs?

I'm using stock vB and am running out of connections with 40 people online, I know they click a lot of buttons, but still. I'm glad I found this thread and now know what I need to do in the future.

[Abomination]

Perhaps I was a bit harsh, and I certainly do not know what I am doing.

I ran this through PuTTy:
mysqladmin -u mysqlusername -p var ext ver

And got this, and indeed I have gotten some max connection errors emailed to me.
max_connect_errors: 20
max_connections: 100
max_user_connections: 25
Connections: 1856979
Max_used_connections: 36

Maybe 40 people online at one time, 50K posts, maybe 200-300 posts per day. It is tiny.


But I ran the same command on another forum I own where there are 50 posts total, and a post has not been made in months (don't laugh, I failed on that forum) and I got:
Max_used_connections: 40

Obviously since no one ever uses that forum there have been no errors.

Could someone shed some light on what those numbers mean?

If the Max_used_connections are supposed to mean something, would it be possible to reset that to 0 to watch that over time and get a better idea what may be happening? Maybe through phpMyAdmin? I looked but did not find that anywhere.

Could Max_used_connections be for everyone that uses that server and not just my database?

[quietFinn]

Originally Posted by Abomination

max_connect_errors: 20
max_connections: 100
max_user_connections: 25
Connections: 1856979
Max_used_connections: 36

Yes, the Max_used_connections variable is for the whole mySQL server.

max_connections
The number of simultaneous client connections allowed.

Max_used_connections The maximum number of connections that have been in use simultaneously since the server started.