Database Administrator

During MySQL installation using source code compilation in Fedora, various errors may occur, mostly because no dependency package is installed and the rpm command is used for installation, which may cause less trouble: Required software:

First, there is an info.txt file, one of which is as follows: FFF_GGG_FF | GOD | 254 | 254 | 16384 | 16384 | 254 | 254 | Next, create a table in Oracle with the following structure: SQL> desc info;TABLENAME VARCHAR2 (200)OWNUSER VARCHAR2

1. Download the Oracle 11g for Linux zip package from the 0 racle website and decompress it. 2. run. /runInstaller-jreLoc/usr/lib/jvm/java-6-sun/jre) To be continued ...... 3. The next step is all the way, but some of the dependent items must be

The MySQL database in Linux has three functions:1. Create a folder named by date to store mysql Database backups.2. If the folder named by date exceeds 30, it is automatically deleted to save server space3. Go to the/var/lib/mysql directory and pack

Method 1: the simplest method is the method prompted by the system after mysql is installed. Use mysqladmin. Shell> mysqladmin-u root password "newpwd" Shell> the double quotation marks after mysqladmin-u root-h host_name password "newpwd" password

Today, we need to use this SQL statement: group by first, use the aggregate function count or sum for calculation, and display other auxiliary information. In the MySQL environment, I simulate the following environment: Create table 'room '( 'Rid'

Oracle's set is fragmented. Here we will summarize it. SQL> set timing on; // set to display "time in use: XXXX" SQL> set autotrace on-; // set to allow analysis of executed SQL statements SQL> set trimout on; // Remove trailing spaces in each row

This article mainly refers to the installation tutorial of Oracle-base for translation. However, due to the awkward translation of the English language into Chinese, his article also contains imperfections, I will adjust it slowly. Now this article

After the client connected to the database is abnormally disconnected, its possession is not released. For example, from the v $ session view, the corresponding session is still inactive, the corresponding server process has not been released,

Google developed a patch for mysql, a semi-synchronous patch, and an application and mysql5.0. Mysql is installed with this patch and used in mysql 5.5. What is the concept of semi-synchronous replication? Before the Database Change operation is

Outline I. Preface2. Create and authorize a userIii. Types of GRANT statements4. revoke permissions and delete users Recommended reading: MySQL user management MySQL user tools I. Preface As a Mysql database administrator, managing user accounts is

Here we will first describe the database startup process: 1. when the instance/routine is started (nomount status), read the parameter file (PFILE in a text file or SPFILE in a server parameter file), allocate the SGA, start the background process,

Today in the RAC-DG experiment, encountered a lot of problems, this problem occurs in the operation of the use of pifle to create spifle Most people prefer to directly use alter system set xxx = 'xxx. XXX' scope = spfile When configuring RAC-DG

Note:This article installed and configured the Oracle 11g slave uard physical standby Database, and tested the new feature of the 11g slave uard physical standby Database Active Data Guard. It is a feature of Oracle Database Enterprise Edition and

Purpose of a crosscheck command If the backup is damaged or does not exist on the disk and the backup set is still recorded in the rman database or the archive is available, you need to run crosscheck to perform cross-validation to update outdated

Let's talk about the three Protection modes of DG.Maximum Protection:The maximum protection mode does not allow data loss. All transactions can be committed only after the logs of the master and slave databases are written. If a network exception

Recently, some netizens mentioned the problem of shrinking Oracle data files, which is a common problem frequently encountered by DBAs. Usually we need to shrink the corresponding data files to reduce the pressure on the disk space and improve the

Analysis has become an increasingly important topic in MongoDB because it is used in more and more large projects. People get tired of using different software for analysis (including Hadoop) and apparently need to transmit a large amount of

Abstract: This article summarizes some common MySQL problems, solutions, and suitable use cases and optimization solutions. Directory: Storage engine Selection: MyISAM vs InnoDBUse and OptimizationDatabase OptimizationSQL OptimizationApplication

Redis list-type operations 1> stack features: first-in-first-out, and later-in-first-out2> queue features: FIFO and FIFOA List is a linked List structure that can be used as a stack or as a queue to process data.Lpush mylist "world" // put world to