Re: threads in cleaning up mode

Can it be a consequence of slow disk also? Best Regards, Geetanjali Mehra Senior Database Administrator On Tue, Apr 5, 2016 at 10:50 AM, geetanjali mehra < mailtogeetanj...@gmail.com> wrote: > Thanks to everyone for response. Any other views from any one is always > welcome. > > Best Regards,

Re: threads in cleaning up mode

Thanks to everyone for response. Any other views from any one is always welcome. Best Regards, Geetanjali Mehra Senior Database Administrator On Mon, Apr 4, 2016 at 7:51 PM, shawn l.green wrote: > > > On 4/2/2016 10:36 AM, geetanjali mehra wrote: > >> Hi to all, >> >> For many days, I am stru

Re: threads in cleaning up mode

On 4/2/2016 10:36 AM, geetanjali mehra wrote: Hi to all, For many days, I am struggling with the problem of increasing history list length on mysql 5.6.29. Application that this server is running IOT based. Also, this server has so many threads running in sleeping mode. SHOW ENGINE INNODB STA

Re: threads in cleaning up mode

Hi, It sounds like a bad case of transactions handling by the application. If you have transactions/statements open for very long time, the list which contains the unflushed changes, grows. These unflushed changes will slow down the purge and in extreme cases, will also affect the DMLs. So, IMO,