Database Administrator

OLTP performance adjustment and optimization-conclusion According to the waterfall model of the software life cycle, the performance of an application has been qualitative in its design stage. If you think of optimization only after the application

Server: 1. Establish nfsvg, file system/nfsserver on the P670 Server 2. # mount/nfsserver 3. Edit the/etc/hosts file on 670 and add NFS client information. 10.60.64.41 IRIS 4. edit/etc/exports /Nfsserver-rw, root = IRIS, access = IRIS 5.

I. Index Analysis According to the description in the ORACLE document, rebuild the index as follows: 1. analyze index your_index_name validate structure; 2. query index fragmentation: Select name, del_lf_rows, lf_rows, round (del_lf_rows/(lf_rows + 0

1. An error is reported when the database is started. [Oracle @ servers ~] $ Rlwrap sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on Sunday October 6 17:14:35 2013 Copyright (c) 1982,200 5, Oracle. All rights reserved. Already

#! /Bin/bash# Writed by sery 2012-05-16 ################################### ####### install depending packages ############################## ########### yum-y install binutils compat-libstdc ++-33 elfutils-libelf-devel glibc-common glibc-devel gcc

Recently, I have been studying mysql clusters and have to install and deploy at least two or more mysql databases. This is troublesome and time-consuming. Today I wrote a Shell script based on the Installation Steps, you only need to execute the

MicrosoftInternetExplorer402DocumentNotSpecified7.8Normal0 In MySQL 5.1.x, the process of creating and deleting clustered indexes is as follows: 1. Create an empty table with the same structure as the original table, and then create a clustered

My. cnf configuration file binlog_format = MIXED, and use the default isolation level REPEATABLE-READ, there is a major problem, resulting in master-slave data inconsistency. The following is an example: Both the master and slave databases are MySQL5

1) for ORACLE connection overrun modification, we need to adjust the maximum number of connections of the oracle database. The adjustment of the number of connections is made in the init. ora file in the dbs directory of the oacle.The number of

How to operate MySQL database instances using JSP I. Overview Before starting the introduction, let's talk about why we should write this article. I personally think that as an O & M engineer, we should be familiar with the knowledge network, not

Tutorial environment: ORACLE11GR2, CENTOS6.2 32-bit version removes the need to modify the redhat Yum source, ipset to 192.168.233.10, NAT Network), VM8.0 version For installation instructions, refer to the official website documents and some

Hugepages are you using it? ---- Concept Hugepages are you using it?----Test Cases Introduction The system process accesses the memory through a virtual address, but the CPU must convert it to the physical memory address to truly access the memory.

Case:To reduce the burden on the core database, we adopt the logical STANDBY technology to separate the impact of physical reading on the core database. However, a report application uses a large number of intermediate tables. Generally, the basic

 Summary of MySQL query table data size I. Data size of mysql tables   We know that mysql generally uses table space storage to store data files. When mysql uses the innodb Storage engine, Mysql uses table store data in two ways:

In general, DBA should focus on the SYSTEM, SYSAUX, UNDO, TEMP, and SYSTEM tablespaces in addition to the tablespace where business data is stored, the size of the UNDO and TEMP tablespaces is determined by the business conditions of the database.

Prerequisites Hadoop cluster is successfully built. Here we use Hadoop1.0.3 + HBase0.94.1 Configure HBase 1. Modify conf/hbase-env.sh and add jdk support Export JAVA_HOME =/home/hadoop/jdk1.6.0 _ 39 2. Modify conf/hbase-site.xml hbase. rootdir

1. Permission System introduction: The implementation of the MySQL permission system is relatively simple. The relevant permission information is mainly stored in mysql. User, mysql. db, mysql. Host, mysql_table_priv, and mysql. column_priv tables.

Although the OUI graphical Installation Method of the Oracle database is relatively intuitive, the project jumps several times through the vpn in the Intranet environment, spanning several network segments and the data center is not local, therefore,

Recently, ORACLE databases in the unit are unstable. by querying the oracle alert Log, the following error message is displayed: Thread 1 cannot allocate new log, sequence 108922Checkpoint not completeCurrent log #1 seq #108921 mem #0: + DATADG/apts/

The method is as follows:1. first, make sure to back up the database to reduce or clear the database with log files) 2. right-click the database, select and open the "properties" window, find the "option" column, and change "complete" in the fault