Database Administrator

In Fedora 11, it is difficult to install the source code MySQL. The installation process was recorded here for a long time. Ps: the directory paths involved in this article are all my local directories. You can adjust them by yourself. Ps: I use 5.1.

As we all know, the MySQL InnoDB Storage engine is very similar to Oracle and supports transactions and row-locking. After actual tests, a big difference between innodb and oracle is: the same data, the length of innodb single-row storage is

1. MySQL compilation and installation in Linux:(1) ../depcomp: line 571: exec: g ++: not foundMake [1]: *** [my_new.o] Error 127Make [1]: Leaving directory '/home/justme/software/mysql-5.1.30/mysys'Make: *** [all-recursive] Error 1This problem

Preface:It is not difficult to specify a data type for a column. It is difficult to specify a suitable data type. For the same string type, choose a fixed length or a variable length, among which there are many articles. Therefore, you need to

The business description is as follows: When inserting a table under Oracle, you must update the value of another field based on the value of one field. Of course, it can also be implemented through a program, but this field is only used for data

(I) First query the CPU and IO usage at the system level: top, iostat, sar... (Ii) EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT (); (Iii) rman target/debug trace =/tmp/rmandebug.txt log =/tmp/rman_log20130727.txt Execute backup (Iv) EXEC

Background Due to the influence of traditional RDB, most developers may have a mindset for designing database tables. In the context of cloud computing and big data, RDBMS is approaching the limit, and KV storage will attract more and more attention.

Note:There are many ways to create a consumer uard. This article describes one of these methods, which is applicable to 10g/11g.This article uses the RMAN target master database and local auxiliary database to create an Oracle 11g backup uard

When I use Navicat to connect to a remote MySQL instance, the following error is displayed. I thought it was a firewall problem, but it was disabled. I think this English paragraph is a bit misleading, and it is a problem on my own side. Check the

When you use imp/exp to import/export the 8I data to 10 Gb, it is found that all the comments of the imported data are garbled. The reason is that the client character set is not set during the export, or the settings are incorrect. It's okay to

Today, when migrating the zabbix database, a shared tablespace cannot be released. because mysql uses the innodb Storage engine by default, when a large data volume is deleted, because of the Force interruption, the shared tablespace cannot be

There is an automatic backup script program that asks rman. I have previously written an automatic backup case for the exp backup specific solution (Oracle automatic backup case on Linux platform (using exp tool )), now I want to add the rman

Recently, MySQL installed on Mac is not used for a period of time. When I tried to use it, I found that I forgot my password. Fortunately, google soon found a solution. At that time, no relevant records were made. Today, we encountered the same

Background: I was asked this question before the interview. There are two transactions in the database. When transaction1 is updating a row, Will transaction2 block during select. I used MySQL for tests before, but I was impressed. But the

A buddy raised a question and found it interesting. He studied it below:The Development Department of this buddy company has written a jboss script to start the jboss program. You need to enter a command similar to the following:./Jboss_init.sh

I. multiplexing of Control FilesA) shutdown immediate; B) in the operating system, copy the backup file to the new disk and copy the full path of the new control file; C) startup nomount; D ),Alter system set control_files ='F: \ Oracle \ PRODUCT \ 1

1. First add three Disks 2. Installation Package [Root @ myorcl asm] # ls Oracleasm-2.6.18-348.6.1.el5-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-348.6.1.el5debug-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-348.6.1.el5PAE-2.0.5-1.el5.i686.rpm Oracleasm-2.6.18-3

Introduction to XtraBackup XtraBackup replaces the innodbbackup tool, and XtraBackup is fully compatible with the innodb Storage engine, and implements full physical layer hot backup for the innodb Storage engine. Site:

Symptom: The test database uses the following method to create an index: Create index IDX_ANA_OFFICE on ANA (OFFICE_CITY, OFFICE_NO)Tablespace IDXPctfree 10Initrans 2Maxtrans 255Storage(Initialize 128 KNext 128 KMinextents 1Maxextents

When you delete indexes, tables, tablespaces, users, and other database objects or users, you may encounter the following errors: SQL> drop user Oracle cascade; Drop user oracle cascade; * ERROR at line 1: ORA-00604: error occurred at recursive SQL