Thanks to antville.org
Wednesday, 19. February 2020
log mysql output

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;

... Link (0 comments) ... Comment


Sunday, 16. February 2020
access AWS API gateway using python

Amazon API gateway allows us to host server-less 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='xxx.execute-api.ap-south-1.amazonaws.com'

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

... Link (0 comments) ... Comment


Saturday, 15. February 2020
Using boto

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",)

... Link (0 comments) ... Comment


Thursday, 13. February 2020
backup mysql usersĀ 

3 steps to install perconal 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

... Link (1 comment) ... Comment


Steps to be used for generating AWS API gateway

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"
}
}

... Link (0 comments) ... Comment


Wednesday, 12. February 2020
apply colors to pandas

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)

... Link (1 comment) ... Comment


Tuesday, 11. February 2020
change log file size in MySQL

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.

... Link (1 comment) ... Comment


Holidays in India

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

... Link (1 comment) ... Comment


MySQL common error messages

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

... Link (1 comment) ... Comment


Sunday, 9. February 2020
ipython parallel demo

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)

... Link (0 comments) ... Comment


Online for 6387 days
Last modified: 2/19/20 1:54 PM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
February 2020
SunMonTueWedThuFriSat
1
2345678
9101112131415
16171819202122
23242526272829
January
Recent updates
About the sites Thanks for
sharing click here to see this site https://bigtitsdosports.com/alanah-rae-and-haley-cummings-huge-tit-fuck-charles-dera/
by JamesWalk (2/19/20 1:54 PM)
comment to the blogs Hello
onpagetricks onpagetricks.com [url]onpagetricks.com[/url] http://onpagetricks.com
by JamesWalk (2/19/20 12:48 PM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20 12:33 PM)
Super interesting! Will definitely
be checking out other pages on this website. Landscaping Frankston
by fencingtoowoomba (2/19/20 12:19 PM)
pinoy network replay pinoy network
replay. Thanks and Thumbs Up for great work
by PinoyTvTambayanReplay (2/19/20 11:53 AM)
Perks of Watching Online Movies
Perks Of Watching Online Movies. Thanks For this beautiful Post
by PinoyTvTambayanReplay (2/19/20 11:51 AM)
The Famous Actors of Philipines
Famous Serial Actors of Philipines. Thanks For the Post Admin......
by PinoyTvTambayanReplay (2/19/20 11:49 AM)
thefitnessidea Army Training Video
by lifestyle (2/19/20 5:23 AM)
stucco contractors Thank you so
much Antville for sharing this page. We stucco contractors are...
by joshuagibbs422 (2/18/20 11:11 AM)
Thank you a bunch for
sharing this code. Hope I can apply it to...
by casseverhart (2/18/20 11:06 AM)
nbc.com/activate By activating NBC sports
activate, which can be accessible through nbc.com/activate a person as...
by annie liscon (2/18/20 8:04 AM)
Thank you! Check out our
site here: House painters Tumwater
by LP3 (2/17/20 11:07 PM)
SLC Tree Pros Check us
out for the best tree service Salt Lake City!
by natechas (2/17/20 10:00 PM)
Good steps here for
that MySQL. panel installation
by casseverhart (2/17/20 12:42 PM)
crackedera A malware refers to
a virus that can harm your computer. These malware are...
by crackedera (2/17/20 9:09 AM)
Nice immigration solicitors Dublin accounting
services Kent London music producer
by John1999 (2/16/20 4:09 PM)
Good Job roofer Newcastle chimney
sweep Reading real estate Budapest
by John1999 (2/16/20 4:07 PM)
Great writing pool leak detection
Los Angeles energy healing meditation London
by John1999 (2/16/20 4:01 PM)
Nice tree surgeon Edinburgh man
with a van Telford man with a van Oxford
by John1999 (2/16/20 3:57 PM)
access AWS API gateway using
python Amazon API gateway allows us to host server-less API's...
by shantanuo (2/16/20 11:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20 12:28 PM)
Great solution for that
issues... Tree Solutions Waterford Lakes
by casseverhart13 (2/14/20 12:24 PM)
Mobile Dog Grooming Spectacular post!
Check us out for dog hair cutting in Utah County!
by natechas (2/14/20 1:23 AM)
backup mysql usersĀ  3
steps to install perconal utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
by shantanuo (2/13/20 3:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20 3:30 PM)

RSS feed

Made with Antville
Helma Object Publisher