Database Administrator

Command summary for operating MySQL in Linux Command lines (Note: commands in the MySQL environment are followed by a semicolon as the command Terminator) 1. commands for starting MySQL in Linux: Mysqladmin start/Ect/init. d/mysql start (the

Cases of high CPU usage and memory usage in MySQL Faults:At about seven o'clock, I received a complaint from the playback center that the video was playing slowly and could not be loaded for a long time. At first, he thought it was the tomcat

Resolving index failure when Oracle Partition Table deletes partition data I. Description Today, we have a small task to delete some data. Haha, please be happy first. Because the data table to be deleted is the partition table that I previously

Detailed description of InnoDB Transaction log (redo log and undo log) To avoid performance problems caused by I/O bottlenecks during data writing to the maximum extent, MySQL adopts a cache mechanism: When the query modifies the data in the

MongoDB replica set node role introduction and election process analysis A replica set ReplicaSet is generally composed of a group of mongod instances, which work together to provide highly available database access services. Different Nodes in the

Summary of common SQL statement optimization techniques [classic] and SQL statement techniques classic This example summarizes common SQL statement optimization techniques. We will share this with you for your reference. The details are as

Mybatis level 1 and level 2 cache, and mybatis Level 2 CacheLevel 1 Cache First, perform a test to create a mapper configuration file and mapper interface. Here I use the simplest query for demonstration. SELECT * FROM user public

Official MongoDB documentation translation series: Official mongodb documentationIntroduction This document provides a method for writing data into multiple documents using two-phase commit to process multi-document updates or "Multi-document

Database review 7 -- recovery, database review 7Database review CH14 recovery 13.1 recovery concept Database SystemRestoreIt refers to the behavior that restores the database from an inconsistent state after a certain "failure" to a normal

Oracle Import and Export File supplement, oracle Import and Export supplement In the past two days, oracle has imported and exported table data. 1. oracle provides three ways to Import and export files. (1) Oracle export/import (2) slq export/Import

Use API to create a sales order and api to create an order DECLARE invalid NUMBER: = 1; v_return_status VARCHAR2 (2000); v_msg_count NUMBER; v_msg_data VARCHAR2 (2000); -- IN Variables -- v_header_rec limit; v_line_tbl limit; v_action_request_tbl

Note: [oracle problem set] refers to the problems and solutions encountered by bloggers during database operations. Statement execution: indicates the database operation process. Error: Indicates An error occurred while operating the database.

1. Install CDROM in Unixware 7.1.1) 1. boot from the CDROM Installation Boot Unixware CD-1CDROM must be a Slot1 or Slot2 Master)2. installation language. Select Proceed with installation in English and press enter to continue.3. Choose a zone for

Installation and configuration After you reinstall DB2 in Linux, you cannot create an instance of DB2INST1, prompting that the instance already exists. Solution:Delete the/var/db2/v81 directory and recreate the instance; Cause analysis:Before you

Linux has become popular among various operating systems. Therefore, more and more mainstream database vendors are porting their products to Linux operating systems, such as Sybase, Oracle, and IBM. In addition, more and more free software are

The following is the process of manually deploying the SQL Server CLR assembly. Here, we will make a record for you to read it at any time and provide reference for those who have no manual deployment experience, if you have any more convenient and

Before recovery: 1. full closed backup Do not use shutdown abort to forcibly shut down the shutdown database), implement a file-level backup, back up all Oracle related files, including Windows system files, system status and Oracle program files

Informix Dynamic Server is also called multipart storage. Its principle is to distribute the records or indexes in a data table in different disk regions according to rules, to store data on multiple disks, we can improve database efficiency by

The interconnection of different database platforms is generally called the heterogeneous service of databases. Currently, all major databases can achieve such Heterogeneous Interconnection, but the specific implementation technologies of different

In daily work, DBAs often encounter how to make separate queries faster. MySQL also allows you to change the statement scheduling priority so that queries from multiple clients can better collaborate, so that a single client will not wait for a long