Database Administrator

Are Fields in MongoDB documents sorted in order? In this article, we will briefly discuss the sequence of fields in Mongodb. The document in Mongodb is a Json string consisting of Key: Value pairs. It is reasonable to say that the order of fields

How to install MySQL without compilation on centos MySQL without compilation is very convenient and saves a lot of time. I am using MySQL-x86_64. The next step is the installation process in CentOS6.5. # Install dependency packagesYum install-y

Permission control problems caused by a User Creation Developers raised a requirement, which is interesting. Requirement Description: The development database is required to create A new user A (default tablespace TBS_1). Because the database is A

Test and comparison of Oracle redo log generation Oracle Database logs can be in several modes, such as forced logs, unforced log modes, and object levels! After the database mode is set to force, the remaining logs will be forced in any case! Now

Install and configure MySQL 5.5.16 on MAC OS X 1. Download MySQL Visit the MySQL official website http://www.mysql.com/downloads/ and then on the page will see "MySQL Community Server" below a "download" click. Go to the MySQL download interface

MariaDB DML statements and user authorization DML (Data Manipulation Language): INSERT, DELETE, UPDATE, SELECT INSERT [INTO] tbl_name [(col1,...)] {VALUES | VALUE} (val1 ,...),(...),... Suppose there is a table above Insert a row of data: insert

Redis expiration deletion policy Recently, when the Redis memory reaches the maxmemory limit, slow data elimination causes application requests to be slowed down. Later, I took a closer look at various Redis data elimination strategies and

Build a MySQL environment on the OS X Platform References: The simplest way to install MySQL on OS X is to download the Community version DMG package from the official website. The latest version is version 5.7, the installation method has

Install MySQL 5.7.10 on Mac OS X I tried to install MySQL on the Mac over the past two days. I didn't expect the simple action that I thought would have wasted so much time. I wrote it here. It's a mark, to save some detours for later students. At

Compile and install MySQL 5.6.16 in CentOS 6.5 Check: uninstall the original MySQL Because MySQL databases are too popular on Linux, the mainstream Linux system versions currently downloaded are basically integrated with MySQL databases, run the

Simple Backup Using impdp and expdp provided by Oracle At present, there is a need to back up the data in the production database to the backup machine at 23 o'clock every night. The database of the backup machine can be used directly the next day.

MySQL master-slave replication interrupt error code = 1217 error resolved MySQL master-slave replication is interrupted and the Error "error on master: message (format) = 'could not delete or update a parent row: a foreign key constraint fails

MySQL Optimization-enable MySQL slow query log and analysis tool mysqldumpslow 1. It is very easy to enable MySQL slow query logs. You only need to add the following in the MySQL configuration file my. cnf:[Mysqld]Slow_query_log = 1-enable slow

CentOS6 change the MySQL data storage location When mysql is installed using yum, the default data is stored in/var/lib/mysql. Generally, to ensure data security, we recommend that you store the mysql database data files in the directory of the

Simple use of MySQL event -- View the create information of the event Show create event event_test; -- View the event status in a schema SELECT event_schema, event_name, status from information_schema.events WHERE event_schema = 'xxxx'   -- Check

MariaDB thread and Connection Today, we will introduce how to check the number of links and threads of mariaDB (the same as MySQL. What is the difference between MariaDB and MySQL. This is an entry to reduce database load and improve database

Java calls the Oracle stored procedure and returns multiple result sets Oracle version: 11 GB The Oracle stored procedure uses a cursor to return data sets of multiple rows and columns: Create or replace procedure SP_DATA_TEST (/* P_ID in int, */--

Solution to Oracle 11gR2 listener startup error in CentOS7 An error occurred while starting the Oracle listener: [Oracle @ localhost ~] $ Lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0-Production on 12-APR-2016 00:27:54 Copyright (c) 1991,200 9,

MySQL pressure test tool-mydbtest PrefaceThis article introduces mydbtest (mydbtest_linux64.bin, compiled by Lou Fang Xin Da Niu), a tool for database stress testing without installation ). this stress testing software is different from common

Install Redis in CentOS6.4 First, we will introduce the Redis database. Redis is a memory database for "key/value" pairs of data types, which can meet our needs for reading and writing massive data.1) redis keys can only be strings; 2) redis values