Database Administrator

Install MySQL in CentOS 7 The mysql-sever file for mysql installation does not appear to be in the yum source of CentOS 7. You need to download it from the official website. # Wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

Oracle lag () and lead () Functions I. Introduction The lag and lead functions are two offset-related analysis functions. These two functions can be used to retrieve the data of the first N rows of the same field in a query (lag) and the next N rows

MySQL Partition Table Management I. How to manage RANGE and LIST partitions This partitioned table is used as an example. CREATE TABLE members ( id INT, fname VARCHAR(25), lname VARCHAR(25), dob DATE)PARTITION BY RANGE( YEAR(dob) ) (

OpenResty Load Balancing MySQL OpenRestyHttps://openresty.org/download/ngx_openresty-1.9.3.2.tar.gz Nginx_tcp_proxy_module needs to be downloaded separatelyHttps://github.com/yaoweibin/nginx_tcp_proxy_module First, extract the above files[Nginx @

Oracle Database Import and export practices There is an Oracle server that needs to be exported and imported. I have been familiar with Oracle before, but I have never studied Oracle Export and Import. Now I am in a hurry, so I have to make up the

Oracle Database rman backup plan and recovery 1. Prerequisites for completely restoring rman: Historical backup of datafile, controlfile, and spfile, plus full archivelog and complete redolog. 2. rman backup script: A. RMAN level 0 BACKUP

Shell script: simple script for MySQL to start It is recommended to compile a simple MySQL STARTUP script using shell scripts, and to practice the usage of variables, functions, and case statements; [Root @ localhost baby] # cat mysql_function.sh#! /

Listens to Oracle AQ through JMS and triggers the execution of Java programs when the database changesEnvironment Description The tutorial environment is based on Oracle 12C and JDK1.8. Oracle 12C supports multi-tenant features. Compared with the

MySQL full index scanning bug 1 Introduction When checking the slowlog of a Business Database, a slow query is found. The query time is 1.57 s. Check whether the where condition field in the table structure has a correct composite index. If it is

Schema rollback Snapshot Many days ago, one of our customers accidentally performed a "delete" Operation on the website. however, he found that he could not confirm whether the objects he deleted should be deleted. so we turned to us to see the

MySQL installation troubleshooting Mysql faults: [Root @ MYSQL_M ~] #/Etc/init. d/mysqld restart Starting MySQL... ERROR! Manager of pid-file quit without updating file. [Root @ MYSQL_M ~] # Possible one: The basedir and datadir directories in

Oracle RMAN repairs logical Bad blocks RMAN implements block recoveryThe trial of Rman can achieve block-level data recovery. In the traditional restoration method, that is, a data block of a data file is damaged, the entire data file cannot be used

Use the dbms_flashback toolkit to implement the flashback query function Flashback Query is a convenient logical recovery function based on Oracle Undo expired data. With the support of Undo Tablespace, We can query the time version of a data table

What are the integrity constraints of database design? What are the integrity constraints of database design? Here are four aspects: 1. Domain integrity:The columns in the database table must meet certain data types or constraints. The

Another Implementation Method for SQL like clauses (faster than like), like clauses Generally, when fuzzy search is used, you will think of LIKE Select * from table where a like '% character %'If an SQL statement uses multiple like fuzzy queries and

How to solve the error Repositories is not a valid short file name, visualsvnserver An error is prompted during the installation of the latest version of visual SVN Server: "'Repositories 'is not a valid short file name ."Click OK to terminate the

Mongodb 3.0 index and set daily operations, mongodb3.0 ----- 1. create an index db. tblorders. dropIndexes (); db. tblorders. createIndex ({"OrderNo": 1 },{ background: true, name: "index_OrderNo"}); db. hisorders. createIndex ({"orderno": 1 },{

When pl/SQL developer is enabled, the NLS_LANG and Character set (Character set) problems occur. plnls_langStart pl/SQL developer and the NLS_LANG and Character set (Character set) problems occur. The company recently trained pl/SQL. After

The implementation of ORM has two main purposes: Generic and reflection. The monks believe that the two essentials of ORM implementation are generic and reflection. Next let's take a look at how to add bricks and tiles to the DAO layer. First,

Install and run DB Query Analyzer 6.04 on Microsoft Windows 10,  Install and run DB Query Analyzer 6.04 on Microsoft Windows 10     DB Query Analyzer is presented by Master Genfeng, Ma from Chinese Mainland. It has English version named 'db Query