Database Administrator

The following describes how to install the MySQL RPM package in the Linux operating system! First, check whether MySQL is installed in Linux. Rpm-q mysql *; Delete if any Rpm-e -- nodpes mysql *; Then install MySQL Rpm-ivh MySQL-server-5.0.22-0

1. It is best not to write a Commit statement in the Oracle stored procedure. Generally, the calling program automatically Commit data. For example, when calling with NHibernate, NHibernate automatically Commit data. If it is written, an error will

In many cases, the Oracle password file needs to be rebuilt. ORACLE has strict requirements on the password file, such as the file name and file name case. Once the ORACLE_SID was case-insensitive for a long time, the record is as follows: Linux

First, go to root mode to download 3 Software Term-Readline-Gnu: http://search.cpan.org/dist/Term-ReadLine-Gnu/ IO-Tty: http://search.cpan.org/dist/IO-Tty/ Uniread: http://sourceforge.net/projects/uniread/ Run tar-xzvf... with the root account

How can I improve the efficiency of MySQL Data loading? Batch loading is faster than single-row loading. After each record is loaded, you do not need to refresh the index cache. You can refresh the index only after batch record loading. Loading a

1. Create a stored procedure 1. Basic Syntax: Create procedure sp_name ()Begin.........End 2. parameter transfer Ii. Call the Stored Procedure 1. Basic Syntax: call sp_name ()Note: The stored procedure name must be enclosed in parentheses, even

Recently I encountered a problem when using MySQL. The like Query always came out with something strange, which is not consistent with the things behind like. I checked it and finally solved it, the following method 4 is used. If you are interested,

My system is Ubuntu 8.04 on a virtual machine. 1. Go to http://www.postgresql.org where the next postgreSQL core 8.3. 2. Run the tar-xvf postgreSQL-8.3.3.tar.bz2 to decompress 3. Go to the decompressed folder and run the./configure command to

Install MySQL in Ubuntu in three ways: 1. install sudo apt-get install mysql-server from the Internet. After the environment variables have been automatically configured, you can directly use the mysql command. 2. Install the release package. Take

A simple record of the Oracle 10g Installation Process on AIX 5.3: Check hardware configuration Check memory: # Lsattr-El sys0-a realmemRealmem 2097152 Amount of usable physical memory in Kbytes False Check swap space # Lsps-Page Space Physical

I encountered a lot of trouble in learning MySQL. In order to prevent beginners from having the same problem, I spent some time writing this article. I am also a newbie and hope to give you more advice !! Before installing MySQL, let's take a look

Recently, I have seen a lot of information about cluster. I have been studying the load balancing and high availability of Linux systems, but it has not been completely successful yet, but it only implements some simple services; today, I found that

Before Oracle9i appeared, you can only re-define the table by moving or exporting and importing the table. Therefore, the table redefinition process may be quite long or offline, during this period, the application will fail to operate on the table.

There are a variety of ways to delete duplicate data on the Internet. Oracle has never seen such a method:  Delete from prod_grid_incWhere rowid in (SELECT B. row_id2FROM (select rowid row_id2,A .*,Row_number () over (partition by a. prod_id order

Script Function One-click installation script for a single redis instance Notes 1. Applicable only to Linux/CentOS 64-bit 2. Networking is required during installationStep 1. download and install the libunwind package (TCMalloc dependency package) 2.

1. scenario: the mysql database is on the slave machine, the slave machine is on the LAN, the ssh host is required, and then the ssh slave machine (the slave machine) is on the client machine) similar to the following Architecture     As a

After I installed Oracle 11g rac, why ??? Garbled characters are as follows:[Oracle @ db ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Thu Dec 20 13:40:46 2012 Copyright (c) 1982,200 9, Oracle. All rights reserved. ??? :Oracle

The Linux script has not been written for a long time. Suddenly there is a need to write a bash shell script to initialize Oracle users and tablespaces. Make a record for future Query Call method:./user. sh

This problem is found in a database in the customer environment. At that time, the customer asked for help, the database status is not normal, connected to the database can not operate normally, and sometimes error ORA-12537 error. ORA-12537: TNS:

I saw an article: Using instr in the Oracle database instead of like (see). I am very skeptical after seeing it. The following is a simple test I did to compare and verify the original article.1. Before creating an index SQL> select count(1) from t;