Log Analytics
Local-First

Log Encyclopedia

MySQL General Query Log

Full statement log capturing every query hitting a MySQL instance, useful for auditing.

Category: Database

Regex Pattern

^(?<time>\d{6}\s+\d{1,2}:\d{2}:\d{2})\s+(?<thread>\d+)\s+(?<command>\w+)\s+(?<argument>.*)$

DuckDB Schema

time VARCHAR, thread INTEGER, command VARCHAR, argument VARCHAR

Ready to analyze?

Click below to open the local DuckDB tool preloaded for MySQL General Query Log.

Analyze Now (Local & Private)Prefilled SQL: SELECT * FROM log_table LIMIT 200;