Arcen Games
Other => Website Support => : Cyborg April 15, 2016, 10:59:59 PM
-
It's taking me forever even to post a message. Not happening at other sites.
-
I am aware of the issue and am working to get it resolved. (Wow that sounds like the super canned response that you get from the big companies)
-
Been bugging me today, too. I tried to fix it but failed. Quinn seems to have gotten it, though, now. :)
-
Let me know if you're still having issues with the site's speed though! :)
-
I am aware of the issue and am working to get it resolved. (Wow that sounds like the super canned response that you get from the big companies)
That is the canned response (except it's we're aware). Suggesting feigned ignorance of issues existence and denial it ever happens ( wait, that's canned too :/)
-
You are now banned for discontent. Wait, that's not right either. ;)
-
I can confirm that the website is running slower, but it is improved compared to what it was before.
-
There are some speed variations. Currently running very slow.
-
Very...slow.
-
Posting is a chore since things are running really slowly.
-
Y...e...s... I... ag...r...ee...
I am not sure what is going on.
-
I suppose I could mention that I've had a few Cloud Flare "site is not responding" pages. Only about four since this thread was started, but non-zero.
-
As at least a temporary measure, I've doubled the size of the hard drive of the vm, and doubled the ram. Doesn't seem to be helping much if at all, though. :/
I think maybe the databases are running slow for some reason, I'm not sure. That's just the only thing I can figure.
-
Well, I just can't win. For now, the wiki is down... because reasons. I'm really not sure.
this is the contents of the error log:
[Wed Apr 20 15:04:13 2016] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Wed Apr 20 15:04:13 2016] [notice] Digest: generating secret for digest authentication ...
[Wed Apr 20 15:04:13 2016] [notice] Digest: done
[Wed Apr 20 15:04:13 2016] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.6.20 mod_ssl/2.2.15 OpenSSL/1.0.1e-fips configured -- resuming normal operations
[Wed Apr 20 15:04:18 2016] [error] server reached MaxClients setting, consider raising the MaxClients setting
I think that last one is the culprit. I checked our httpd.conf file, and found this for our settings:
<IfModule prefork.c>
StartServers 1
MinSpareServers 1
MaxSpareServers 5
ServerLimit 10
MaxClients 10
MaxRequestsPerChild 4000
</IfModule>
<IfModule worker.c>
StartServers 1
MaxClients 10
MinSpareThreads 1
MaxSpareThreads 4
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
I did some googling, and that seemed super low. So I switched over to this:
<IfModule prefork.c>
StartServers 1
MinSpareServers 5
MaxSpareServers 10
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 10000
</IfModule>
<IfModule worker.c>
StartServers 3
ServerLimit 16
MaxClients 5000
MinSpareThreads 50
MaxSpareThreads 250
ThreadsPerChild 50
MaxRequestsPerChild 10000
</IfModule>
That seemed to work! ...kinda.
Longer wiki pages were coming up without formatting, but they were at least coming up. The forums were maybe a tiny bit speedier, I'm not sure. Mantis and wordpress were still slow as molasses. But, worse, I started getting these errors on mantis whenever clicking into a ticket:
APPLICATION ERROR #400
Database connection failed. Error received from database was #1040: Too many connections.
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
Previous non-fatal errors occurred. Page contents follow.
SYSTEM WARNING: 'mysql_connect(): Too many connections' in '/var/www/html/arcengames.com/mantisbt/library/adodb/drivers/adodb-mysql.inc.php' line 365
And occasionally I'd get these from wordpress:
Error establishing a database connection
Well, gee.
So I tried this as my first compromise:
<IfModule prefork.c>
StartServers 1
MinSpareServers 1
MaxSpareServers 10
MaxClients 256
MaxRequestsPerChild 4000
</IfModule>
<IfModule worker.c>
StartServers 1
MaxClients 256
MinSpareThreads 1
MaxSpareThreads 40
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
That still avoided the MaxClients error, so hooray. But... same errors on mantis and wordpress. Still the wiki kinda-sorta working, but at least not giving me 522 and 524 errors anymore.
Grr. Okay, so one more compromise, and we arrive at the settings we are currently on:
<IfModule prefork.c>
StartServers 1
MinSpareServers 1
MaxSpareServers 5
ServerLimit 10
MaxClients 256
MaxRequestsPerChild 4000
</IfModule>
<IfModule worker.c>
StartServers 1
MaxClients 256
MinSpareThreads 1
MaxSpareThreads 4
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
Hooray, all the main services work properly again... except, oh wait, the wiki is back to not even giving partial pages. And that max clients error is in our error log again.
Any ideas from anyone? This is super frustrating, and I've wasted my whole morning on it at this point. >:(
-
Incidentally, here are the references I was using: http://httpd.apache.org/docs/2.2/mod/mpm_common.html
and http://httpd.apache.org/docs/2.2/mod/prefork.html
and http://httpd.apache.org/docs/2.2/mod/worker.html
Also this had some info: http://serverfault.com/questions/276478/apache-limiting-connections-per-vhost
And this was useful to me: http://stackoverflow.com/questions/12202021/where-is-my-httpd-conf-file-located-apache (/etc/httpd/conf/httpd.conf was correct)
And... yeah.
-
How about now?
-
Woohoo, it works! :D
-
This is playing out like a twisted Verizon commercial.
-
...with the guy switching to google fiber or something in the middle of the commercial, then it works. ;D
-
:D
-
Oh man, Firefox had the wrong password saved. Last time I reset it was 2012!
-
Ha -- wow!