This code will change the standard out to a file so that jupyter notebook cell's responses are saved to a file.

import sys
oldStdout = sys.stdout
file = open('logFile', 'w')
sys.stdout = file

While creating amazon config file in a shell script, use cat with heredoc like this..

cat > myconfigfile.txt << "heredoc"
[default]
aws_access_key_id=XXX
aws_secret_access_key=XXX
region=us-east-1
heredoc

export AWS_CONFIG_FILE=./myconfigfile.txt

This is how to set the colors in pandas

mapper = {v: k for k, v in enumerate(colors.unique())}

ccolors.cat.reorder_categories(mapper).cat.codes

tee output.txt
show global variables;
show engine innodb status\G
show full processlist;
show global status;
select sleep(60);
show engine innodb status\G
show full processlist;
show global status;
notee;

Amazon API gateway allows us to host serverless API's those can talk to cloud or on-premises databases. Here is 5 lines of python code to use the API

from urllib.request import Request, urlopen

url='https://xxx.execute-api.ap-south-1.amazonaws.com/stag'

q = Request(url)
q.add_header('uname', '472202986990')
data = urlopen(q).read().decode('UTF-8')

In the bad old days, the glacier class used to have different layers.

import boto.glacier.layer2
l2 = boto.glacier.layer2.Layer2(aws_access_key_id='xxx', aws_secret_access_key='xxx')

Now the client is all you need!

import boto3
gc = boto3.client("glacier",
aws_access_key_id="xxx", aws_secret_access_key="xxx",)

3 steps to install percona utility...

yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL

wget percona.com/get/pt-show-grants 

perl pt-show-grants -h 1.2.3.4 -uroot -pPasswd

a) Method Execution - Get Method Request - URL Query String Parameters - add a variable: cmnumber

b) Method Execution - Get Integration Request - Mapping Templates - Content-Type - application/json - Mapping template

{"mnumber": "$input.params('cmnumber')"}

"requestTemplates": {
     "application/json": {
        "querystring": "$input.params().querystring"
      }
 }

Here is how to change the color of negative values to red in pandas.

def color_negative_red(val):
color = 'red' if val < 0 else 'black'
return 'color: %s' % color

df = df.style.applymap(color_negative_red)

Here are the steps to be followed while changing the log file size in mysql:

1) SET GLOBAL innodb_fast_shutdwn = 1;
2) Stop the mysqld server and check the end of the error log file to ensure that the shutdown was clean.
3) Move the existing log files to another location for extra safety.
4) Make the size change in the my.cnf and restart.