Power, Paul C. wrote:
Table_Locks_Immediate and Table_Locks_waited.
What does MySQL do exactly to get those values?
Can it be determined what locks had to wait, and why?
-Paul
As far as I know, no. You should probably ask someone who really knows, but to
my limited understanding, these locks are acquired and released with every query
at the server level, and are not InnoDB lock-related. If you run a SELECT and
examine the values before and after, I think you'll find Table_locks_immediate
increments.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
