Database Administrator

To save system resources, we usually stop some services and start them the next time we need them. However, we often forget. For example, the MSSQL database that I connect to my local machine cannot be connected. 650) this. width = 650; "style ="

MySQL version 5.5.19master) Mysql5.1.59slave) During replication from a lower version to a higher version, MYSQL restarts repeatedly and a BUG message appears in the error log. 650) this. width = 650; "border =" 0 "alt =" "src ="

We do not need to migrate data from ORACLE to MYSQL. Below I have written three simple MYSQL functions. For your reference.Is it time? DELIMITER $$    USE `ytt`$$    DROP FUNCTION IF EXISTS `is_date`$$   

I just came back from Huilongguan, and now it's am. The miserable itrip man started to work.A two-node oracle 11g rac with the host names rac1 and rac2 respectively. The instance names are db4qg_1 and db4qg_2. The effect required is that the rac1

We know that temporary tables have the following features:1. At the SESSION level, a SESSION is automatically dropped once it is disconnected. 2. It depends on the default engine. If the default engine is INNODB, And you are crazy about using

Original article address: Stairway to SQL Server Indexes: Level 1, Introduction to Indexes This article is part of the SQL Server Index advanced series Stairway to SQL Server Indexes. Indexing is the basis of database design and shows developers the

I saw some people discussing the difference between pre-read and physical read on the internet today. I personally think that both physical read and pre-read operations require reading data from the disk to the memory, the reading time is different,

The DB servers of the companies that recently maintained the service are always faulty. I feel like I have to optimize it. I log on and find that the slow query logs are not opened, therefore, the slow query log is decisively added. After analyzing

Deploy two-node cassandra ClusterEnsure that jdk is installed in the system. do not configure JAVA environment variables.Cassandra version: apache-cassandra-1.1.5jdk version: jdk1.6.0 _ 381. cassandra log Path # vim

I. Traversal Each node in the index tree is a page. The index tree has three types of nodes: root node, intermediate node, and leaf node. (1) like an intermediate node, the root node only contains the entry value and entry pointer of the next node.

1) Environment Topology 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/2232221632-0.png "title =" QQ20130614135543.png "/> Today we are talking about the mysql cluster. The resources are as follows: 650) this. width = 650;

When using a stored procedure, we usually only need to grant the corresponding permissions to the account that calls the stored procedure. However, in fact, the stored procedure defines whether the user can directly execute the stored procedure, if

One time when switching to archiving logs SQL> alter system switch logfile; it does not respond after it is stopped for a long time; Check whether it is in archive mode: SQL> archive log list;Database log mode Archive ModeAutomatic archival

External table: The data in the table is stored as an operating system file. Currently, the data in the table is not stored inDatabaseBut on the operating system,OracleProvides a mechanism for Directly Reading external data. Benefits of External

151. CEILING () ORCEIL ()Returns the smallest integer value greater than or equal to the parameter.SELECTCEILING (3.56) FROMBSEMPMS;SELECTCEIL (4.67) FROMBSEMPMS;152. CHAR ()Returns the string representation of the datetime type, String, integer,

In SQL Server 2000, the SQL language is the Transact-SQL language. The main components of the Transact-SQL language are as follows: 1. Data Definition Language (DDL)2. Data Manipularion Language (DML)3. Data Control Language (DCL)4. System Stored

Now that DB2 9 has been released, it is time to update pureXML, one of its latest features.®To test the driver. Therefore, a simulated brokerage business environment is established. This environment has the following features: High transaction

Data Query is one of the most important functions in database operations. Sometimes the performance of database queries is directly related to the database operation efficiency and database selection. I will not talk about the principle below, but I

-- Before the formal backup, do as follows. -- Copyright statement: -- The reader can copy or modify the content of the backup script without tampering with the author. -- Author: the roles of Xu Yujin's documents: 1. rman_db_all.sh: backs up the

Informix-4GL is a comprehensive fourth-generation application development and generation environment, it has powerful database management functions, flexible and convenient programming, user-friendly interface, has been widely used in UNIX operating