| # this Code will help to schedule stop the RDS databasrs using Lambda | |
| # Yesh | |
| # Version -- 2.0 | |
| # Adapted from https://aws.amazon.com/blogs/database/schedule-amazon-rds-stop-and-start-using-aws-lambda/ | |
| import boto3 | |
| import os | |
| import sys | |
| import time | |
| from datetime import datetime, timezone |
# Set Computer Name
| { | |
| "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"
| 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 |