Thanks to antville.org
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 :)

tinyurl.com

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


Thursday, 12. December 2013
Installing python as a single file
wget downloads.egenix.com

chmod 700 install-pyrun

mkdir /mypython

./install-pyrun mypython/

/mypython/bin/pip install boto

/mypython/bin/python

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


Thursday, 14. November 2013
connect to remote windows server
You need to go to start - run and type this command:
mstsc

This will start Remote Desktop connection wizard that will allow you to connect to remote windows server.

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


Online for 4411 days
Last modified: 8/17/14 9:34 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
September 2014
SunMonTueWedThuFriSat
123456
78910111213
14151617181920
21222324252627
282930
August
Recent updates
Yahoo Trip planner Yahoo has shut down Trip planner and My Travel service that was...
by shantanuo (8/17/14 9:34 AM)
Type Marathi on Ubuntu Here are the steps to install Marathi input method for Ubuntu....
by shantanuo (6/30/14 12:10 PM)
Tokudb and proxy on the same server # Here are the 2 steps to start...
by shantanu oak (2/10/14 7:16 AM)
Why not blog or text columns? BLOB/TEXT columns are stored in an external hidden table....
by shantanu oak (1/25/14 2:48 PM)
Creating a new repository Create a new repository on the command line touch README.md git...
by shantanu oak (1/23/14 5:24 PM)
Percona xtrabackup commands / Tar-compatible file innobackupex-1.5.1 --stream=tar ./ > backup.tar / Compress innobackupex-1.5.1 --stream=tar...
by shantanu oak (1/21/14 3:03 PM)
Create a Reverse SSH Tunnel on Remote server: ssh -fN -R 7000:localhost:22 username@yourMachine-ipaddress Now do...
by shantanu oak (12/20/13 9:56 AM)
Innodb Monitor table Monitor table is a way of communicating directly to the InnoDB storage...
by shantanu oak (12/15/13 5:59 AM)
Installing python as a single file wget https://downloads.egenix.com/python/install-pyrun chmod 700 install-pyrun mkdir /mypython ./install-pyrun mypython/...
by shantanu oak (12/12/13 6:30 AM)
connect to remote windows server You need to go to start - run and type...
by shantanuo (11/14/13 5:40 PM)
Adding swap The following example will add 1 GB of swap file to your Linux...
by shantanuo (11/11/13 4:28 PM)
Starting mysql When you have installed mysql from source, you will need to change the...
by shantanu oak (9/29/13 4:23 PM)
avoid key prompt Here is a simple tip that will avoid RSA key fingerprint authentication....
by shantanu oak (8/8/13 3:40 AM)
mysql troubleshooting The following information is required to analyse any mysql issue 1. my.cnf configuration...
by shantanuo (7/29/13 2:28 PM)
Killing mysql Here are a few ways to kill mysql process. mysqladmin shutdown kill -TERM...
by shantanuo (6/28/13 4:03 AM)
Improve InnoDB performance innodb_flush_method=O_DIRECT innodb_file_per_table innodb-flush-log-at-trx-commit = 2 # number of cpus * number of...
by shantanuo (6/12/13 3:36 PM)
More about git ## getting started git init git add index.html git commit -m"my first...
by shantanuo (6/9/13 2:48 PM)
Managing top While the output of the top command displayed, press F, which will display...
by shantanuo (6/4/13 10:10 AM)
remove all files If you have problems to delete many files in a folder using...
by shantanuo (5/17/13 1:12 PM)
correcting date A few packages are dependent upon the server time. If the date is...
by shantanuo (5/14/13 12:37 PM)
Check for table corruption quick and fast #!/bin/sh for dbname in `mysqlshow | awk '{print...
by shantanuo (5/13/13 4:39 PM)
Know more about your server You can get information about the make, model and serial...
by shantanuo (5/13/13 1:03 PM)
mysql analysis When there is an issue, We should gather some preliminary data to analyze...
by shantanuo (5/13/13 6:07 AM)
Git Alias Consider setting up a simple Git alias for common but complex Git command...
by shantanuo (4/21/13 7:16 AM)
mysql to postgresql It is incredibly easy to migrate from MySQL to PostgreSQL. Just migrate...
by shantanuo (4/20/13 1:56 PM)

RSS feed

Made with Antville
Helma Object Publisher