Database Administrator

Xtrabackup is an open-source project of percona to implement the innodb Hot Backup function similar to InnoDB's official Hot Backup tool. It can quickly back up and restore mysql databases. Xtrabackup contains two tools: Xtrabackup is a tool used

I. Overview Development Environment: PHP 5.3.0 +/Symfony 1.4.4/DoctrineMongoDBODM 1.0.0/MongoDB 1.4.4 Tip: This article requires you to understand the following content: PHP namespace, Symfony framework, MongoDB, and Doctrine ODM (download ODM)For

In order to learn, the verify_function function of the database is enabled, and the password expiration time of the default profile is automatically set to 60 days, the password is reused for 18000 days, And the Password meets the complexity

Restrictions on table space that can be transferred: The table space technology cannot be applied to system tablespaces or objects owned by sys users. In the transmission tablespace, The tablespace must be self-contained. The self-contained table

The concept Data Model (Conceptual Data Model) is also known as the information Model. It is based on the object-link theory and expanded. It models the information Data from the user's perspective, it is mainly used for Conceptual Design of

Oralce: [Function description]: the current system time is automatically inserted into the getSysDate table every minute. [1. Create a test table] Create table getSysDate (test date ); [2. Create a stored procedure for scheduled execution] Create or

Among Java and Oracle, the most common method is to call the Oracle stored procedure. The following briefly describes how Java calls the Oracle stored procedure. I. Java calls the Oracle stored procedure [without output parameters] The process name

Affected MySQL 5.0 versions earlier than 5.0.70; MySQL 5.1 versions earlier than 5.1.28 /* Create table */create table 'certuserid' ('certuserid' int (11) not null auto_increment, 'userid' int (11) not null, 'certificateid' int (11) not null,

Compiling invalid objects is one of the common tasks of DBAs and database developers. The following two methods are provided to capture errors during compilation. I. Current Database Version Information and invalid objects 1. view the current

In practice, you need to replace the content of a field in a table in batches. The general thinking process is as follows: SELECT Replace str_replace UPDATE write In fact, this is a waste of resources and resource consumption. MYSQL has a

When creating a user,There is a default tablespace Parameter.You can view the viewDatabase_propertiesYou can see the corresponding information. SQL> select a. property_name, a. property_value from database_properties a where a. property_name like '%

I browsed the official Oracle webpage and unofficial ppt pages and briefly understood the high availability solution provided by Oracle. There are three main types: 1. RAC RAC, Real Application Clusters Multiple Oracle servers form a shared

Recently, there are a bunch of Delete statements to be executed. The 34 Delete statements are written as one PROCEDURE for execution, but the execution plan and time of a single DELETE statement cannot be seen during execution, think of using

SKIP OptionExcludes datafiles or archived redo logs from the backup set according to the criteria specified by the following keywords.Note: You can also specify this option in the backupSpec clause. OFFLINESpecifies that offline datafiles shocould

1. Sequence creation and description Create a sequence. The syntax format of the Oracle sequence is:Create sequence name[Increment by n][Start with n][{MAXVALUE/MINVALUE n | NOMAXVALUE}][{CYCLE | NOCYCLE}][{CACHE n | NOCACHE}]; 1) increment by is

# Set the execution encoding format to prevent garbled Characters During Chinese Export Export NLS_LANG = "AMERICAN_AMERICA.UTF8" # Load the Oracle client program to the environment variable. Note: This line must be added if the script is placed in

Recently, a field value of a character type in the Oracle database was used to convert it to a number and save it to another new field. Oracle has a ToNumber function, however, it should be noted that this function can only convert the string format

1: Data Export command Declare --- Create a data pump handle H1 number; Begin -- Create a user-defined Data Pump for schema backup H1: = dbms_datapump.open (operation => 'Port', job_mode => 'scheme '); -- Define storage files Dbms_datapump.add_file (

1. Create a tablespace1. Create a common tablespace to specify the initial size, which is automatically expanded. Maximum Size:(The maximum size of a single smallfile data file allowed by Oracle is 4194302 * blocksize, and the maximum size of a

Understand Oracle, create users, and understand data types! Goal: Understand the orale Database I. Data Types in Oracle: Number Type: A) number indicates the number type, but if there is a decimal number, it must be written as follows: number