Database Administrator

The problems caused by transaction concurrency are the problems that need to be solved by the database. The transaction processing technology is very mature, and the four isolation levels plus a snapshot is a common solution for all databases,

Mysql> select * from test;+ -------- + ------ + --------------- + --------- + ------------------------------- +| P_id | g_id | p_name | p_price | p_desc |+ -------- + ------ + --------------- + --------- + ------------------------------- +| Beef1 | 1

Recently, I have re-installed the Ubuntu 10.10 system and need to re-compile and install Mysql. The source code version is 5.1.34. It's a tough task. I don't know what the 10.10 system has changed, and the software installation is so bad. Here we

After learning how to install Oracle in CentOS 5.3 for a long time, you may encounter an Oracle Installation problem in CentOS 5.3. Here we will introduce how to solve the Oracle Installation problem in CentOS 5.3, centOS Linux has a strict version

The installation of python-mysqldb in CentOS took three hours. The strange problem was that python setup. py build had a lot of garbled characters. If you see a friend on the Internet who has encountered the same problem, post it and share it with

I. Preparations Note: because it is installed on a server that already exists and has been used by multiple parties, you must first confirm whether Mysql has been installed on this Linux server. 1. When groupadd mysql, the system prompts that mysql

Error message: Starting MySQL. Manager of pid-file quit without updating file. [FAILED]Vim install_mysql.shCHOST = "x86_64-pc-linux-gnu"CFLAGS = "-march = nocona-O2-pipe"CXXFLAGS = "$ {CFLAGS }"./Configure \"-- Prefix =/usr/local/mysql "\"--

Slave Oracle Storage Level Architecture, Oracle A database consists of one or more tablespaces. Tablespace : A logical storage container, which contains segments and consists of one or more data files. The relationship between segments and data

Last time I sorted out some concepts of DB2 database logs (basic knowledge of DB2 logs (1 ), however, it is difficult to manage and prevent archiving logs in the production environment and prevent log loss in case of disaster, because when the DB2

AIX6.1 install Oracle 11g R2 1. Check the server status before installation(1) view memory size# The/usr/sbin/lsattr-E-l sys0-a realmem command is long. If you forget it, you can use man lsattr.(2) view swap space# Lsps-Page Space Physical Volume

The Flashback Database function is very similar to the incomplete recovery of RMAN. It can roll back the entire Database to a certain time point in the past. This function depends on the Flashback log. Faster and more efficient than RMAN. Therefore,

Recently, when helping customers build an OSB cluster environment, after the managed server in the cluster is started, there will be a BEA-473007 warning "clustering unable to accept clustering Statistics ", I found a solution on the Internet as

After upgrading mysql from mysql 5.1 to 5.5 in Linux, it is found that the stored procedure is unavailable. When you create and use a stored procedure, The system prompts "Cannot load from mysql. proc. The table is probably updated upted. I checked

Oracle substr function usage Obtain the string substr (string, start_position, [length]) with the specified start position and length in the string. Substr (string, truncation start position, truncation length) // return the truncated word; When

I always wanted to wait for the BETA version to come out and try again, but I still couldn't resist the temptation. In the afternoon, I finally had time to test it.I. necessary software:1. LUAYou can download it from LUA Official Website:

If the data is too large, we cannot directly assign values to the clob variable. In this case, we can use the dbms_lob.read and dbms_lob.write methods to read and write clob variables in stages. However, we should set up a cache for the clob

Oracle 10g r2 installation clusterware ocr specified/dev/raw/raw1 Error The following error is reported:That is to say, the permission is incorrect or the owner is not an oracle/Dev/raw:Total 0Crw-rw ---- 1 oracle oinstall 162, 1 Feb 7 raw1Crw-rw ---

Change CentOS 6.4 to a Chinese Environment/Etc/sysconfig/i18n# LANG = "en_US.UTF-8"LANG = "zh_CN.UTF-8" Restart.----------------------------------------------------------------------- 1. Modify the Host Name and IP address of the system (this is a

After the data files in the UNDO tablespace are deleted by mistake: Back up the database before the operation to avoid greater losses.Ideas:1. Remove the accidentally deleted data file offline2. Create an UNDO tablespace and data file after the

The default Character Set of installed MySQL is latin1. To change the character set to what you need (such as utf8), you must change the related configuration file; in linux, the default installation directory of MySQL is distributed in different