Thanks to antville.org
Monday, 9. February 2015
download Enterprise backup

1) Access My Oracle Support.
2) Click on Patches & Updates navigation tab near the top of the screen.
3) In the Patch Search section, click on the Product or Family (Advanced Search) link
4) Type MySQL Enterprise Backup into the Product drop down list
5) select the latest release
6) Click the Search button.

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


Saturday, 6. December 2014
disable innodb

The MySQL server can still be started without InnoDB in 5.6 using the following options

skip-innodb
default-storage-engine=myisam
default-tmp-storage-engine=myisam

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


Sunday, 17. August 2014
Yahoo Trip planner

Yahoo has shut down Trip planner and My Travel service that was part of "Yahoo Travel". They announced it around March 6th and shut it down on March 21, 2014. Yahoo did not send any mail to that effect or I must have missed it. Any way there is no reason to log in to yahoo anymore :)

http://tinyurl.com/m8rqc47

Update:

I can see that I have got a mail on Feb 28 about this closure of Yahoo My Travel. 20 days notice is not enough even if I am not a paying customer.

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


Monday, 30. June 2014
Type Marathi on Ubuntu

Here are the steps to install Marathi input method for Ubuntu.

sudo apt-get install ibus
sudo apt-get install ibus-m17n ( this package contains tables for Indic languages)
sudo apt-get install ibus-qt4 (if you are using KDE desktop)
sudo apt-get install ibus-gtk (if you are using GNOME desktop)
sudo apt-get install im-config

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


Monday, 10. February 2014
Tokudb and proxy on the same server

# Here are the 2 steps to start tokudb
cd /root/percona-5.5.30-tokudb-7.0.1-fedora-x86_64/
./bin/mysqld_safe &

# start proxy with failed query log
sh /usr/share/mysql/mysql-proxy-0.8.3-linux-rhel5-x86-64bit/bin/mysql-proxy --plugins=proxy --proxy-lua-script=/usr/share/mysql/mysql-proxy-0.8.3-linux-rhel5-x86-64bit/share/doc/mysql-proxy/failed-query.lua

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


Saturday, 25. January 2014
Why not blog or text columns?

BLOB/TEXT columns are stored in an external hidden table. First 256B are stored inline in main table. Reading a BLOB/TEXT requires two reads. One for reading the Main table + reading from hidden table.

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


Thursday, 23. January 2014
Creating a new repository

Create a new repository on the command line

touch README.md
git init
git add README.md
git commit -m "first commit"
git remote add origin git@github.com:shantanuo/vivac.git
git push -u origin master

Push an existing repository from the command line

git remote add origin git@github.com:shantanuo/vivac.git
git push -u origin master

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


Tuesday, 21. January 2014
Percona xtrabackup commands

/ Tar-compatible file
innobackupex-1.5.1 --stream=tar ./ > backup.tar

/ Compress
innobackupex-1.5.1 --stream=tar ./ | gzip - > backup.tar.gz

/ Copy to remote host
innobackupex-1.5.1 --stream=tar ./ | ssh vadim@desthost "cat - > /data/vol1/mysqluc/backup.tar“

/ set up slave
innobackupex-1.5.1 --stream=tar /tmp/ --slave-info | ssh user@DESTSERVER "tar xfi - -C /DESTDIR“

innobackupex-1.5.1 --apply-log --use-memory=2G /DESTDIR

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


Friday, 20. December 2013
Create a Reverse SSH Tunnel

on Remote server:
ssh -fN -R 7000:localhost:22 username@yourMachine-ipaddress

Now do an ssh connection request from your machine to your own machine at port 7000:
ssh username@localhost -p 7000

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


Sunday, 15. December 2013
Innodb Monitor table

Monitor table is a way of communicating directly to the InnoDB storage engine by creating a table of a special name.
Additional debugging information is then written to MySQL’s error log. For example:

CREATE TABLE innodb_monitor (a INT) ENGINE=INNODB;

/* view to the error log */

DROP TABLE innodb_monitor;

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


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

Search
Calendar
November 2024
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
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