Database Administrator

Redis Transaction Processing Current redis version # Redis-cli-vRedis-cli 2.6.4 MULTI, EXEC, DISCARD, and WATCH are the foundation of Redis transactions. 1. The MULTI command is used to start a transaction. It always returns OK.After MULTI is

Nagios monitoring Oracle alert Log script Click Nagios to know how to use it.# Add nagios to the oinstall Group# Usermod-a-G oinstall nagios #! /Bin/shDbversion = 11Bdump

Manually uninstall Oracle Database 11gR2 using the command line There are two ways to uninstall Oracle: one is to automatically uninstall Oracle using DBCA, and the other is to manually uninstall Oracle using commands. The following describes the

MySQL transaction processing and lock mechanism 1. Transaction Processing and concurrency 1.1. Basic Knowledge and related concepts 1) All table types can use locks, but only InnoDB and BDB have built-in transaction functions. 2) use begin to start

The atomicity of MongoDB upsert operation concurrency, mongodbupsert When C ++ is used to perform the update operation on MongoDB, if the upsert parameter is set to true, data that does not exist is automatically inserted. In a high concurrency

Description of dbfsize output and dbfsize output [Oracle @ rhel63single test] $ which dbfsize/u02/app/oracle/product/11.2.0.4/db_1/bin/dbfsize [oracle @ rhel63single test] $ [oracle @ rhel63single test] $ [oracle @ rhel63single test] $ [oracle @

Difference between DBMS_UTILITY.GET_TIME and DBMS_UTILITY.GET_CPU_TIME, dbmsutility Comparison between DBMS_UTILITY.GET_TIME and DBMS_UTILITY.GET_CPU_TIME Http://www.oracle-developer.net/display.php? Id = 307 Developers have been familiar with

MySQL 5.6.22 installation tutorial, mysql5.6.22 MySQL5.6.22: Click to download 1. Run the mysql-installer-community-5.6.22.0.msi installation package 2. Developer Default installation type Server only acts as a Server Client only serves as the

Use a stored procedure to update Tables in batches and a stored procedure to update Tables in batches Recently, we have made a demand to update database tables in batches. However, because there are a large amount of data involved (tens of millions

MySQL "Bind on TCP/IP port: Address already in use", mysqlbindRecently, a MySQL instance has been added to the server where MySQL Enterprise Monitor has been deployed. As a result, the MySQL Enterprise Monitor Instance becomes abnormal and cannot be

Install oracle10 in SUSE Linux and solve the problem. suseoracle10 I have summarized my experience in installing oracle10g on Redhat5.5 and SUSE10.1. When SUSE10 is installed with OraRun, the oracle user, oinstall group, and dba group will be

A large number of ons processes are generated in the RAC environment, resulting in Resource depletion of user processes. Resource temporarily unavailable and racons are displayed during User Switching.Basic elements (time, user, problem) The user

Use of Oracle exp/imp Export Import tool-1, expimp The exp export tool compresses data backup in the database into a binary system file, which can be migrated between different operating systems. The imp import tool imports binary system files

Use of Oracle exp/imp Export Import tool-2, expimp Iii. Problems with import tool imp (1) The database object already exists. Generally, tables, sequences, functions/processes, and triggers under the target data should be completely deleted

Comparison of Not In non-equal signs. It is better to use exits instead of in. Not in will be converted into a series of and during parsing <> Case 1 SELECT @results = count(filterCriterion_sv) FROM tbl_IN_VS_AND WHERE filterCriterion_sv NOT IN (214,

Redis Research (6)-set type, redis research set type I. Introduction A set key can store up to 2 ^ 32-1 strings. In Redis, the set type is implemented using an empty hash table, so the operation complexity is O (1 ). The Union, intersection, and

Deploy the MysqlCluster cluster in Ubuntu and use tumysqlcluster.Deployment environment:System: ubuntu-12.04.4-serverMysql-cluster-gpl-7.3.7-linux-glibc2.5-x86_64.tar.gz Note:1. Do not install Mysql before deployment. Some people use apt-get for

Back up Oracle with Netback reports ora-27206 error handling, netbackora-27206 Today, my colleague encountered a problem with database backup. The error message is as follows: channel ch01: starting piece 1 at 2015-01-12:22:06:56RMAN-03009: failure

The reason why the oracle task process is not executed after it is submitted is /* Run the following command in SQL * Plus */-- check steps when the task is not running -- 1. check whether the instance session is RESTRICTED by select instance_name,

Mysql fuzzy query optimization and mysql fuzzy query First, create an index for the fields to be searched in the database (mysql index is unfamiliar, please refer to here ). Secondly, use the following function for fuzzy search. If the position is