Database Administrator

Objective: to migrate the system from Oracle to Sybase. Command Overview: C: \ Documents ents and Settings \ newuesr> isql-helpSyntax Error in '-help '.Usage: isql [-B] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q][-A display_charset] [-A packet_size] [-c

After a whole day, I got more information by referring to n. Finally, I got it !!!!!!! To separate MySQL installation programs from data files in Linux, the first problem is the configuration during installation, . /Configure -- prefix

Apache originated from the NCSAhttpd server and has been modified many times to become one of the most popular Web server software in the world. Apache is taken from the pronunciation of "a patchy server", which means a server full of patches,

When installing Fedora, select all the components to be selected, including Appache, mysql, and php. But when we manage the database, it is easier to have a graphical interface, so we have installed phpMyAdmin on our own and it is easy to

The format of the INSTR method isINSTR (source string, target string, start position, matching serial number) For example, in INSTR ('upgrade FLOOR ', 'or', 3, 2), the source string is 'upgrade FLOOR', the target string is 'or', And the start

I. Principle of master-slave Configuration: MySQL Replication is an asynchronous Replication process, from one Mysql instace (we call it the Master) to another Mysql instance (we call it the Slave ). The entire replication process between the Master

How to restore damaged online logs Corrupt non-current online logs It is clear that online logs are divided into current online logs and non-current online logs. the corruption of Non-current online logs is relatively simple. Generally, you can

I. A view acts as a virtual table. Views are available in binary releases from 5.0.1 and up.The view is supported from 5.0 and is a virtual table. It is supported in binary 5.0.1 and later versions. 2. Updatable and Insertable Views-update and

How to evaluate a company's database O & M level? What is used for horizontal and vertical comparison? What is the goal of automated platform construction? The corresponding indicator system must be provided for guidance and must meet the following

Introduction: Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup. Xtrabackup has two main tools: xtrabackup and innobackupex. (

Description of each process in Oracle Important processes: SMON, PMON, DBWn, LGWR, CKPT, and ARCn SMON: This process is used for data rediscovery. This process is mainly responsible for inspecting the system and cleaning the system,PMON: Used to

Since Mysql5.1, the partition function has emerged. Table Partitioning is like dividing a large table into several small tables. You do not need to perform full table scanning when performing a query, you only need to query the table partitions that

Mysqlslap can be used to simulate server loads and output timing information. It is included in the MySQL 5.1 release package. During testing, you can specify the number of concurrent connections and SQL statements. If no SQL statement is specified,

After half a month of configuration and learning about the physical standby database of Oracle replicaset uard, although the version uses Oracle 11g (11.2.0.3), the configuration process still applies to Oracle 10g. During the last 10 dataguard

Environment Description:Operating System: RedHat 5.3 64bitOracle version: 10.2.0.1 SID: search6 After the database is installed today, after you create a database through dbca, the following error is reported during the time when you start and

Note: server, ip, and system planning are not performed for this installation. Objective: To learn how to install weblogic11g without graphics in linux Java version of the official website; http://www.Oracle.com/technetwork/java/javase/archive-139210

The mysql configuration file is my. cnf, which is located according to the settings during installation.When the mysqld service is started, the configuration file is read in a certain order by default. [Root @ zhu2 ~] #/Opt/mysql/libexec/mysqld --

Create a Data Group All group functions treat the table as a large information group. However, you sometimes need to divide the table into several smaller groups. You can use the group by clause to complete this task. Create a Data GROUP: group

Abstract: This article introduces two global ID generation solutions for the Distributed Environment. Directory: 1. database auto-increment ID-solution from Flicker2. independent applications-solutions from Twitter In large Internet applications, as

An online query is simplified as follows:Selectdt, count (distinct c1), count (distinct case when c2> 0 and c1 = 0 then c1 end ), count (distinct case when c2> 0 and c1> 0 then c1 end) from t where dtbetween '000000' and '000000' group by dt;The