Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Your db instability issues
Avatar
Bill Murray
Member
Free Members
sp_UserOfflineSmall Offline
Nov 27, 2011 - 9:04 am

This is not conclusive and final yet, but as of this AM (Wash DC time), it looks like the problems have gone away but some issues remain (maybe just with me).

Before, your main site loaded, but accessing the forum often caused a hang just after the header displayed.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 27, 2011 - 10:30 am

just little odds and ends... but we have found a nasty little bug our latest sp that was contributing significantly... odd no one else has seen it or us before, but have band aided it here and solved the last issues... need to get a real fix in place and committed...

Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Nov 27, 2011 - 5:18 pm

So, I just need to know one thing... were any of the hosting or db issues related to the SPF upgrade? confused

I would also be interested in hearing about your recommended optimal db config for smooth SPF sailing.

TripawdsSimple:Press powers the Tripawds Discussion Forums.

It's better to hop on three legs than to limp on four.

The Tripawds Blogs Community is made possible by The Tripawds Foundation.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 27, 2011 - 6:04 pm

sp upgrade?? not the upgrade process... but in moving hosts we did find a significant bug that has been fixed in the new version pushed out this evening... wont affect the vast majority of users, but it could overload your mysql server in just the right circumstance...

Jim, are you running 5.0? its a huge performance increase over the 4.4.x version..

Avatar
jim
Here and Now
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Nov 27, 2011 - 6:11 pm

Mr Papa said

are you running 5.0?

Not yet, just needed that question answered! smile

Plan to update our dev install to 3.3 and do that now. Looking forward to seeing those improvements.

TripawdsSimple:Press powers the Tripawds Discussion Forums.

It's better to hop on three legs than to limp on four.

The Tripawds Blogs Community is made possible by The Tripawds Foundation.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 27, 2011 - 6:44 pm

We'll be standing by...

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17357
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10123
Posts: 79613