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.

These are the common holidays celebrated in India (Mumbai) during 2016 - 17

08-April Friday Guddi Padwa
1-May Sunday Maharashtra Day
15-Aug Monday Independence Day
05-Sept Monday Ganesh Chaturthi
02-Oct Sunday Gandhi Jayanti
11-Oct Tuesday Dussehra
30-Oct Sunday Diwali
31-Oct Monday Lakshmi Pooja
25-Dec Sunday Christmas
26-Jan Thursday Republic Day
13-March Monday Holi
_____

List FY 2013- 14           
Gudi Padwa    11-Apr    Thursday
Maharshtra Day    1-May    Wednesday
Independence Day    15-Aug    Thursday
Rakshabandhan    21-Aug    Wednesday
Ganesh Chaturthi    9-Sep    Monday
Gandhi Jayanti    2-Oct    Wednesday
Dasera    14-Oct    Monday
Laxmi Puja    3-Nov    Sunday
New Year    4-Nov    Monday
Bhai Duj    5-Nov    Tuesday
Chirstmas    25-Dec    Wednesday
Republic Day    26-Jan    Sunday
Holi    17-Mar    Monday
Gudi Padwa    31- Mar-2014    Monday

1146 Table does not exist
1054 column does not exist
1062 duplicate entry for primary key
1406 Data too long for column
1064 sql syntax error
1111 invalid use of group function
1366 incorrect integer value
1046 No database selected

First start ipython in cluster mode

ipcluster start -n 4

from IPython.parallel import Client
rc = Client()
v=rc.load_balanced_view()
@v.parallel(block=True)
def f(x): return 2*x
result = f.map(range(10))
print("Using a parallel function: ", result)