Database Administrator

Bulk collect for batch processing of multi-row data When writing pl/SQL statements, a typical mode is often used to define a cursor and process the values cyclically from the cursor.Similar to the following formatDeclareCursor xxxx is

New Features of MySQL5.6-Batched Key Access 1. Introduction MySQL 5.6 provides many performance optimization features, one of which is about the Batched Key Access (BKA) algorithm to improve the performance of table join. This article will combine

Oracle-provides dynamic result sets for subqueries We have encountered such a requirement: to input a String for the method, such as "User ID0, user ID1, user ID2... ", then return a result set based on these IDs as a data table for query by

XtraBackup online MySQL Master/Slave deployment 1 [Preface] There are many master-slave deployment methods for MySQL. The most common method is mysqldump. As we all know, mysqldump has two major disadvantages: 1. The master database needs to lock

DataGuard slave database ORA-01196 fault recovery, dataguardora-01196 Symptom When shutdown abort is used to stop the slave uard slave database, the slave database cannot be open, and a ORA-01196 error is reported.   The details are as follows:   If

ORA-1092: opitsk aborting process --- killed by oom killer, opitskaborting Oracle version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production OS version: Linux x86 64-bitOracle alert Log error: opiodr aborting process

Configure redis Internet access and configure redis access Environment Description InLinuxInstall the redis Service InWindowsThe xampp environment is installed in. For PHP running The PHP code is as follows: connect('192.168.1.4', 6379);

MySQL view and mysql View Part 1: Basic concepts and applications 1. View Overview The MySQL view and the Oracle view are a concept, that is, a virtual table with no data, and the data is stored in the base table; 2. Add a view 1: syntax CREATE [Or

SQLDMO registration, sqldmo not registered When maintaining the personnel system, Shi Jie asked us a functional problem. Yellow Pages are reported during database backup. Then we need to find the cause and make a solution. At first, I started from

Start and Stop the mongodb database.The start and stop of the zookeeper database is the most basic operation of the database and the prerequisite for the database to provide services and be connected to and managed. There are some differences

A preliminary understanding of EF, a preliminary understanding of English EF: EntityFrameWork is a framework (the so-called framework can be understood as directly using code already written by others), and this framework is an ORM framework (Object/

Sqlplus logon fails to locate the program Input Point longjmp in the dynamic link library error message, sqlpluslongjmp Problem description: When we log on to Oracle sqlplus as follows, the program cannot be located. The longjmp input point is in

SQL server is installed by default, how to create a new user and password, SQL server 1. Adapt to window identity Login2. Create a queryCreate login logs 1 with password = '000000'Create user bai2 for login lifecycle 13. Right-click the attribute

Example of myloader restoring mysql database and myloadermysql Mydumper is a lightweight third-party open-source tool for mysql database backup. The backup mode is logical backup. It supports multithreading, And the backup speed is much higher than

MySQL profiling usage, mysqlprofiling The two most common bottlenecks of MySQL databases are the CPU and I/O bottlenecks. When the CPU is saturated, it usually occurs when the data is loaded into the memory or the data is read from the disk. The

Common shell for mongodb and mongodbshell > Use cmd_test // create a database Switched to db pai_test > Db. createCollection ("test") // create a table as a set. {"OK": 1} > Db. Db. addUser (db. group ( Db. adminCommand (db. groupcmd ( Db. auth (db.

Mysql/Java server support for emoji, mysqlemojiPreface: Recently developed iOS projects require the storage of user text, and naturally encounter the problem of how emojis such as emoji are supported by mysql DB. After several days, the switch and

Use force index to optimize SQL statement performance, forcesql Today, I wrote a statistical SQL statement, which is executed on a table with nearly million pieces of data. No results can be found within S. The SQL statement is as follows:

Oracle primary and foreign key management, oracle Key Management Use the primary and foreign key constraints to ensure data integrity. 1. query all the constraints on the table Select * from user_constraints tWhere t. table_name = 'father '; 2.

Mongodb Study Notes 08 and mongodb Study Notes Official documentation:Http://docs.mongodb.org/manual/replication/ Replication sets multiple servers maintain the same data copy Step 1: how to use a replica set When mongod is started, you must