Database Administrator

64-bit installation of Redis in CentOS 6.4 I. Introduction REmote DIctionary Server (Redis) is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set, and zset) and hash (hash type )

Use of quote in Oracle To express a special character string in SQL or PLSQL, it is usually packaged. However, if the string itself contains characters like 'or', the implementation is a little complicated. For example, My Name is "Wang Xiu Li"

Table constraint-based custom implementation constraint rules and constraint rules Question 1: /* Table Name: The TABIDParentIDName10A21A-B31A-C constraint parent ID (ParentID) can only be 0 or TAB. ID record */ Method1: (use functions to

Introduction to MySQL decimal and numeric data types, decimalnumericMySQL decimal and numeric data typesDECIMAL (M, D) Example: salary DECIMAL (5, 2)In this example, 5 (precision) represents the number of important decimal digits, and 2 (data range

Oracle user password, oracle user password How to change the user password in Oracle In the Oracle database, use alter user to change the user password. Syntax Alter user user_name identified by new_password; Parameter description:

Non-clustered indexes solve the deadlock problem in big data search, I read a blog by Li you two days ago about SQL Server deadlock. Original article: http://blog.csdn.net/senior_lee/article/details/42275565. 1. Topic description First lookProblem

Database transaction isolation and lock, database transaction isolationOverview I have learned about database transaction isolation and lock. Now I want to explain my understanding. Database transaction isolation Concept Transaction: Multiple SQL

Use of Merge in SQL Server, sqlmerge Many people know that ORACLE has the Merge keyword. In fact, SQL Server also supports Merge from the beginning of version 2008. You can also perform Update, Insert, and Delete operations in the same SQL statement

A thrilling Percona XTRADB Cluster data restoration process [MySQL], perconaxtradbA thrilling Percona XTRA Cluster DB data restoration process At noon on January 27, the phone rang and was called by YI, a colleague. He told me that there were a lot

Today is much faster than half past one. Yesterday, I helped my former colleague optimize an oracle database. Today I asked the engineers at the site: What feedback does the customer have when doing business? Then, the engineer at the scene replied:

Oracle Data Type, oracle The core of the Oracle database is a table. The common data types used by columns in the table are as follows:CHAR (length)Stores fixed-length strings. The length parameter specifies the length. If the length of the stored

MySQL Proxy and mysqlproxy Author: zhanhailiang Date: MySQL Native Driver (mysqlnd) is introduced as a substitute for libmysqlclient in PHP5.3.0. Previously, MySQL database extensions mysql, mysqli, and pdo mysql All communicate with MySQL Server

Create an oracle index and an oracle Index You can use indexes appropriately to increase the data retrieval speed and create indexes for fields that frequently need to be queried. Oracle indexes are divided into five types: Unique indexes,

Introduction to mysqlnd extension and mysqlnd Extension Author: zhanhailiang Date: MySQL Native Driver (mysqlnd) is introduced as a substitute for libmysqlclient in PHP5.3.0. Previously, MySQL database extensions mysql, mysqli, and pdo mysql All

Oracle transaction principle Inquiry 1 -- oracle Core Technology Reading Note 5, oracle1 -- oracle 1. Conflict Resolution Suppose there is a system that only has two users: You and me, and we are constantly modifying and querying a small part of the

MySQL Server alarm script, mysqlserver Author: SkateTime: 2014/12/30   MySQL Server email alert : Http://download.csdn.net/detail/wyzxg/8314745   Implementation Method: The system's load and session are used to determine whether the system's current

In xml, SQL statements are processed much less than numbers, and xmlsql When we need to process SQL statements in xml format, symbols such as ,> = are often used, but it is easy to cause xml format errors, this will cause the background to convert

ORACLE-008: classification statistics, oracle008 Classification Classification statistics are usually used to count the number of items or the number of items under a certain item. Simple, such as tab_test Tab_test record Id Co

About MySQL's SLEEP (N) function, mysqlsleep FunctionWe all know that you can run this statement for N seconds by executing select sleep (N) in MySQL: mysql> select sleep(1);+----------+| sleep(1) |+----------+| 0 |+----------+1 row in set (1.

02. Linear table (1) sequential storage structure, 02 linearSequential Storage StructureI. Basic concepts of linear tables1. Linear table definitionA linear table (list) is a finite sequence of zero or more data elements. All data elements are of