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

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

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
Veteran
Posts: 3908
Joined: Sun Jan 13, 2013 12:17 pm
FJRModel: 2009 FJR
Location: SE Michigan
x 313
x 3251

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: 4596
Joined: Sat Jan 19, 2013 7:43 pm
FJRModel: 2013 FJR 1300
x 1713
x 2615

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
Veteran
Posts: 3908
Joined: Sun Jan 13, 2013 12:17 pm
FJRModel: 2009 FJR
Location: SE Michigan
x 313
x 3251

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
Veteran
Posts: 629
Joined: Tue Jan 15, 2013 10:31 am
FJRModel: 2016
Location: Georgia
x 1866
x 1683

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