MySQL General Log Analyzer

A small Python toolkit to parse MySQL general query logs and summarize connection sessions into Excel.

This is useful for:

• Debugging long-lived connections
• Finding chatty sessions
• Analyzing real SQL execution counts
• Investigating RDS / MySQL workload behavior

---

Overview

This tool works in two steps:

1. Parse raw MySQL general log → CSV
2. Summarize sessions → XLSX

It correctly handles:

• Multi-line SQL
• Prepared statements
• Connection reuse
• Session lifecycle (Connect → Quit)

---

Requirements

• Python 3.9+
• pip packages:

  pip install pandas openpyxl

Usage

1. Parse raw MySQL general log → CSV

python convert-to-csv.py mysql-8-0-general.log general.csv

2. Summarize sessions → XLSX

python summary-by-connection.py general.csv summary.xlsx