[LRUG] MySql connection problems

Ed James (Alt) ed.james.spam at gmail.com
Mon Mar 4 08:21:47 PST 2013


@Geoff We already have that config setting enabled, but it may help together with the timeout settings. 

I will confirm, thanks. 

-- 
Ed James
Sent with Sparrow (http://www.sparrowmailapp.com/?sig)


On Monday, 4 March 2013 at 16:20, Ed James (Alt) wrote:

> Thanks for the feedback. 
> 
> I don't think it's an IP issue, because we only get this in our Rails 2 app - the Rails 3 app behaves as expected.
> 
> Also, our MySql instance is an m1.xlarge RDS instance. We only see this issue when upgrading the Ubuntu version though, not necessarily when we have traffic spikes. We had another problem this morning in a very quite period.
> 
> @Alexander Hmm, I'll try that and let you know.
> 
> Thanks, 
> 
> -- 
> Ed James
> Sent with Sparrow (http://www.sparrowmailapp.com/?sig)
> 
> 
> On Monday, 4 March 2013 at 16:15, Jon Wood wrote:
> 
> > Second that, the times I've seen it our MySQL instance was getting killed due to the server running out of memory. 
> > 
> > On Monday, 4 March 2013 at 16:14, Vish Vishvanath wrote:
> > 
> > > Hiya,
> > > 
> > > Slightly left-field, but I've seen this happen when there's a network issue such as an IP conflict, and the DB server drops out.
> > > 
> > > vv
> > > 
> > > On 4 Mar 2013, at 16:05, Ed James (Alt) <ed.james.spam at gmail.com (mailto:ed.james.spam at gmail.com)> wrote:
> > > 
> > > > Hi all
> > > > 
> > > > I'm wondering if anyone has seen this issue before. Any help would be greatly appreciated. There are a few threads on Stack Overflow, but most of them are marked as duplicates of the supposedly solved thread, which just points to the MySql docs.
> > > > 
> > > > I've removed part of the query, but it's a very straight-forward statement, with a single join. Our db is properly indexed.
> > > > 
> > > > Thanks in advance.
> > > 
> > > _______________________________________________
> > > Chat mailing list
> > > Chat at lists.lrug.org (mailto:Chat at lists.lrug.org)
> > > http://lists.lrug.org/listinfo.cgi/chat-lrug.org
> > > 
> > > 
> > > 
> > 
> > 
> > _______________________________________________
> > Chat mailing list
> > Chat at lists.lrug.org (mailto:Chat at lists.lrug.org)
> > http://lists.lrug.org/listinfo.cgi/chat-lrug.org
> > 
> > 
> > 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20130304/9006f9e0/attachment-0003.html>


More information about the Chat mailing list