Database Administrator

Linux MySQL dump program crashes. Follow the three simple steps below to easily solve the problem. 1. For Linux mysql dump, ensure that the directory where Coredump is stored exists and the process has write permission on the directory. The

Set two-way MySQL Data Synchronization I. Prepare serversBecause the binlog formats of different MySQL versions (Binary logs) may be different, the best combination is that the MySQL version of the Master is the same or lower than the Slave version,

REGEXP_LIKE (matching)REGEXP_INSTR (included)REGEXP_REPLACE (replace)REGEXP_SUBSTR (extract) For example, the expression of the mobile phone number: ^ [1] {1} [35] {1} [[: digit:] {9} $You can query customer information tables (tKHXX) that contain

RMAN is a backup and recovery tool provided by Oracle. It can be used to back up and restore database files, archive logs and control files. It can also be used to perform full or incomplete database recovery. RMAN can be controlled by the command

Test environment: VMware Workstation V6.5.1, Oracle Database 11g Release 2 (11.2.0.1.0) Enterprise/Standard Edition for Linux x86-X64 Intel Core2 P8700 2.53 gb cpu, 1 GB memory, 40 Gb hard disk. Use the Virtual Machine installation method. First,

If your machine already has an Oracle database, it is very simple. Navicat can be directly connected to Oracle. If it is not installed, Navicat will prompt you to install the Oracle client. If it is not necessary, do not install the Oracle client.

Important directories of Linux MySQL 1. Database directory/Var/lib/mysql/2. Configuration File/Usr/share/mysql (mysql. server command and configuration file)3. Related commands/Usr/bin (commands such as mysqladmin mysqldump)4. Start the

MongoDB-level data Insert, Query, and Delete performance tests (without or without indexing) Let's take a look at the testing machine performance (64bit ): Performance_^ [root @: ~] # Grep"Model name"/Proc/cpuinfo | cut-f2-d: Intel (R) Xeon (R)

Method 1: Use sqlplus 64-bit: [Oracle @ qs-wg-db2 ~] $ Sqlplus/as sysdba;   SQL * Plus: Release 10.2.0.5.0-Productionon Sun Sep 25 08:57:22 2011   Copyright (c) 1982,201 0, Oracle. All Rights Reserved.     Connected: Oracle Database 10g Enterprise

After Oracle11g is installed on disk D and oracle10.2.0.3. the error "perl58.dll" is not found when oracle11g is uninstalled on disk E. C: \ Users \ Liangwei>Set PERL5LIBPERL5LIB = E: \ oracle \ product \ 10.2.0 \ db_2 \ perl \ 5.8.3 \ lib \ MSWin32-

Today, we will introduce the entire process of installing Oracle 10 Gb in Red Hat Enterprise Linux AS 5.4. 1. Download Oracle 10g First, describe in detail my environment, system: Virtual Machine Red Hat Enterprise Linux AS 5.4, Database: Oracle

The restoration method for a database that loses archive log files is to extract data from a database that cannot be opened normally (because one or more database files are inconsistent with other files. Scenario: A disk is damaged and a database

Oracle RAC clusterRAC, short for real application clusters, is a new technology used in the new version of Oracle Database, It is a type of high availability and the core technology that Oracle databases support the grid computing environment. An

The following is a description of parameters in the my. cnf configuration file: [Client] Port = 3309Socket =/home/mysql/tmp/mysql. sock [Mysqld] ! Include/home/mysql/etc/mysqld. cnf # contains the configuration file and stores the user name and

Oracle does not have the date () function. The sysdate function value includes the time, minute, and second. It is really troublesome to insert the default value of the current time. You have to write the stored procedure on your own, and you cannot

Materialized View synchronization count 1. Usage Now we need to synchronize some data in the production database to the Data Warehouse. Considering the cost and convenience, we need to regularly refresh the materialized view for data synchronization.

To configure a Cluster, you must at least configure1 MGM (Management node) + 1 SQL node + 2 Data NodeMGM can share a machine with the SQL node, and the data node occupies a server separately.This requires at least three servers. Sometimes it will be

This is the second article in the series. In the first article, I used MySQL's built-in SSL support for stress testing, which produced some surprising results. Of course, it is expected that the throughput performance of queries using SSL is lower

A developer encountered an error: ORA-01795: the maximum number of expressions in the list is 1000 Statement is a select xxx from xxx where xxx in (xx, xx ,.....); Let's take a look at the error: 01795,000 00, "maximum number of expressions in a

Oracle 11g online recovery temporary tablespace -- Database versionSQL> select * from v $ version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit