Database Administrator

For all relational databases, the optimizer undoubtedly makes the core part of it, because the optimizer is responsible for parsing SQL, And we all access data stored in relational databases through SQL. The quality of all optimizers directly

Install configuration parameters [root@monser Percona-Server-5.5.34-rel32.0]# cmake . -DCMAKE_INSTALL_PREFIX=/service/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/service/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock

It provides multi-version parallel control, supports almost all SQL components (including subqueries, transactions, and user-defined types and functions), and provides a wide range of (Development) language binding (including C, C ++, Java, perl,

The following are common SQL statements used by SQL Server and Access to operate database structures.The content is organized by HAI wa. if the content is incorrect or incomplete, please submit it. Thank you.Create a table:Create table [table name]([

I. unreasonable index design---- For example, a table with 620000 rows of record and rows with different indexes has the following SQL statements:---- 1. A non-cluster index is created on date.Select count (*) from record where date>'20140901' and

I. Description 1. Database Information Operating system version: OEL6.5 x64Database Version: Oracle 11.2.0.4 x64 RAC This document describes how to change the publiic/private/VIP/scan IP address on oracle 11.2.0.4 x64 for OEL6.5. The detailed

1. General steps The steps for creating a standby database through RMAN backup are roughly as follows: 1) set the primary database to force loggin Mode 2) set the primary database to archived log mode. 3) configure the parameter files for the master

  Active Directory snapshot Management Through the Active Directory snapshot function, we can easily see the information in the original AD before recovering the AD information, such as users, groups, OU and other information. Let's do

Many projects use latin1 encoding to store Chinese data because engineers are not rigorous or have insufficient levels to choose wrong database encoding during initial construction. As the complexity of the project increases, various coding problems

On a production AIX server, the DB2 database needs to be backed up. The SQL2059W error is reported in the backup. The details are as follows: $ Db2 backup db happydb online to/backup include logsSQL2059W A device full warning was encountered on

Recently, it was found that there are too many logs in the binlog directory of mysql, and the disk space is full, resulting in Website access failure. -Rw ---- 1 mysql 1073742161 May 31 binlog.20.21 -Rw ---- 1 mysql 1073742892 May 31

When you receive an SMS alert, both databases report slave synchronization failure. First, describe the environment, architecture: lvs + keepalived + amoeba + mysql, master-master replication, and single write,Master 1: 192.168.0.223 write) Master 2:

Dynamic Setting of variables may cause unexpected side effects, such as refreshing dirty blocks from the buffer. Be careful with the settings that can be modified online, because they may cause the database to do a lot of work. Sometimes, you can

Sheng Ge 1.1 million drops on Data Guard past and present Note: More details are available ~ 116 page From birth-> out-of-service full-lifecycle DG edition [departure form] 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/22

Complete mysql backup and recovery practices 1. Environment Settings between backup Databases 1. Create Database test1, create table tt, and insert the following data mysql> create database test1;Query OK, 1 row affected (0.04 sec)mysql> use

1. select an appropriate ORACLE optimizer There are three optimizer types in ORACLE: A. RULE (RULE-based) B. COST (COST-based) c. CHOOSE (selectivity)Set the default optimizer. various declarations of the OPTIMIZER_MODE parameter in the ora file,

Preface In a single application environment or system with relatively simple business, the bottleneck of system performance problems is often self-evident. The premise for solving the problem is that locating the problem is easier to solve, however,

We all know that informix requires logs. However, we will discuss the usage and significance of each log as follows: The first thing to note is that there are two types of informix logs: Physical logs used to store the front image of data, and

Only with a clear understanding of these issues can we select a suitable connection method for specific query needs and develop robust database applications. Selecting an appropriate table connection method has a crucial impact on the performance of

1. Use the Thin driver in client software development In terms of Java software development, Oracle database provides four types of drivers, two of which are used for application software, applets, servlets, and other client software, the other two