mysql.performance.slow_queries

InnoDB row-level locking can cause queries to wait when multiple transactions attempt to modify the same rows. This creates visible latency spikes and reduced throughput on write-heavy workloads with high concurrency on specific tables.

Queries that perform full table scans due to missing or inefficient indexes accumulate in the slow query log. These queries consume excessive CPU, I/O, and time, degrading overall database throughput and user experience. The problem scales with data growth and query frequency.

Queries exceeding long_query_time threshold accumulate, indicating systematic performance issues. High slow query rate signals need for query optimization, missing indexes, or resource scaling. Patterns in slow query types reveal specific optimization opportunities.