BestHub
Sign in
Tag

Lock Troubleshooting

0 views collected around this technical thread.

Qunar Tech Salon
Qunar Tech Salon
Mar 31, 2021 · Databases

Tracing Full SQL Statements in PostgreSQL Transactions Using Log Configuration

This article explains how DBAs can use PostgreSQL's extensive logging parameters and log_line_prefix settings to locate and reconstruct every SQL statement within a transaction, illustrated with practical cases, command‑line examples, and step‑by‑step log‑analysis techniques for lock troubleshooting.

DBALock TroubleshootingLog Configuration
0 likes · 24 min read
Tracing Full SQL Statements in PostgreSQL Transactions Using Log Configuration
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 6, 2020 · Databases

How to Find Hidden MySQL Locks When They Do Not Appear in SHOW PROCESSLIST

This article explains how to locate a MySQL statement that holds a lock but does not appear in SHOW PROCESSLIST, by enabling performance_schema, examining INNODB_LOCK_WAITS, INNODB_LOCKS, INNODB_TRX, and using performance_schema.threads and events_statements_current to retrieve the blocking SQL.

Lock TroubleshootingMySQLPerformance Schema
0 likes · 7 min read
How to Find Hidden MySQL Locks When They Do Not Appear in SHOW PROCESSLIST