Database Administrator

Bug During MySQL installation in CentOS 6.4 Install MySQL in CentOS 6.4 and download a source code package. It feels very simple, tar ,. /configure, make, and make install are four classic steps. This is not the first time, but today is an old error.

Aix hacmp system error -- NODE synchronization configuration error Environment: Operating System: AIX 5300-08 Cluster software: CRS 10.2.0.1 Database: Oracle 10.2.0.1 Fault symptom: The following error occurs when synchronizing the hacmp

Oracle 10 Gb physical standby to logical standby 1. Preparations for configuring logical StandbyBefore creating a logical standby, first check the status of the primary database to make sure that the primary database has all the preparations for

Data loss by date, minute, and second during Oracle Storage Today, a developer called me to say that Oracle encountered a strange phenomenon. In the stored procedure, values of date type are lost in minutes, minutes, And seconds. Let's do an

MySQL Database Operations group During the IT interview, database-related questions are basically mandatory, and SQL statements are also an important knowledge point that is frequently investigated. Next we will introduce an important operation

Deleting temporary tablespace ORA-25152 Error Deleting temporary Oracle tablespaces or shrinking temporary tablespaces often results in table space occupation. Next we will handle this situation, First, find the locked sid: SELECT a. INST_ID, B.

Data protection mode in Oracle 10g DG Data Guard Protection mode) Maximum protection) This mode ensures that data is not lost when the primary Database fails. In this mode, before the transaction is committed, ensure that the Redo data has been

Mysql FIND_IN_SET usage, mysqlfind_in_set In mysql, FIND_IN_SET is used to determine whether a string contains a comma. For example SELECT t. group_id, COUNT (group_id) tsumFROM (SELECT group_id FROM xx WHERE FIND_IN_SET (openid, 'Expect,

Mysql database operation group by, mysqlgroup During the IT interview, database-related questions are basically mandatory, and SQL statements are also an important knowledge point that is frequently investigated. Next we will introduce an important

Use default system_health to analyze deadlocks and oracle deadlocks Before 2008, we analyzed the Deadlock and needed to use profiler trace or trace flag 1222,120. 4. introduced a new feature in 2008: Extended Events, which can monitor Deadlock

Recommend friend SQL based on second-level contacts and friend SQL Friend table structure Drop table if exists friend;Create table friend (Uid bigint not null comment 'user id ',Friend_uid bigint not null comment 'user ID applied to be added as a

Use of DML (database operation language) in SQL, sqldml1. INSERT statement: INSERT [INTO] table [(column1, column2, column3,...)] VALUES (value1, value2, value3 ,...);Example: insert into user VALUES (NULL, 'test', '20140901 ');Example: insert into

Oracle fga audit has these features, oraclefga audit featuresFga audit has the following features:This article is the original article, reprint please indicate the source: http://blog.csdn.net/msdnchina/article/details/384090571. select * from table_

Understanding of checkpoint not completed, checkpoint Assume that the database has two log groups: log1 and log2. First, --> log1 --> log2 --> log1. At this time (log2 switches to log1), the checkpoint will be flush dirty block to datafile, this

MongoDB -- Getting Started with Java Driver, mongodbdriverOriginal article linkHttp://docs.mongodb.org/ecosystem/tutorial/getting-started-with-java-driver/Introduction The purpose of this article is to give you a brief understanding of how to use

MySql sorting rules (2) I saw this SQL statement today. I have heard of it before, but I have not understood it. So I would like to take a note here: UserName varchar (20) collate chinese_prc_ci_as null 1. First, collate is a clause that can be

How does the select_related and prefetch_related functions of Django optimize QuerySet queries? (2) djangoqueryset This is the second article in this series, covering the usage, implementation, and usage of the prefetch_related () function. The

ORA-01843: not a valid month, ora-01843valid This problem was encountered during the code today, because oracle is rarely used and the query is located. Suddenly dummies, there are a lot of posts that are due to the problem of nls_date_language,

[Translated from mos] relationship between SGA_TARGET and SHMMAX,Relationship between SGA_TARGET and SHMMAXReference Original:Relationship Between SGA_TARGET and SHMMAX (Document ID 1527109.1)Applicable:Oracle Database-Enterprise Edition-Version 10.1

Traditional databases are declining, new OLTP databases are booming, and oltp databases are declining References: (1) OLTP Through the Looking Glass, and What We Found There (2) The End of an unsupported tural Era, VLDB 2007 More and more