Re: threads in cleaning up mode

2016-04-04 Thread geetanjali mehra
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 >>>

Re: threads in cleaning up mode

2016-04-04 Thread geetanjali mehra
; >> 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 STATUS shows

Re: threads in cleaning up mode

2016-04-04 Thread shawn l.green
STATUS shows all these threads in *cleaning up* mode. I tried all the options to reduce history list length. But it is constantly increasing. Below are the current settings of purge related threads: innodb_max_purge_lag | 100 | | innodb_max_purge_lag_delay | 0

Re: threads in cleaning up mode

2016-04-04 Thread Nitin Mehta
  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 STATUS shows all these threads in *cleaning up* mode. I tried all the options to reduce history list length. But it is

threads in cleaning up mode

2016-04-02 Thread geetanjali mehra
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 STATUS shows all these threads in *cleaning up* mode