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.

DBADatabase LoggingLock Troubleshooting

0 likes · 24 min read

Tracing Full SQL Statements in PostgreSQL Transactions Using Log Configuration

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