MySQL 5.5.33 History list not purging?

2014-09-06 Thread Brad Heller
For some reason, the history list isn't purging on one of my masters. This is causing all kinds of weird issues/behavior with reads. Here's the last 8 or so hours of history list length: http://i.imgur.com/Q4DEeVi.png Here are my innodb%purge% settings. mysql> show variables where Variable_name

Re: MySQL 5.5.33 History list not purging?

2014-09-06 Thread Reindl Harald
Am 06.09.2014 um 19:07 schrieb Brad Heller: > For some reason, the history list isn't purging on one of my masters. This > is causing all kinds of weird issues/behavior with reads so why do you not just try to update first? 5.5.39 is recent and contains *a lot* of bufixes look at the changelogs

Re: MySQL 5.5.33 History list not purging?

2014-09-06 Thread Brad Heller
Good point. We'll try that out. I noticed our ibdata file is gigantic now, likely due to the alter table migration we ran. What's the relationship here, do you think? *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe

RE: MySQL 5.5.33 History list not purging?

2014-09-07 Thread Jesper Wisborg Krogh
Hi Brad, > -Original Message- > From: Brad Heller [mailto:b...@cloudability.com] > Sent: Sunday, 7 September 2014 03:07 > To: MySQL General List > Subject: MySQL 5.5.33 History list not purging? > > For some reason, the history list isn't purging on one of my

Re: MySQL 5.5.33 History list not purging?

2014-09-11 Thread Brad Heller
obs> On Sun, Sep 7, 2014 at 2:04 AM, Jesper Wisborg Krogh wrote: > Hi Brad, > > > -Original Message- > > From: Brad Heller [mailto:b...@cloudability.com] > > Sent: Sunday, 7 September 2014 03:07 > > To: MySQL General List > > Subject: MySQL 5.5.33 History