MySQL – Optimization Overview
The most important part for getting a system fast is of course the basic design. You also need to know what kinds of things your system will be doing, and what your bottlenecks are. The most common bottlenecks are: Disk…
MySQL Replication Setup On Linux
Introduction: The purpose of this document is to describe the procedure to configure various replication setups. Guidelines: • It is recommended to take MySQL dump on master server when there is no activity. However it is not possible to stop…
There is no reason at all to use MySQL !
MySQL was once the most popular open source database (it still is), but it’s popularity and deployment is declining under the ownership of Oracle. The founder of MySQL Michael Widenius “Monty” was not happy when Oracle announced to acquire MySQL…
How to do Yahoo! Cloud System Benchmark (YCSB) for Oracle DB
Yahoo! Cloud System Benchmark (YCSB) for Oracle DB :- Sample Reports Description W/T – secs Threads# 10 Threads# 25 Threads# 30 Threads# 50 Update heavy workload (50%R : 50% W) Workload# a 1777…
Writing database commands output to a file using Linux `tee` Command.
# mysql -u root -h 127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.8 MemSQL source distribution (compatible; MySQL Enterprise & MySQL Commercial) Copyright (c) 2000, 2011, Oracle…
MySQL DBA Complete reference book
You can download MySQL DBA complete reference from below link http://dbversity.com/wp-content/uploads/2014/10/MySQL_DBA_Complete_Reference.doc
PostgreSQL Installation
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later. PostgreSQL…