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

Forum Guidelines and Information, Status, etc.
User avatar
gixxerjasen
Veteran
Posts: 1809
Joined: Thu Feb 21, 2013 5:50 pm
FJRModel: 2007 Yamaha FJR1300AE
Location: DFW
x 793
x 1382

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

Post by gixxerjasen » 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.
My Blog
Current Bikes:2007 Yamaha FJR1300AE | 2016 Suzuki GSX-S1000 | 1998 KTM 250 EXC | 2001 Suzuki DRZ-400E
Family Bikes: 2006 Honda CRF70F | 2005 Honda CRF230F

User avatar
extrememarine
HMFIC
Posts: 3048
Joined: Sun Jan 13, 2013 12:17 pm
FJRModel: 2009 FJR
Location: SE Michigan
x 205
x 1586

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

Post by extrememarine » Tue Jul 10, 2018 9:49 am

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.
Ride There!
-Wayne aka asphalt surfer...

IBA#60836

#Peteyismyhero

User avatar
bungie4
Veteran
Posts: 3177
Joined: Sat Jan 19, 2013 7:43 pm
FJRModel: 2013 FJR 1300
x 781
x 1302

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

Post by bungie4 » Wed Jul 18, 2018 3:25 pm

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.
gixxerjasen loved this
WWPD.
#SnowMexican
Note: The FJR1300ES offers a significant level of power & performance. It is not intended for novice or inexperienced riders.
Choo choo mf'r.

User avatar
extrememarine
HMFIC
Posts: 3048
Joined: Sun Jan 13, 2013 12:17 pm
FJRModel: 2009 FJR
Location: SE Michigan
x 205
x 1586

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

Post by extrememarine » Wed Jul 18, 2018 3:38 pm

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...

Ride There!
-Wayne aka asphalt surfer...

IBA#60836

#Peteyismyhero

User avatar
jwilly
Site Admin
Posts: 158
Joined: Tue Jan 15, 2013 10:31 am
FJRModel: 2016
Location: Georgia
x 373
x 294

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

Post by jwilly » Thu Jul 19, 2018 10:59 am

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.

Post Reply