Skip to content

Instantly share code, notes, and snippets.

@debu99
debu99 / loc_contnt_backend.json
Last active May 22, 2024 07:01
loc_contnt_front.json
{}
@debu99
debu99 / cloudwatch_log_insights_mysql_slow_query_examples.md
Last active October 25, 2022 05:40 — forked from qiangxue/cloudwatch_log_insights_mysql_slow_query_examples.md
CloudWatch Log Insights query examples for MySQL slow query log.

Filtering queries

Find slowest write queries

parse @message /Query_time: (?<queryTime>.*?) Lock_time: (?<lockTime>.*?) Rows_sent: (?<rowsSent>.*?) Rows_examined: (?<rowsExamined>.*?)\s(?<query>.*?)$/
  | filter @message like /(?i)insert/
  | sort queryTime desc
  | limit 10
yum install -y epel-release
yum install -y python-pip
pip install --upgrade pip
pip install docker-compose
pip install backports.ssl_match_hostname --upgrade
# You might need to run:
pip install six --upgrade