Thanks to antville.org
Tuning MySQL

Getting the shell script:
wget https://launchpadlibrarian.net/78745738/tuning-primer.sh

Running:
sh tuning-primer.sh

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


Check for table corruption quick and fast

#!/bin/sh

for dbname in `mysqlshow | awk '{print $2}'`
do
mysqlcheck $dbname ticket -Fq
done

# call this shell script and find the errors
time sh check.sh | grep error

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


shell script example

An example of shell script.
This will print numbers 0 to 500 in one line.

#!/bin/bash
Z=0
LIMIT=500
while [ "$Z" -lt "$LIMIT" ]

do
echo -n "$Z... "
Z=$( expr $Z + 1 )
done
echo
exit 0

_____

ping the address received from positional parameter

#!/bin/bash

if [ $# -eq 0 ]
then
SITE="google.com"
else
SITE="$1"
fi

ping -c 2 $SITE > /dev/null
if [ $? != 0 ]
then
echo $(date +%F) ... Network Failure!
fi

_____

Here is the script that will loop two thousand times and print the statement on the screen.

#!/bin/sh

MAX=2000
i=1
echo " truncate table t1; "

while [ $i -le $MAX ]
do
echo " insert into t1(f1) values($i); "
i=`expr $i + 1`
done

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


Match Operator in AWK

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
bin:x:1:1:bin:/bin:/sbin/nologin
daemon:x:2:2:daemon:/sbin:/sbin/nologin
adm:x:3:4:adm:/var/adm:/sbin/nologin

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


Copy table

#!/bin/sh
for i in `find /var/lib/mysql/test/ -name "Table1.*"`
do
cp $i `dirname $i`'/test'`basename $i`
done

# duplicate a table Table1 by coping the files if it is a MyISAM table.

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


Brace Expansion

Brace expansion is used to generate arbitrary strings. For e.g.
ls mysql*.0000{1..3}

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 mysql.log mysql.log.bak

cp $da.log{.bak,}
>> cp 2010-05-28.log.bak 2010-05-28.log

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


User input in shell script

#!/bin/sh
unset REPLY
until [[ $REPLY ]]; do read -p "Enter your name: "
done
echo "welcome $REPLY"

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


Inernal File Separator

The safe way to change IFS in a 'while read' loop is:

while IFS=\| read a b c
do
: whatever
done

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


valid date

validdate.sh script will look like this...

#!/bin/sh
userdate=$1
date -d $userdate &> /dev/null
if [ $? -ne 0 ] ; then
echo You entered an invalid date, $userdate
else
echo The date $userdate is valid
fi

# sh validdate.sh 2009-33-44
You entered an invalid date, 2009-33-44

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


better code

`test -s /var/log/mailme.txt`
if [[ $? -eq 0 ]] ; then
The above 2 lines can be written in one line as shown below:

if [[ -z /var/log/mailme.txt ]]; then

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


Online for 8143 days
Last modified: 10/13/24, 10:18 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
December 2024
SunMonTueWedThuFriSat
1234567
891011121314
15161718192021
22232425262728
293031
October
Recent updates
Extract words Extract all incorrect
words in first.txt file and all correct ones in second.txt...
by shantanuo (10/13/24, 10:18 AM)
Remove hyperlink in LO writer
1) Select "Internet Link" from Character styles. 2) Right click...
by shantanuo (10/9/24, 8:09 AM)
Templates in LO writer 1)
File > Templates > Save as Template 2) Give it...
by shantanuo (10/9/24, 8:07 AM)
discretize continuous features You can
"discretize" or "bin" continuous features into categorical features. from sklearn.preprocessing...
by shantanuo (4/24/24, 9:33 AM)
User Defined Property You
can create User Defined Property in libreoffice writer. File – Properties...
by shantanuo (1/9/23, 8:52 AM)
Arranging Chapters in the Navigator
To use a custom paragraph style for a heading, choose...
by shantanuo (1/4/23, 8:26 AM)
Use focus mode using Android
phones Settings > Digital Wellbeing and parental controls. Tap your...
by shantanuo (1/1/23, 3:59 AM)
Embed Fonts in document If
you use a font that the recipient is unlike to...
by shantanuo (12/18/22, 10:07 AM)
Using Navigator in Writer To
open the Navigator, select View > Navigator, or press the...
by shantanuo (12/18/22, 10:06 AM)
More about hyphenation The settings
for Tools > Options > Language Settings > Writing Aids...
by shantanuo (12/18/22, 10:04 AM)
link or unlink template If
you are using Libre office then template changer extension is...
by shantanuo (12/16/22, 5:27 AM)
Finding Styles you can select
Edit > Find and Replace > Other Options > Paragraph...
by shantanuo (12/14/22, 7:17 AM)
regex in clac In LibreOffice
Calc, you can use function REGEX for e.g. Begins with...
by shantanuo (12/14/22, 4:40 AM)
Libre Calc tips Turn Off
Grid Lines If you want to turn off grid lines...
by shantanuo (12/13/22, 8:14 AM)
More about Styles You can
goto View - Styles and change "All Styles" to "Applied...
by shantanuo (12/13/22, 7:49 AM)
Page Break Before Every Chapter
If your chapter titles are using the "Heading 2" Style:...
by shantanuo (12/13/22, 6:36 AM)
View and print in different
color Displaying Color in LO but Printing as White Page...
by shantanuo (12/13/22, 6:26 AM)
Change Normal Template in Libreoffice
Writer 1) Open a new file and set your font;...
by shantanuo (12/12/22, 8:45 AM)
Short english words in Devanagari
The list of short english words written in Devanagari. #...
by shantanuo (10/5/22, 9:05 AM)
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)

RSS feed

Made with Antville
Helma Object Publisher