Database Administrator

Imp/exp Oracle Database Import and Export command Oracle Data Import and Export: imp/expFunction: Oracle Data Import/Export imp/exp is equivalent to oracle data restoration and backup. In most cases, you can use Oracle data import and export to back

MySQL Security optimization using aliases to prevent misoperation Background: When a newbie experiences misoperations, he deletes my entire test table (test, no backup) Operation Command: Mysql> update test set name = 'Tom '; Result: All name

Use cmake to compile and install MySQL 5.5 First, upload the source code package cmake-2.8.8.tar.gz?mysql-5.5.32.tar.gz to the server. Decompress and install cmake [Root @ localhost ~] # Tar-zxvf cmake-2.8.8.tar.gz[Root @ localhost ~] # Cd cmake-2.8.

Oracle 11G uses DG Broker to create a consumer uard Oracle 11G uses DG Broker to create a consumer uard 1. Environment: A. host environment: CentOS6.5 B. software environment: oracle 11.2.0.4 C. host information: DG1: 192.168.100.51 (Database sid:

Summary of Oracle archive logs 1. Open archive logs Sqlplus/as sysdbaSQL> shutdown immediate;SQL> startup mount; # Open the control file instead of the data fileSQL> alter database archivelog; # Switch the database to archive ModeSQL> alter database

Summary of various MySQL logs Log Type: Error log) General log) Binary log) Relay log) Slow log) Redo log of InnoDB Engine Error Log Log-error = error. log Save the storage path to datadir without specifying the hostname. err Record mysql

MySQL uses binlog to restore Data 1. What is binlog? 1. Basic definition of binlog: Binary logs are also binary logs that record SQL statements that occur or potentially change data and are saved in the disk in binary format; Binary log information:

Differences between statement and preparedStatement [in jdbc] ① Syntax difference: · Statement is the parent class of PreparedStatement [developer generally uses the latter]· Different SQL statement locations:The usage of statement is as

Oracle adump file goes viral The Oracle adump file is too long, causing the oracle database to crash and re-build the adump directory. The error is: no space left on device, df-TH space is still available, but the directory cannot be created, the

How does MySQL export files with date format? A netizen asked how to use only SQL statements in MySQL to export files with date format. I thought it was a bit interesting, so I tried it. The exported file uses select into outfile, but the values

Manually generate an AWR report Sometimes the AWR report cannot be graphically generated for installing EM in the database. In this case, you need to manually generate an AWR report. Oracle provides an SQL statement to manually generate an AWR

MySQL5.6 master-slave replication Configuration Environment Description: Two MySQL5.6.21 Servers installed in CentOS6.5: master and slave Master Server: IP: 192.168.80.51 Port: 3316 Slave Server: IP: 192.168.80.52 Port: 3316 Configuration steps: 1.

Only enable 10046 trace for a specific SQL statement Recently, I encountered an interesting problem: there is an SQL statement that runs for dozens of milliseconds most of the time, but sometimes the execution time of a certain time is longer than 2

On the design scheme of the Oracle standby Database Oracle's ADG is needless to say. In terms of storage circles, the storage is changing from passive to active, but in general it is being snatched by software and RAID is snatched by ASM, snapshots

View ASM disk space You can view the ASM disk space through the operating system or in sqlplus. [1] view methods in the operating system [Grid @ db01 ~] $ AsmcmdASMCMD> lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB

Oracle viewing Object Information 1. View information about all objects of a user: SELECT owner, object_type, status, COUNT (*) count #FROM all_objectsWhere owner = 'xxx'Group by owner, object_type, statusOrder by 2; 2. view the number of rows in

MySQL Group By optimization I wrote a blog post on MySQL's loose index scan (). Later I found that the main purpose of the optimization method mentioned last time was to implement loose index scan, at the execution plan level, the Extra information

Build an environment for Python3.3 accessing Oracle 11gR2 on CentOS6.3 Build an environment for Python3.3 accessing Oracle 11gR2 on CentOS6.3 View the built-in python path and version of CentOS[Root @ oracle11g ~] # Which python/Usr/bin/python[Root @

How to configure the world's smallest MySQL Server Configure the world's smallest MySQL Server-how to install a MySQL server on an Intel Edison control panel. Introduction In my recent blog post on IOT, messaging, and MySQL, I showed if the Particle

Centos 7 installation configuration Redis-3.0.0 Centos 7 installation configuration Redis-3.0.0 1. install necessary packages yum install gcc Ii. Installation in Linux # Download wget http://download.redis.io/releases/redis-3.0.0.tar.gztar zxvf