Technologies/MySQL/mysql.performance.table_locks_immediate
MySQLMySQLMetric

mysql.performance.table_locks_immediate

The number of times that a request for a table lock could be granted immediately.
Dimensions:None
Available on:DatadogDatadog (1)DynatraceDynatrace (1)
Interface Metrics (2)
DatadogDatadog
The number of times that a request for a table lock could be granted immediately.
Dimensions:None
DynatraceDynatrace
Number of times a table lock was acquired immediately
Dimensions:None
Sources
mysql.performance.table_locks_immediategithub.com
mysql_table_locks_immediatewww.dynatrace.com
Related Insights (1)
Table Lock Contention on MyISAM Tableswarning

MyISAM table locks blocking concurrent queries, causing query queuing and latency spikes. MyISAM uses table-level locking, so writes block all other operations on the table. Mixed read/write workloads suffer severe contention.

▸