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. I tried all the options to reduce history list length. But it is constantly increasing. Below are the current settings of purge related threads:
Also, please let me know that whether cleaning up mode of threads and history list length are correlated.
Anty help?
Best Regards, Geetanjali Mehra Senior Database Administrator
Apr 04
Nitin Mehta Re: threads in cleaning up mode
Apr 04, 2016; 11:18
Nitin Mehta
Re: threads in cleaning up mode
Apr 04
shawn l.green Re: threads in cleaning up mode
Apr 04, 2016; 10:21
shawn l.green
Re: threads in cleaning up mode
Apr 05
geetanjali mehra Re: threads in cleaning up mode
Apr 05, 2016; 10:50
geetanjali mehra
Re: threads in cleaning up mode
Apr 05
geetanjali mehra Re: threads in cleaning up mode
Apr 05, 2016; 10:55
geetanjali mehra
Re: threads in cleaning up mode
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!