Hello Geetanjali,
On 8/26/2014 1:16 AM, geetanjali mehra wrote:
I want to understand how to tune innodb_max_purge_lag
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_max_purge_lag
when history list length is high.
Could anyone explain me.
Best Regards,
Hello Geetanjali,
On 8/26/2014 1:11 AM, geetanjali mehra wrote:
Hello to all,
I want to know whether my innodb index is fragemented. Is it possible to
know?
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Specialist
Just like every other
On 8/26/2014 1:12 AM, geetanjali mehra wrote:
Hello to all,
In repeatable read isolation level, when we issue:
Select * from new where c1 between 12 and 17 for update;
this range will be locked by innodb by using next-key locks.
But, why is is preventing any other session to insert any