Alan Santos alanwds

## cloudwatch_log_insights_mysql_slow_query_examples.md

      
              1 file
            
          
              8 forks
            
          
              2 comments
            
          
              18 stars
            
          
                qiangxue
                / cloudwatch_log_insights_mysql_slow_query_examples.md
            
            
              Created
              October 20, 2020 19:28
                — forked from grocky/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


## README.md

      
              2 files
            
          
              3 forks
            
          
              8 comments
            
          
              22 stars
            
          
                thomaslarsen
                / README.md
            
            
              Last active
              February 20, 2024 20:12
            
              
                Convert PEM certificate to JSON format
              
          
    Convert a PEM based file to JSON

This snippet will convert a PEM based certificate of key to JSON format.
This is useful when having to embed a certificate in a JSON object.
It will simply add \n in the required places.
The snipped was copied from here: https://docs.vmware.com/en/Unified-Access-Gateway/2.9/com.vmware.access-point-29-deploy-config/GUID-870AF51F-AB37-4D6C-B9F5-4BFEB18F11E9.html

  
## README.md

      
              2 files
            
          
              58 forks
            
          
              27 comments
            
          
              75 stars
            
          
                Eyjafjallajokull
                / README.md
            
            
              Last active
              December 25, 2023 02:53
            
              
                AWS EBS - Find unused snapshots
              
          
    This script can help you find and remove unused AWS snapshots and volumes.
There is hardcoded list of regions that it searches, adjust the value to suit your needs.
Use snapshot.py snapshot-report to generate report.csv containing information about all snapshots.
snapshot.py snapshot-cleanup lets you interactively delete snapshot if it finds it is referencing unexisting resources.
./snapshots.py --help