Page 3 of 3

Re: 7/5/2018 - Planned outage - Noon to 6pm

Posted: Tue Jul 10, 2018 9:47 am
by gixxerjasen
Don't know if there's some tweaking needed on the new host. Just got this error, oddly enough clicking on the FJR Forum thread...

General Error
SQL ERROR [ mysqli ]

User attack10_phpb183 already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Re: 7/5/2018 - Planned outage - Noon to 6pm

Posted: Tue Jul 10, 2018 9:49 am
by extrememarine
I got one this morning as well - will look at it with the host support team as soon as I have time.

-w
gixxerjasen wrote:
Tue Jul 10, 2018 9:47 am
Don't know if there's some tweaking needed on the new host. Just got this error, oddly enough clicking on the FJR Forum thread...

General Error
SQL ERROR [ mysqli ]

User attack10_phpb183 already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Re: 7/5/2018 - Planned outage - Noon to 6pm

Posted: Wed Jul 18, 2018 3:25 pm
by bungie4
I'm not sure if PHPBB supports it, but look for connection pooling in the config. Instead of opening individual db connections for everybody, it shares a handful connections. Usually much faster to because the system isn't constantly tearing down/building db connections on the fly.

Re: RE: Re: 7/5/2018 - Planned outage - Noon to 6pm

Posted: Wed Jul 18, 2018 3:38 pm
by extrememarine
bungie4 wrote:I'm not sure if PHPBB supports it, but look for connection pooling in the config. Instead of opening individual db connections for everybody, it shares a handful connections. Usually much faster to because the system isn't constantly tearing down/building db connections on the fly.
I'll see if that is mentioned in the phobb support forum, thanks.

Sent from the Tapatalk app...


Re: 7/5/2018 - Planned outage - Noon to 6pm

Posted: Thu Jul 19, 2018 10:59 am
by jwilly
The default is typically 20 connections which is pretty low. You can edit the max connections in /etc/my.cnf file and set it to maybe 100 and that would probably be plenty for here.