| SELECT table_schema "Data Base Name", | |
| sum( data_length + index_length ) / 1024 / | |
| 1024 "Data Base Size in MB", | |
| sum( data_free )/ 1024 / 1024 "Free Space in MB" | |
| FROM information_schema.TABLES | |
| GROUP BY table_schema ; |
A curated list of AWS resources to prepare for the AWS Certifications
A curated list of awesome AWS resources you need to prepare for the all 5 AWS Certifications. This gist will include: open source repos, blogs & blogposts, ebooks, PDF, whitepapers, video courses, free lecture, slides, sample test and many other resources.
Index:
| #!/usr/bin/python | |
| def lambda_handler(event, context): | |
| print format(event) |
| #!/usr/bin/python | |
| # Use CloudWatch Events Trigger - Schedule:InstancePending | |
| import boto3 | |
| import time | |
| def main(event, context): | |
| my_instance = str(event['detail']['instance-id']) | |
| ec2 = boto3.client("ec2", region_name=str(event['region'])) |
| import os | |
| def lambda_handler(event, context): | |
| print os.environ |
| # requires that jq utility be installed and in $PATH | |
| curl https://ip-ranges.amazonaws.com/ip-ranges.json | jq '.prefixes[]| "\(.service),\(.region),\(.ip_prefix)"'|tr -d '"' > aws_ips.csv |
| Apache: | |
| - Activated 'KeepAlive' connections | |
| - Lowered keep alive timeout from 15 seconds to 2 seconds | |
| - Increased the number of minimum workers from 8 to 16 | |
| - Activated server status page (/server-status) | |
| APC (Alternative PHP Cache): | |
| - Set cache size to 256MB (ideal for SugarCRM workload) | |
| Memcache: |
| aws polly synthesize-speech \ | |
| --output-format "mp3" \ | |
| --voice-id "Salli" \ | |
| --text "Amazon Polly is a service that turns text into lifelike speech. Polly lets you create applications that talk, enabling you to build entirely new categories of speech-enabled products. Polly is an Amazon AI service that uses advanced deep learning technologies to synthesize speech that sounds like a human voice. Polly includes 47 lifelike voices spread across 24 languages, so you can select the ideal voice and build speech-enabled applications that work in many different countries." \ | |
| polly-cli.mp3 |
| #!/bin/bash | |
| # bamboo | |
| mkdir /opt/atlassian | |
| wget -O /opt/atlassian/bamboo.tar.gz http://www.atlassian.com/software/bamboo/downloads/binary/atlassian-bamboo-5.1.1.tar.gz | |
| cd /opt/atlassian | |
| tar xzf bamboo.tar.gz | |
| mv atlassian* bamboo | |
| mkdir /home/bamboo |
I hereby claim:
To claim this, I am signing this object:
