Database Administrator

Common Redis commands and master-slave Database Configuration Redis provides a variety of commands to operate databases and various data types. (1) keys Returns all key values that meet the specified pattern. For example, to return all keys, use:

Oracle Stored Procedure instance memo Oracle Stored Procedure instance memo Statistical report: the number of user logins (platform clicks) at the beginning of each month. The scheduled tasks count the number of logins, number of Logon accounts, and

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"

Mysql Installation and Use In OJ, mysql is mainly used to store user information. It is easy to install and use. The following is a brief introduction. First, I will explain that my Linux branch environment is Ubuntu 12.04, and the general steps of

Mysql foreign key Usage introduction, mysqlforeign I. Basic Concepts 1. MySQL has the same definition of "key" and "Index", so foreign keys and primary keys are also an index. The difference is that MySQL will automatically index the primary keys of

Problems with data import in different mysql versions: mysql version Data Import The original mysql version is 3.4.10.1deb1, and the target mysql version is 5.0.51b-community-nt-log. The following error occurs during data import: 1. DELIMITER You

MYSQL master-slave synchronization configuration for CentOS and centosmysql master-slave 1. Both the master and salver close the firewall iptables and execute the service iptables stop command: Set SELINUX = disabled for The SELINUX file ,: 2.

Oracle performance optimization operation 8: Use HINT to forcibly specify the index, oraclehint When the ORACLE optimizer cannot use a reasonable index, the HINT is used to forcibly specify the index. In the example of "oracle Performance

One ORA-00130: invalid listener address error, ora-00130listener Log on to the database. The following message is displayed: Ora11g> sqlplus dcsopen/dcsopen1SQL * Plus: Release 11.2.0.1.0 Production on Mon Jan 5 18:49:31 2015 Copyright (c) 1982,200 9

The unique identifier (ID) of the database. Background: In years of work, we have designed many system or product databases, including single-host databases, lan databases, and Internet databases. For different environments, the design

Sharp SQL2014: Join algorithm, sql2014 join algorithm  When performing a query in Microsoft SQLServer Management Studio, if you select the button in the toolbar, you can see the execution plan generated for the query. The execution plan graphically

Seven service descriptions for oracle11g and oracle11g A total of 7 services have been installed at oracle11g. 1. oracle orcl vss Writer Service: Oracle Volume ing Copy write Service. VSS (Volume Shadow Copy Service) allows storage basic devices

Mongodb installation and VerificationInstallation plan:System Environment: Centos-6.5Software: mongodb-linux-x86_64-2.6.5.tgz: Http://www.mongodb.org/downloadsInstallation machine: 10.10.10.110Upload location:/dataSoftware installation

How can I use the IP address after ORACLE modifies the IP address? Author: iamlaosong After the IP address of the oracle database server changes, the listening process cannot be started. You need to modify the corresponding configuration file: 1.

In the hpux operating system, select the lv from the vg, make the lv into a file system, and then mount the file system, In the hpux operating system, select the lv from the vg, make the lv into a file system, and then mount the File System Create

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

Linux does not allow MySQL to distinguish the case sensitivity of table names.Problem description: Today, a project database is transplanted to the liunix server, and the table cannot be found. The query database does exist. After analysis and

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: