Re: purge thread

Hi Geetanjali, Well word of caution with this setting, it can block the whole server if the purge thread is delayed too much. Also look into other things like IO saturation or issues with disk as to why the purge thread is not able to keep up with the backlog. If IO is not the issue then there is

Re: purge thread

Could you please put some more light on it? Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist On Thu, Aug 28, 2014 at 2:09 AM, shawn l.green wrote: > Hello Geetanjali, > > > On 8/26/2014 1:16 AM, geetanjali mehra wrote: > >> I want t

Re: purge thread

Hello Geetanjali, On 8/26/2014 1:16 AM, geetanjali mehra wrote: I want to understand how to tune innodb_max_purge_lag when history list length is high. Could anyone explain me. Best Regards, Geetanja

purge thread

I want to understand how to tune innodb_max_purge_lag when history list length is high. Could anyone explain me. Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database