Use this script to monitor an RDS instance endpoint, RDS proxy endpoint, Route 53 endpoint during any testing or failover operations.
$ watch --differences -n 1 -t "./monitor-mysql-connection.sh"
{ | |
"steps": [ | |
{ | |
"join_preparation": { | |
"select#": 1, | |
"steps": [ | |
{ | |
"expanded_query": "/* select#1 */ select `a`.`country_code` AS `country_code`,`c`.`name` AS `name`,count(0) AS `cnt` from (`airport` `a` join `country` `c` on((`a`.`country_code` = `c`.`country_code`))) group by `a`.`country_code`,`c`.`name` order by count(0) desc limit 10" | |
}, | |
{ |
Use this script to monitor an RDS instance endpoint, RDS proxy endpoint, Route 53 endpoint during any testing or failover operations.
$ watch --differences -n 1 -t "./monitor-mysql-connection.sh"
# Set Computer Name
name | setting | |
-------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
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. |
#https://limitlesstcg.com/decks/list/8175 | |
#Vance Kelley | |
#World Championships 2023 Winner | |
Pokémon (13) | |
4 Mew V CRZ 60 | |
3 Mew VMAX FST 114 | |
4 Genesect V FST 185 | |
1 Meloetta FST 124 | |
1 Oricorio FST 42 |
Pokémon: 4 | |
4 Genesect V FST 185 | |
3 Mew V FST 113 | |
3 Mew VMAX FST 114 | |
2 Meloetta FST 124 | |
Trainer: 17 | |
4 Battle VIP Pass FST 225 | |
4 Cram-o-matic FST 229 | |
4 Ultra Ball SVI 196 |
#!/usr/bin/env bash | |
error() { | |
echo "ERROR: $*" | |
exit 1 | |
} | |
command -v aws >/dev/null 2>&1 || error "'aws' not installed" | |
command -v jq >/dev/null 2>&1 || error "'jq' not installed" |