2008/07/21

Definition of "Lock wait ratio"

When "tuner-primer.sh" under MySQL is used, "Lock wait ratio" appears at the end of the report.
Here is the explanation of Lock wait ratio:
A metric that attempts to quantify the percentage of queries that are required to wait for object locks to be released so that the query can itself acquire a lock on the object.

1 comment:

Anonymous said...

Thank you very much for these explanation!