phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Moved to MYSQL 5


 
Search this topic... | Search phpBB2 Discussion... | Search Box
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Author Message
JLA
Board Member



Joined: 30 Apr 2009

Posts: 298
Location: U.S.A


flag
PostPosted: Wed Feb 03, 2010 7:54 pm 
Post subject: Moved to MYSQL 5

Just wanted to share

We had been running MYSQL4x since the beginning but last week for an "unknown" reason - server started crashing during large concurrent post inserts. We were never able to narrow down the cause after significant troubleshooting. No code changed nor any other factors that we could account for. Just all of a sudden one day - boom intermittent crashes during high post activity periods.

So we moved to MYSQL5 and after some tweaking to account for new MYSQL5 behavior things seem quite stable. Also able to take advantage of 64-bit flavor as well.

Just some FYI for anyone still running MYSQL4 with PHPBB2. It might be well worth the move.

_________________
http://www.jlaforums.com
Back to top
Dog Cow
Board Member



Joined: 18 Nov 2008

Posts: 378


flag
PostPosted: Thu Feb 04, 2010 10:40 pm 
Post subject: Re: Moved to MYSQL 5

I've been running 64-bit MySQL 5.x for over a year now. I just upgraded to the latest 5.1.x release a week ago.

The main thing to watch out for is that some queries will require parentheses around the table names in the FROM clause in some cases.

For example:

Code:
SELECT f.foo, b.bar FROM (foo_table f)
LEFT JOIN bar_table b ON (b.bar = f.bar)

_________________
Moof!
Lincoln's Tomb, Oak Ridge Cemetery, Springfield IL Mac 512K Blog Mac GUI
Back to top
JLA
Board Member



Joined: 30 Apr 2009

Posts: 298
Location: U.S.A


flag
PostPosted: Thu Feb 04, 2010 11:39 pm 
Post subject: Re: Moved to MYSQL 5

We haven't seen any issue with that throughout our site.

We did see an issue with some inserts in various places calling an error for data too long for field's etc. Apparently MYSQL4 just truncated in such cases but new data integrity features of MYSQL will stop and call errors. If you change the run mode to the older behavior - well, let me just say it wasn't the route we wanted to go.

So far things have been very stable.

_________________
http://www.jlaforums.com
Back to top
phpBB2 Refugees
Camp Leader
Camp Leader



Joined: 24 Jul 2008

Posts: 72
Location: I Live Here



PostPosted: Sun Apr 04, 2010 3:13 pm 
Post subject: Re: Moved to MYSQL 5

We're running on MySQL 5 on this site and have been from the beginning. There were a few outer join issues that needed some tweaking but other than that, we're fine.
_________________
Long Live phpBB2 icon_biggrin.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0118 seconds using 15 queries. (SQL 0.0019 Parse 0.0005 Other 0.0095)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo