Database Administrator

MySQL replication on Ubuntu12.04 I. Introduction MySQL Replication is based on the binnary logging mechanism to synchronize data between the master and slave. Both mechanism, configuration, and operation and maintenance are much simpler and more

Oracle index tablespace data file loss and Reconstruction Re-create index:Use the following options to shorten the time required to create an index: PARALLEL NOLOGGING PARALLEL (NOPARALLEL is the default value): multiple processes can work together

MySQL Status variable) The MySQL status variable is the system status information accumulated after the current server is started. It is mainly used to evaluate the usage of the current system resources to further analyze the system performance and

Overview of Oracle Architecture From the Oracle Server Architecture Overview, I found an introduction to the Oracle architecture, which is used to describe the overall Oracle architecture. Overview of Oracle Server Architecture 1 Oracle databases

Risks of incorrect selection of Oracle Database Design Field Types An Oracle data type is inaccurate. We will construct a table storage date field, a storage varchar2 field, and a storage date field for a test. I have also written the

Two methods for processing the variant table (ORA-04091) in Oracle Oracle often used trigger often appears ora-04091 variant table problem, here bring two kinds of processing methods for your reference. -- ***** Example *****Scenario Description:-- 1

Batch create log table information scripts in mysql, mysql logs In mysql, the script for creating log information tables in batches through the stored procedure is as follows: drop PROCEDURE if EXISTS reqSp;DELIMITER //create procedure reqSp(sTime

11gR2RAC environment DBCA create database error ORA-15055 ORA-15001, 11gr2racdbca 11gR2RAC environment DBCA create database error ORA-15055 ORA-15001   Symptom: After 11gR2 GridInfrastructure and Database software are installed, the following error

Expdp export multi-path and expdp export pathI. Preface:Some users do not use RMAN for Backup recovery because the DBA level is not too high, training RMAN for on-site engineers or users will lead to additional expenses and unnecessary troubles.

Use commands to create an oracle11G database and an oracle11g Database This document describes how to create an oracle database that complies with the OFA specification using the create database Command of the oracle database. 1. Set the environment

Basic MySQL Data Table operation 2: Table Structure View, modification and table operations, basic mysql operations 1. view the data table structure 1) view the basic table structure statement DESCRIBE Syntax:DESCRIBETable Name; Example: mysql>

Basic operations on MySQL Data Tables and basic operations on mysql DATA The following outlines are provided in advance, and details and examples are provided tomorrow: 1. Create a data table 1) Create Table syntax 2) use primary key constraints 3)

Use navicat to export the data table structure and insert statement, navicatinsert After using navicat for a while, it was found that navicat is indeed very convenient and supports multiple databases. I used to think that his SQL files are

Insert data to the database (ORACLE) through excel, exceloracle We all know that PL/SQL can copy data to excel, and we can also insert data to the database through excel. The following is a simple example and example. First, create a table named

Beyond Compare 2 Comparison. mdb (ACCESS) database setting method, compare. mdb When Beyond Compare 2 is installed by default, the. mdb (ACCESS) database cannot be compared. You need to modify the settings before you can intuitively Compare the. mdb

MySQL function learning notes 1: mathematical functions and mysql learning notes 1. ABS (x): returns the absolute value of x. Mysql> select ABS (1), ABS (-1), ABS (0 );+ -------- + --------- + -------- +| ABS (1) | ABS (-1) | ABS (0) |+ -------- + --

Risks of incorrect selection of Oracle Database Design field types, oracle Fields A hidden danger of inaccurate data types. The following constructs a table storage date field, one storage varchar2, and one storage date for a test. I have also

WARNING: Heavy swapping observed on system in last 5 mins., swappingmins When I checked the alert Log today, I found the following error: Pct of memory swapped in [7.16%] pct of memory swapped out [0.56%].Please make sure there is no memory pressure

SQL checks whether Stored Procedures contain keywords. SQL stored procedures Select. name from sys. ALL_OBJECTS A, SYS. SQL _MODULES B WHERE. IS_MS_SHIPPED = 0 and. OBJECT_ID = B. OBJECT_ID and. [TYPE] IN ('P', 'V', 'af') AND [DEFINITION] LIKE '%' -

After the ib_logfile and ibdata1 parameters in MySQL are modified 1. Environment Description RHEL 6.4 x86_64 + MySQL 5.5.37 and MySQL 5.6.19 Blog: http://blog.csdn.net/hw_libo/article/details/39215723 2. Case: The redo log file (ib_logfile) size