[ postgres @ dbversity : /YCSB-master ] ls -lhtr total 2.4M -rw-r–r– 1 postgres postgres 479 Aug 18 2014 NOTICE.txt -rw-r–r– 1 postgres postgres 7.9K Aug 18 2014 LICENSE.txt -rw-r–r– 1 postgres postgres 2.6K Aug 18 2014 CHANGELOG drwxrwxrwx 2…
We can calculate the replication lag by comparing the current WAL write location on the primary with the last WAL location received/replayed by the standby. They can be retrieved using pg_current_xlog_location on the primary and the pg_last_xlog_receive_location/pg_last_xlog_replay_location on the standby,…
Postgres installation : [ root @ masterhost : ~ ] yum install postgresql postgresql-server http://guegs3.nam.nsroot.net/SOELinux/repos/prod/soe6gdeproducts-x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 – “The requested URL returned error: 404 Not Found” Trying other mirror. Setting up Install Process Resolving Dependencies –>…
mysql> select * from test; +——+———————+ | id | name | +——+———————+ | 1 | /root/path/to/leaf | | 1 | /var/lib/mysql/data | +——+———————+ 2 rows in set (0.00 sec) mysql> mysql> select id,name, SUBSTRING_INDEX(name, ‘/’, 2) as first_val, SUBSTRING_INDEX(name,…
MemSQL_4.0_Installation_thorough_memsql_ops
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr total 16M -rw-r–r–. 1 501 games 479 Feb 18 2012 NOTICE.txt -rw-r–r–. 1 501 games 7.9K Feb 18 2012 LICENSE.txt drwxrwxrwx. 2 501 games 102 Feb 22 2012 workloads -rw-r–r–. 1 501 games 2.3K Feb 23…
MySQL General Log : The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general…
[root@dbversity ~]$ /opt/mongodb/bin/mongo MongoDB shell version: 2.6.9 connecting to: test > > // To simulate write (inserts) transactions > for(var i = 1; i <= 10000000 ; i++){db.test_collection.insert({“_id” : i , “action” : “write transaction simulations”, ” iteration no:” :…
[root@ip-10-0-0-67 ~]# cd /home/ec2-user/ [root@ip-10-0-0-67 ec2-user]# ll -lhtr total 100M -rw-r–r–. 1 root root 95M Feb 24 2012 ycsb-0.1.4.tar.gz -rw-rw-r–. 1 ec2-user ec2-user 809K Jul 7 03:57 oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]#…
Official website : http://3t.io/ Compare databases, collections and documents: discover differences in your data. See the differences, side by side: visualize comparison results. Built in synchronization: synchronize databases, collections, and fields. Explore the schema of your MongoDB data: find outliers and…