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

Forum Guidelines and Information, Status, etc.
User avatar
gixxerjasen
I post more than I ride
Posts: 5640
Joined: Thu Feb 21, 2013 5:50 pm
FJRModel: 2007 Yamaha FJR1300AE
Location: DFW
x 5103
x 8337

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

Post 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.
My Blog
Current Bikes:2007 Yamaha FJR1300AE | 2016 KTM 1190 Adventure R | 2001 Suzuki DRZ-400E
Son's Bike:2019 Honda CRF250L

I'm here to serve as an example of what NOT to do.
User avatar
extrememarine
HMFIC
I post more than I ride
Posts: 6622
Joined: Sun Jan 13, 2013 12:17 pm
FJRModel: 2009 FJR
Location: SE Michigan
x 1966
x 12165
Contact:

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

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

IBA#60836

#Peteyismyhero & #JWillywashere
User avatar
bungie4
I post more than I ride
Posts: 6766
Joined: Sat Jan 19, 2013 7:43 pm
FJRModel: 2013 FJR 1300
x 3541
x 5977

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

Post 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.
gixxerjasen loved this
WWPD.
#SnowMexican
Choo choo mf'r.
That's weird, I don't remember eating asparagus.
User avatar
extrememarine
HMFIC
I post more than I ride
Posts: 6622
Joined: Sun Jan 13, 2013 12:17 pm
FJRModel: 2009 FJR
Location: SE Michigan
x 1966
x 12165
Contact:

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

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

Ride There!
-Wayne aka asphalt surfer...

IBA#60836

#Peteyismyhero & #JWillywashere
User avatar
jwilly
Site Admin
Veteran
Posts: 760
Joined: Tue Jan 15, 2013 10:31 am
FJRModel: 2016
Location: Georgia
x 2249
x 2148

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

Post 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.
I’d be more than happy to swear under oath that having watched you ride for many, many miles, there is no way in hell you could be speeding through those curves. -0face
Post Reply