Database Administrator

Table Structure:Create table tab_name(Id tinyint,Name varchar (10 ),Age tinyint,Phone varchar (15 ));Original content: select * from tab_name;Id name age phone1 zhangsan 10 123456789102 lisi 28 987654321103 wangwu 33 456789123124 zhaoliu 45 789456123

Environment:Server1: MYSQL1 + AS4Server2: MYSQL2 + AS4Purpose:Connect to MYSQL on Server2 from Server1TNND, tried N times. The remote connection is always unable to connect to MYSQL. the following error occurs:[Root @ etc mysql] #

This article analyzes the many possibilities of a problem. Readers can determine the situation based on the phenomenon to solve the problem in the shortest time.We have used many methods to protect data integrity, such as the primary key constraint,

Oracle10g was installed several times in the first burst. It is necessary to remember EM login garbled characters to prevent future forgetting.There are three places to change1. In the $ ORACLE_HOME/jdk/jre/lib pathBack up font. propertiesCp font.

At the end of last year, Oracle acquired a partner that provided Database Engine Services for MySQL over the years, forcing MySQL to only find other partners. It was reported that Oracle attempted to acquire an open source database MySQL. MySQL CEO

In Linux, database backup is very important. If regular backup is performed, the data can be restored to the last normal state in the case of a system crash, minimizing the loss. MySQLl provides a mysqldump command, which can be used for data backup.

Especially when I cannot find my. cnf, I should take it seriously.Author: Fan guanqunAfter a few days of desperate Baidu and continuous experiments, I finally solved the problem of Mysql 5.0.22. Online articles are neither too long nor too important,

It is still easy to install the software on Ubuntu, and there is a new way to create a graph (the name is straightforward and uncomfortable ). The command line has apt-get, which makes people feel that even if the rpm package is not supported, it

It is not easy to install the Oracle10G Database Under Fedora8. After some time of exploration, I finally installed it successfully! Now let's share the entire process. 1. Download Software10201_database_linux32.zip 2. decompress the file Unzip 10201

This is the administrator of a small and medium-sized Linux website. The system architecture is RHEL 4.0 + PHP 4.3 + Mysql 4.03 + Apache 1.23. The average daily IP Access volume is 200, a typical small Linux website. Because it is a small website,

I have been studying Oracle and MySQL for some time. Now I want to make a summary and compare it, and I hope it will be helpful to you! Oracle learning experience Oracle's system is too huge. For Beginners, it is inevitable that they will not start

Like many netizens, today encountered a ora-01882 problem, checked matelink solved! Environment:Oracle server version:SQL> select * from v $ version; BANNER----------------------------------------------------------------Oracle Database 10g

I. Cluster Classification1. Category by Purpose(1) High Availability Cluster)(2) Load Balance Cluster)(3) High Performance Computing Cluster)2. Structure-based classification(1) active-standby mode)(2) mutual standby (mutual backup mode)(3)

Today, we encountered an Oracle Function problem when using the Hibernate development project. During project development, all document numbers are generated using a Function. this Function has some DML syntax, so you cannot use select fun _... ()

Wait for the event source to startThe concept of wait events is introduced from Oracle 7.0.12, with roughly 100 wait events. In ORACLE 8.0, this number has increased to approximately 150, with approximately 220 events in ORACLE 8I and about 400

Hello everyone! Today, the director asked me to help install the Oracle database. When I log on to the system, I found that it was not the same as the original debian system. I did not install oracle. Please go to the official documentation to find

Environment: An openstack Virtual Machine with 8-core CPU, 16 GB memory, and GB disk Ubuntu 12.04x64 Server Install redis2.6.7 Process: During the experiment, we need to import 0.21 billion key-value data into redis for fast query. After

The principle of the backup control file is to back up the control file after the physical structure of the database changes. 1. trace: used to control file reconstruction (the generated trace file is in udump)SQL> alter database backup controlfile

1. Structure of the SMON_SCN_TIME table The SMON_SCN_TIME table stores the mappings between SCN and Time. This table is maintained by the SMON process. SQL> desc smon_scn_time Name Null? Type ----------------------------------------------------------

1. udev configuration file (RedHat 6.3)1.1 obtain the disk UUID: [Root @ localhost ~] #/Sbin/scsi_id-g-u/dev/sdb2017b11c0002be80e00000ce3514380db[Root @ localhost ~] #/Sbin/scsi_id-g-u/dev/sdc2017b11c0002be80e00000ce551420.f8[Root @ localhost ~]