Database Administrator

MySQL slave database option log-slave-updates not enabled exception Recently, it was verified that a specific table was copied from the slave database to another master database for adjustment. If log-slave-updates is not configured, the table

Oracle uses a cursor to delete all record scripts in all user data tables Application Scenario: because the data in the Oracle database involves confidential information, we hope to delete all the data at a time and only keep the data table

ORA-21561: OID generation failed A very strange problem occurs: Linux5.8 + Oracle 11.2.0.3 When starting the database, an error is reported: [Oracle @ tivoli02 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Thu Oct 23 21:23:16 20

MySQL slow Query The slow query (slow log) helps us locate specific SQL statements for SQL statement optimization. For example, the slow query log records the SQL statements whose execution time exceeds the given value, locate the problem. Enable

Compile and install PostgreSQL in Mac OSX Originally, the official installation package was used. However, the installation package will create postgre, which is a bit uncomfortable on the login interface. After searching for a long time, I did not

Redis performance problems and Redis performance problems Redis may cause performance problems and provide corresponding solutions. 1. Blocking of snapshot writing Solution:   2. AOF Problems Solution: 3. Memory bottleneck If the

Oracle Import and Export (used more), oracle Import and Export1. create directory (role system/sys) create directoryHello_fileAs'D: \ dupmfile';-- View all created Directories-- Select * from dba_directories;-- Drop directory. -- Drop directory

Install and configure the hadoop plug-in myeclipse and eclipse in windows/Linux, and myeclipsehadoop I recently want to write a test program MaxMapperTemper on windows, and there is no server around, so I want to configure it on windows 7. Succeeded.

Mysql primary key auto-increment and default value, mysql Default Value Create table 'ecm _ address' ('addr _ id' int (10) unsigned not null AUTO_INCREMENT, 'user _ id' int (10) unsigned not null default '0 ', 'consignee' varchar (60) not null

SnappyDB-NoSQL database on Android, snappydbnosql Or starting from the demand. When developing an App, you often need to cache some data so that it is not empty every time you open the App. You need to download data from the network. For example, a

Mssql deletes all tables in the database and mssql deletes the database. for this operation, you can first learn about the system table sysobjects (which has been written in the previous blog), and drop, truncate, delete. ------------ Delete the

MySQL schema and binary log disk space trend analysis, schemabinary Author: SkateTime: 2015/01/05   Disk Space Trend Analysis of MySQL schema and binary log [Root @ skatedb55 dist] #./mysqlsize -- helpUsage: Database diskspace usage v0.1, (C)

About Dynamic Sampling (Dynamic Sampling), dynamicsamplingDynamic Sampling) Original article: http://www.oracle.com/technetwork/issue-archive/2009/09-jan/o19asktom-086775.html This article will answer: What is dynamic sampling? What is the function

[Learning MongoDB step by step]-Brief Introduction to MongoDB (1), brief introduction to mongodb In the previous blog, we spoke about NoSQL. We have a comprehensive understanding of NoSQL. Starting from this blog, we will take everyone into the

Cloud computing architecture technology and practices: 4.6 database cloud, cloud Database Copyright. Do not repost or forward it without the written permission of Huawei. 2.4.6 database cloud The database cloud solution is based on the overall

[Read-Only tablespace -- restore-1], read-only table --- 11> Read-Only --- backup read-only fault read-only restoration of faulty data files2> Read-Only --- backup read-only writable fault recovery backup data files, recover3> Read-Only --- backup

Ora-7445 [PC: 0x103E2AFA0], dbca0x103e2afa0Install Oracle Rac on AIX 7100-02-03-1334. Both grid and oracle have been installed. However, dbca database found crash, the following is the database creation of the alert. log, the database reported ora-07

Java. SQL. SQLException: ORA-24778: Unable to open the connection, Weblogic log reported: java. SQL. SQLException: ORA-24778: Unable to open the connection. The analysis function is used to perform multiple operations on a remote table. First, view

Test your understanding of MySQL transactions and isolation levels. I have written an article titled MySQL InnoDB Transaction isolation level and dirty read, Repeatable read, phantom

SQL string data is sorted by int type, stringint Note: I found a problem during wms invoicing: A warehouse receiving ticket (T_OutIn_BoxTop), which should be divided into multiple boxes during warehouse scanning. The box number (BoxTop_No) can be