Thanks to antville.org
schema conversion tool

This seems to be a useful tool to convert mysql or oracle schema to redshift. select queries can also be migrated easily using...

www.sqlines.com

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


Install percona extra backup tool innobackupex

Steps to install innobackupex on Ubuntu:

$ apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

Add this to /etc/apt/sources.list, replacing VERSION precise with the name of your distribution:

deb repo.percona.com precise main
deb-src repo.percona.com precise main

Remember to update the local cache:
$ apt-get update

Now you can install Percona XtraBackup with:
$ apt-get install percona-xtrabackup

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


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


Install SQLite

$ # As of March 2009, the latest version was 3.6.11.
$ wget www.sqlite.org
$ tar xzf sqlite-amalgamation-3.6.11.tar.gz
$ cd sqlite-3.6.11
$ ./configure && make
$ sudo make install

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


skip networking in MySQL

When there is maintenance work to be carried on the database server, you can simply skip networking so that no connection from any other server from the network will be accepted.
Simply enter the following in /etc/my.cnf:

[mysqld]

Prevent network access to MySQL.

skip-networking

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


Saving data to text file

sqlite> .mode list
sqlite> .separator |
sqlite> .output test_file_1.txt
sqlite> select * from tbl1;
sqlite> .exit
$ cat test_file_1.txt
hello|10
goodbye|20
$

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


Innodb troubleshooting

When you have your mysql up and running, just connect to any database (like mysql or test) and perform a following command:

CREATE TABLE innodb_table_monitor(x int) engine=innodb;

This will force innodb engine to start table monitor and dump some useful data regarding your tablespaces in mysql's error log

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


optimize all tables

mysql -e"SELECT CONCAT('OPTIMIZE TABLES ', GROUP_CONCAT(TABLE_SCHEMA, '.', TABLE_NAME ORDER BY TABLE_SCHEMA, TABLE_NAME SEPARATOR ',')) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbname' GROUP BY TABLE_SCHEMA\G
" | awk -F: '{print $2}' | mysql

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


Online for 6728 days
Last modified: 12/21/20 8:13 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
January 2021
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
31
December
Recent updates
Preserve seeds 4
types of seeds to be preserved for next season. 1) Ramphal https://www.amazon.in/dp/B00KTG8KQ6/?coliid=I3GKU4J9VLPZ6O&colid=RHNWRLPIY54W&psc=1&ref_=lv_ov_lig_dp_it...
by shantanuo (12/21/20 8:13 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)
change your server time to
IST If you need to change your server clock to...
by shantanuo (2/8/20 2:39 PM)
Transfer root emails to another
email address If you have root access to the server...
by shantanuo (2/8/20 2:32 PM)
special strings in cron Instead
of the first five fields, you can use any one...
by shantanuo (2/8/20 2:30 PM)
LibreOffice version conflict I am
not able to install latest version of Libre office. I...
by shantanuo (1/29/20 9:15 AM)
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20 12:24 PM)
compare mysql schema And here
is poor man's schema compare using good old diff command......
by shantanuo (1/26/20 11:49 AM)

RSS feed

Made with Antville
Helma Object Publisher