Database Administrator

Oracle Data Pump example Oracle Data Pump example: 1. Export the specified tablespace: Expdp system/xxx DIRECTORY = dump_dir tableapace = xxx dumpfile = xxx _ % DATE :~ 0, 4% % DATE :~ 5, 2% % DATE :~ 8, 2% ". dmp logfile = xxx. log It seems

MySQL storage engine features and selection suggestions Common storage engines of MySQL official storage engines include Innodb, MyISAM, Memory, Archive, NDB, and BDB. The most famous third parties are TokuDB, Infobright, InnfiniDB, and

How to handle insufficient SWAP space when installing Oracle When installing Oracle, the installation may fail due to insufficient swap space allocated. The procedure is as follows: The SWAP space is 2 GB. [Root @ linux01 oracle] # freeTotal used

MySQL Master/Slave Database Configuration Guide and error handling MySQL master-slave replication Configuration 1. Requirements 1.1 System Platform consistency 1.2 consistent database versions 2. Modify the my. cnf file. The master server and slave

MongoDB upgraded from 3.0.7 to MongoDB3.2 Mongodb3.2 version was just released on the day before yesterday, for: https://www.mongodb.org/downloads#production Starting in 3.2, MongoDB uses the WiredTiger as the default storageengine. Mongodb uses

MySQL 5.7 cannot be logged on First, MySQL version 5.7 was released. The manager asked me to build LNMP with the latest version. Many problems were encountered during the setup process. Today, I will briefly discuss a problem with MySQL: After the

The MySQL restart process cannot be underestimated. The restart of the database seems to be very simple and has no technical skills. This is what I said before. This sentence is simply a pain point of mine. This kind of activity is so technical that

Summary of restoring MySQL master-slave Data Consistency This morning, my colleague told me that the data in the MySQL master-slave database was inconsistent and he guessed that the slave database encountered a problem during synchronization. So he

Restoration Methods for deleting online redo logs of Oracle databases The online redo log of the Oracle database contains Operation Records of all data in the database. We can use the redo log to perform many operations, such as log

How to install Redis in Linux Redis overview and Comparison Memcached is a high-performance distributed memory object Cache System for dynamic Web applications to reduce database load. It caches data and objects in the memory to reduce the number of

Monitoring startup reports TNS-12537, TNS-12560 Error Environment Description: OS: CentOS 6.5 DB: Oracle 11.2.0.3 Problem: the following error is reported when the database starts the listener: [Oracle @ localhost admin] $ lsnrctl start Connecting

MySQL loose index scan As we all know, InnoDB uses the index organization table (IOT), which is called the index organization table, and the leaf node stores all the data, which means that the data is always stored in a certain order. So the

MySQL composite Partition In the end, it is still open-source software. MySQL's support for composite partitions is far from that of Oracle. In MySQL 5.6, only the RANGE and LIST subpartitions are supported, and the subpartitions can only be HASH

MySQL Incremental backup script (innobackupex) 1. in the online environment, I sometimes write a simple script for Incremental backup of the MySQL database. 2. Add an automatic task and execute it every hour or shorter. #! /Bin/sh # Author RuM #

Migrate MySQL database to MariaDB on Ubuntu 15.10 MariaDB is the best alternative to MySQL databases. Since Oracle's acquisition of SUN, the open-source community believes that Oracle has never been very popular with MySQL. It is true that MySQL, as

Deep understanding of DB2 Tablespace (Tablespace) Tablespace is an important storage structure for establishing a ing between the logical structure of the database and the physical structure of the operating system in the database system. It serves

Tips for MySQL display operation control MySQL explicit formatting 1. Use G to display results vertically by line Unused Mysql> select * from wp_users limit 1, 2; + ---- + ------------------ + Certificate + ---------- + --------------------- + ------

Expdp export report ORA-39181 Processing Method [Environment] database version: Oracle 11.2.0.3 [Error Log] An error is reported when you use the system user to perform database expdp operations. The details are as follows: Starting "SYSTEM".

Hbase VS Oracle 1. Hbase is suitable for a large number of inserts and reads at the same time. Enter a Key to get a value or enter some key to get some value. 2. the bottleneck of Hbase is the hard disk transmission speed. Hbase operations, which

Oracle online redefinition Before online redefinition of [@ more @] Oracle9i, table data is organized by alter table XXX move [tablespace XX. If the table is very large and IO is not fast, the process of moving may be quite long and cannot be