Database Administrator

I. development componentsBefore introducing how to deploy the PB component to the Jaguar CTS server, we will first introduce how to develop a component using PowerBuilder 7. This step is very important because many options need to be set here, and

1. Upgrade the SLES9 kernel and install the asm package. Ensure that the version is consistent.2./etc/init. d/oracleasm configure the asm driver user as the oracle dba group and start automatically.3. Prepare the raw disk to use fdisk for

I. SQL Quick Start The Structure Query Language (SQL) is a standard language used to query relational databases. It includes several keywords and consistent syntax to facilitate database components (such as tables, indexes, and fields). The

Use an automated installer to automatically install MySQL New MySQL 5.0 users can use the MySQL Installation Wizard and MySQL Configuration Wizard to install Mysql on Windows. The purpose of designing these two wizard is to facilitate new users to

1. Table create table test (names varchar2(12),                   dates date,                   num   int,                   dou   double); 2. View create or replace view vi_test asselect * from test; 3. Synonyms

MySQL is a semi-commercial database widely favored by the Linux community. MySQL can run on most Linux platforms (i386, iSCSI, etc), as well as a few non-Linux or even non-Unix platforms. 1. license fee The popularity of MySQL is largely due to its

The global shared memory is mainly used for MySQL Instancemysqld processes) and the underlying storage engine to store various global operations and shared temporary storage information, such as Query Cache for Query Cache and Thread Cache for Cache

1. Create an informix group and an informix user; 2. Modify the $ HOME/. profile file of informix, and add:INFORMIXDIR =/usr/informix (main directory of informix) PATH = $ PATH: $ INFORMIXDIR/bin Export INFORMIXDIR Export PATH 3. modify the

1. Create an INFORMIX user group and an informix user home =/usr/informix 2. Add password to informix 3. Expand the informix Installation File: rpm-I *******************. rpm (three in total) 4. Modify the root profile and addINFORMIXDIR

1. OnLine Operation Mode Off-Line offline mode)Quiescent static mode)On_Line online mode)Shutdown mode)Recovery mode) The OnLine system has the following working modes: Offline mode: OnLine is not running, and shared memory is not

1. Accelerate SQL Execution 1. Use sort or join in the select statement If you have sorting and join operations, you can first select data to a temporary table and then process the temporary table. Because temporary tables are created in the memory,

"Data sharding" allows you to control data storage at the table level. "Table sharding" is a feature of the INFORMIX database. You can group records or indexes in a table and store the data in different locations. This allows you to store data on

There are many reasons for slow query speed. The following are common causes: 1. No index or no index is used (this is the most common problem of slow query and is a defect in programming)2. Low I/O throughput, resulting in a bottleneck effect.3.

About data input in the database ------------------- The inverse operation of load data infile in SELECT. Insert into table_name values (); is used to add records to the data table. this is a method. of course, you can also use the mysqlimport

The database is started. If you detect that the data file of the tablespace In the rollback segment is lost or damaged and the database is running, do not drop it down. In many cases, it is easier to start a database than to close it to solve the

In Soundbreak, we play live audio and video continuously 24 hours a day, so we cannot make a convincing test of the new replication feature of MySQL. Through tests, we found that this feature can be used to maintain data synchronization with the

Preface Human errors are one of the major causes of database system failures. According to the investigation, about 40% of system problems are caused by Operation errors or user errors, which are especially difficult to avoid. Traditionally, when

Introduction The Flashback database is a point-in-time (PIT) database restoration method. This Incomplete recovery policy can be used to restore a database that is logically damaged due to human errors. After being introduced in 10 Gbit/s, it is

There are two ways to back up SQL Server databases: one is to back up DATABASE files using BACKUP DATABASE, and the other is to directly copy the DATABASE files mdf and log files ldf. The following describes the backup and recovery of the latter.

As I mentioned earlier, I am still familiar with Oracle databases. In fact, I started to contact Oracle 15 months ago. I initially thought it odd that Oracle does not have an identity type and you cannot create an auto-incrementing column. It turns