Database Administrator

When I was managing a technical consulting company, I heard some reasons for not using MySQL. Although many reasons are due to misunderstanding, there are indeed some reasons for not using MySQL. Of course, the actual situation may vary depending on

PhpMyAdmin is a MySQL management tool. Through this program, you can directly manage MySQL from the web without running it on the system. Installation steps: 1. Obtain the archive ftp://ohaha.ks.edu.tw/pub/source/php/phpmyadmin_2.0.5.tar.gzor Ftp: //

It is important to install MySql in a compressed package. In Windows, it is easy to decompress. Zip directly (Windows permission management is really weak -- | ). However, unzipping .tar.gz via coreora core7cannot be started. However, I started the

Install mysql-4.0.26 notes under RedHat9: The original code package of mysql-4.0.26.tar.gz is obtained. Note that it is not binary. Use the following command to modify the actual path based on your own situation: --- Create a mysql installation

After several days of hard work, I finally installed Oracle11G FOR Linux. I started to install RS4.0 and downloaded several versions of Oracle10g, or Oracle and Linux were incompatible, either the inventory directory cannot be found, or the net

Oracle databases are heavyweight, and their management is very complicated. Sort out the steps for starting and disabling Oracle databases on the Linux platform. After installing Oracle, you need to create an Oracle System User and add several

To import and export a MySQL file, follow these steps: 1. MySQL Command Line Mode settings: Desktop> my computer> Properties> environment variables> New> PATH = "; path \ mysql \ bin;", where path is the installation PATH of MySQL. 2. A brief

Turning off data prompts Oracle ORA-24324 ORA-01041 ORA-01089 errors and personal resolutions. SQL> conn/as sysdbaConnected to an idle instance. SQL> shutdown immediateThe ORA-24324: service handle not initialized.ORA-24323: value not allowedORA-0108

Preparations for the operating system are omitted here:1. Create a respone FileDgdb-> cat db_install.rsp | grep-v ^ # | grep-v ^ $> db_install2013.rspDgdb-> more db_install2013.rspOracle. install. responseFileVersion

Operating system version: CentOS 5.8 64bit Database Version: 11.2.0.1 Problem description: Recently, the database was added to 32 GB of memory, and the MEMORY_MAX_SIZE parameter was increased to 28 GB, And the MEMORY_TARGET parameter was changed to 2

---------- Full backup -----------Backup set: block BACKUP used in data filesImage copy: a complete COPY of all data files.---------- Incremental Backup -----------A backup of a database that has changed since a specific time point. This time point

Management of ASM (Management of Shared disks)1. Manage the ASM in instance mode. Before starting the database, you must first start the ASM instance. After the ASM instance is started, the ASM disk is mounted.--------- Install the ASM management

10.1 parallel recovery (v7.1) The goal of parallel recovery is to use parallel computing and I/O mechanisms to reduce the time for crash recovery, single instance recovery, and media recovery. When multiple data files on multiple disks are restored

Differences between Innodb foreign key and SQL standards: When there are many inserts, deletes, and updates rows in sel statement, fk will check one row. Innodb sets the shared row_level locks in the parent table or child table. MySQL CHECK

Environment: CentOS 6.2 + Oracle 11.2.0.3 (non-rac) Problem description: database every day around error ora-07445, after a few days is two to three times a day this error occurs, checked on the MOS, is the patch number 13901133 bug, the patch was

To add a user to mysql, follow these steps: 1. Log On with the root user Mysql-u root-p 2. Select mysql database Use mysql 3. Add a user Insert into user (Host, User, Password) values ("localhost", "your username", password ("your Password "));

Time: Fault: the database server is restarted without reason. When the Slave is started, the relay_log is damaged, and the SQL thread cannot proceed. Cause of failure: OS restart may cause relay_log to fail to be synchronized normally In this

Today, I received a request from my colleague, saying that there was a select query that would take more than a minute to run on Oracle. He hoped to get the results within 5s. The SQL statement is as follows: Select/* + parallel (src, 8)

The previous article introduced how to install the Oracle database on Ubuntu (see). The entire installation process was still smooth, but some steps were not successfully executed, or you just chose to ignore them, this may cause the installation to

To ensure security, Mysql allows users to log on only locally by default. However, in this case, you still need to use the user for remote connection. Therefore, you need to perform the following operations remotely: 1. Allow the root user to log on