Skip to content

Instantly share code, notes, and snippets.

@ronaldbradford

ronaldbradford/sql-statements.csv

Last active October 13, 2023 14:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ronaldbradford/2187e1a6962585a410a98b9161e222c9 to your computer and use it in GitHub Desktop.
Save ronaldbradford/2187e1a6962585a410a98b9161e222c9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql-statements.csv
Option Benefits Limitions
Processlist Enabled by default. Only captures executing SQL. Required elevated privileges to view all statements for all users.
Performance Schema Captures executed statements. Provides additional metrics and aggregrations. Not enabled by default. Very tehnical information.
Sys Schema Extends Performance Schema with highly usable views and objects. Not enabled by default
Slow Query Log Provides historical log of slow queries. Useful for long term analysis. Only logs queries that run longer than configured long_query_time. Does not capture additional information at time of query.
General Log Provides historical log of all queries. Very useful for viewing a full statement of sequential SQL statements. Can impact system performance. Essential for any detailed testing framework.
Binary Log Provides historical log of all write queries. Very useful for per table metrics of write load. Does not capture SELECT statements. Not always enabled.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment