Thanks to antville.org |
Tuning MySQL
shantanuo
15:34h
Getting the shell script: Running: ... Link (0 comments) ... Comment
Check for table corruption quick and fast
shantanuo
15:39h
#!/bin/sh for dbname in `mysqlshow | awk '{print $2}'` # call this shell script and find the errors ... Link (0 comments) ... Comment
shell script example
shantanuo
04:46h
An example of shell script. #!/bin/bash do _____ ping the address received from positional parameter #!/bin/bash if [ $# -eq 0 ] ping -c 2 $SITE > /dev/null _____ Here is the script that will loop two thousand times and print the statement on the screen. #!/bin/sh MAX=2000 while [ $i -le $MAX ] ... Link (0 comments) ... Comment
Match Operator in AWK
shantanuo
04:40h
The match operator is the tilde “~” which will match an expression in a record or field. In this example awk is used to search for a field, number 7, that matches “nologin”. awk -F: '$7 ~ /nologin/' /etc/passwd ... Link (0 comments) ... Comment
Copy table
shantanuo
05:28h
#!/bin/sh # duplicate a table Table1 by coping the files if it is a MyISAM table. ... Link (0 comments) ... Comment
Brace Expansion
shantanuo
13:16h
Brace expansion is used to generate arbitrary strings. For e.g. will list the files like mysql.00001 mysql.00002 & mysql.00003 This can also be used for something like this... cp mysql.log{,.bak} cp $da.log{.bak,} ... Link (0 comments) ... Comment
User input in shell script
shantanuo
12:09h
#!/bin/sh ... Link (0 comments) ... Comment
Inernal File Separator
shantanuo
11:37h
The safe way to change IFS in a 'while read' loop is: while IFS=\| read a b c ... Link (0 comments) ... Comment
valid date
shantanuo
10:14h
validdate.sh script will look like this... #!/bin/sh # sh validdate.sh 2009-33-44 ... Link (0 comments) ... Comment
better code
shantanuo
12:45h
`test -s /var/log/mailme.txt` if [[ -z /var/log/mailme.txt ]]; then ... Link (0 comments) ... Comment |
Online for 7297 days
Last modified: 7/16/22, 4:46 AM Status
Youre not logged in ... Login
Menu
Search
Calendar
Recent updates
Card issuing banks CITI
Standard Chartered HSBC American Express HDFC ICICI AXIS INDUS IND Kotak...
by shantanuo (7/16/22, 4:46 AM)
Activate IAM Access To activate
the Activate IAM Access setting, you must log in to...
by shantanuo (7/12/22, 5:52 AM)
use cheat instead of man
wget https://github.com/cheat/cheat/releases/download/4.2.3/cheat-linux-arm64.gz gunzip cheat-linux-arm64.gz chmod 770 cheat-linux-arm64 ./cheat-linux-arm64 mv cheat-linux-arm64...
by shantanuo (7/4/22, 8:53 AM)
python module itertools list of
useful methods of itertools module. permutations combinations combinations_with_replacement zip_longest count...
by shantanuo (9/8/21, 7:50 AM)
wikipedia tools 1) Collection of
useful utilities https://wikipediatools.appspot.com/ 2) all history of a user https://xtools.wmflabs.org/ec/mr.wikisource.org/Shantanuo...
by shantanuo (8/20/21, 6:36 AM)
Duration/Term of Copyright In the
case of original literary, dramatic, musical and artistic works, the...
by shantanuo (8/20/21, 6:26 AM)
Preserve seeds 6 types of
seeds to be preserved for next season. 1) laal Mula...
by shantanuo (5/7/21, 5:46 AM)
Why do I care for
Linux? I don't care that much for other software. Linux...
by shantanuo (12/17/20, 9:27 AM)
important leafy vegetables 1. Amaranthus
caudatus: rajgira. 2. Amaranthus tricolor: Math. (Chhoti Chulai- Hindi, Cheera-...
by shantanuo (4/12/20, 2:01 PM)
program creek program creek
seems to be a good site for handy references of python...
by shantanuo (4/11/20, 11:24 AM)
Standard out to a file
This code will change the standard out to a file...
by shantanuo (4/11/20, 11:18 AM)
Create config file for AWS
command line tool While creating amazon config file in a...
by shantanuo (2/20/20, 6:00 AM)
setting colors in pandas This
is how to set the colors in pandas mapper =...
by shantanuo (2/20/20, 5:53 AM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20, 10:33 AM)
access AWS API gateway using
python Amazon API gateway allows us to host serverless API's...
by shantanuo (2/16/20, 9:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20, 10:28 AM)
backup mysql users 3
steps to install percona utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
by shantanuo (2/13/20, 1:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20, 1:30 PM)
apply colors to pandas Here
is how to change the color of negative values to...
by shantanuo (2/12/20, 8:57 AM)
Holidays in India These are
the common holidays celebrated in India (Mumbai) during 2016 -...
by shantanuo (2/11/20, 1:53 PM)
change log file size in
MySQL Here are the steps to be followed while changing...
by shantanuo (2/11/20, 10:38 AM)
MySQL common error messages 1146
Table does not exist 1054 column does not exist 1062...
by shantanuo (2/11/20, 10:13 AM)
ipython parallel demo First start
ipython in cluster mode ipcluster start -n 4 from IPython.parallel...
by shantanuo (2/9/20, 9:02 AM)
djanog settings You may see
this message if you have DEBUG = True in your...
by shantanuo (2/9/20, 4:07 AM)
clear tmp folder Here is
following commands to clear unwanted stuff from the /tmp partition...
by shantanuo (2/8/20, 2:41 PM)
|