dbaplus Community

Jul 25, 2017 · Databases

How to Build a MySQL Connection & SQL Analyzer for Fast Issue Diagnosis

This article explains how to create a lightweight MySQL tool that extracts connection details from information_schema.processlist, groups them by user, host, database, command and state, fingerprints SQL statements, and correlates them with InnoDB transaction data to quickly pinpoint performance problems.