Database Administrator

Database Backup is an important means to ensure database security. Most database administrators have discovered the importance of backing up databases, and even have great dependence on them. Therefore, the database administrator must ensure that

A Linux job needs to compile a MySQL by itself, but there is already a MySQL on my system. Compile another one. The most troublesome thing is not to compile, but to make the two coexist. There is no difference between the previous compilation

In Fedora 11, it is difficult to install the source code MySQL. The installation process was recorded here for a long time. Ps: the directory paths involved in this article are all my local directories. You can adjust them by yourself. Ps: I use 5.1.

As we all know, the MySQL InnoDB Storage engine is very similar to Oracle and supports transactions and row-locking. After actual tests, a big difference between innodb and oracle is: the same data, the length of innodb single-row storage is

Table A records the following:AID aNum1 a200501112 a200501123 a200501134 a200501145 a20050115 Table B records the following:BID bName1 20060324012 20060324023 20060324034 20060324048 2006032408 The experiment is as follows:1. left joinThe SQL

Preface:It is not difficult to specify a data type for a column. It is difficult to specify a suitable data type. For the same string type, choose a fixed length or a variable length, among which there are many articles. Therefore, you need to

The business description is as follows: When inserting a table under Oracle, you must update the value of another field based on the value of one field. Of course, it can also be implemented through a program, but this field is only used for data

I have heard of the restoration (restore) database, tablespace and database files, and the use of archive log recovery (recover) database, tablespace, and database files. Restore. What about restoring archived logs? Yes, we may ignore the archive

Background Due to the influence of traditional RDB, most developers may have a mindset for designing database tables. In the context of cloud computing and big data, RDBMS is approaching the limit, and KV storage will attract more and more attention.

Today, when migrating the zabbix database, a shared tablespace cannot be released. because mysql uses the innodb Storage engine by default, when a large data volume is deleted, because of the Force interruption, the shared tablespace cannot be

1. Oracle 11g R2 installation manual (Graphic tutorial) For Windows Before installation, you must confirm the following points: There is no problem with your memory (this is very important, if your machine is often blue screen, then don't install it,

There is an automatic backup script program that asks rman. I have previously written an automatic backup case for the exp backup specific solution (Oracle automatic backup case on Linux platform (using exp tool )), now I want to add the rman

I. Syntax:TRANSLATE (string, from_str, to_str)Ii. PurposeReplace each character in from_str with a string after the corresponding character in to_str. TRANSLATE Is a superset of the functions provided by REPLACE. If from_str is longer than to_str,

After 10 Gb of Oracle, two features OFA and OMF are introduced in terms of directory structure and file management. OFA (Oracle Flexiable Architecture) is a feature of directory structure constraints. The directory structure distribution of

Obtaining the Oracle SQL Execution Plan and viewing the execution plan are the basic skills to master and judge the database performance. The following example describes how to view SQL Execution plans: There are basically the following methods: 1.

1. First add three Disks 2. Installation Package [Root @ myorcl asm] # ls Oracleasm-2.6.18-348.6.1.el5-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-348.6.1.el5debug-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-348.6.1.el5PAE-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-3

Introduction to XtraBackup XtraBackup replaces the innodbbackup tool, and XtraBackup is fully compatible with the innodb Storage engine, and implements full physical layer hot backup for the innodb Storage engine. Site:

There are many ways to view execution plans. I will introduce them one by one in my blog in the future. This article describes the first method. You can use the explain plan command to view the execution plan. 1. log on to the database with an hr

Generally reported ORA-00054, it is likely that the object is locked, this error is generally "the resource is busy, but the specified way to obtain resources in NOWAIT, or timeout failure ", the solution is as follows: 1. query which objects are

In the Oracle environment, PL/SQL is the best way for us to implement business logic, and it is also the best language to combine with the Oracle database itself. Using PL/SQL itself can greatly improve our work efficiency. From the very beginning