Database Administrator

Cacti Monitors multiple MySQL instances The Cacti official website provides templates for monitoring MySQL. Only the default port 3306 can be monitored, but the current port is not 3306. How can we monitor it? 1. upload ss_get_mysql_stats.php to

Oracle analysis functions (notes) Analytics functions are new types of functions introduced by Oracle Database in 9i and are continuously enhanced in later versions. The analysis function provides the ability to aggregate reference values across

PostgreSQL Stored Procedure return dataset instance Here we use an instance to demonstrate how to return a dataset from a PostgreSQL stored procedure. 1. Prepare the data table first. // Member_categoryCreate table member_category (id serial, name

ORA-21561: OID generation failed A very strange problem occurs: Linux5.8 + Oracle 11.2.0.3 When starting the database, an error is reported: [Oracle @ tivoli02 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Thu Oct 23 21:23:16 20

Unreasonable setting of MAXPIECESIZE and FORMAT causes RMAN backup failure Today, I went to the customer to build the DG. When I created the RMAN backup set, I encountered a problem, causing the backup set to never be generated. Because the customer'

MySQL InnoDB shared tablespace and independent tablespace MySQL is always used to be compared with Oracle databases. When learning the storage structure of MySQL InnoDB, it is inevitable to compare it with Oracle. Oracle Data Storage includes

Database Concurrent transaction control 1: Summary, Database Concurrent transactions OverviewConcurrency control is a key technology of DBMS.Database operations are performed in transactions.A transaction is a group of mutually dependent operations.

Use cgroup to restrict disk io of processes, and cgroup process disk io Cat/etc/cgconfig. conf # # Copyright IBM Corporation. 2007 # # Authors: Balbir Singh # This program is free software; you can redistribute it and/or modify it # Under the terms

Redis Research (17)-SORT sorting, redis research sort sorting 1. Set Operations of Ordered Sets The set type provides powerful set operation commands, but the ordered set type is required if sorting is required. When designing Redis commands, the

Mysql database permission issues, and solutions, mysql Permissions In the past, after directly installing mysql database and using the root user, you can log on to the command line or remotely perform operations. Since mysql was acquired by oracle,

Oracle uses a cursor to delete all record scripts in all user data tables. oracle cursor Application Scenario: because the data in the database involves confidential information, we hope to delete all the data at a time and only keep the data table

Ogg _ cascade replication ', ogg ReplicationCascade replication: node1-> node2-> node 3[Oracle @ dominic dump_dir] $ cat/etc/hosts 127.0.0.1 localhost. localdomain localhost4 localhost4.localdomain4: 1 localhost. localdomain localhost6

Installation and configuration of MySQL green decompress version, mysql green decompress version The MySQL version used in this example is the MySQL-5.6.17-winx64. [For more information, see http://blog.csdn.net/mahoking] Procedure: 1. Install the

Oracle lock 3: DDL lock, oracle lock 3ddlWhen an ongoing DDL operation is executed or a schema object (Note) is referenced, the Data dcictionary (DDL) Lock is used to protect the definition of the schema object, only a single schema object is locked

Redis Research (9)-ordered set type 2, redis research set type The previous article has talked about some commands of the ordered set type. Http://blog.csdn.net/wtyvhreal/article/details/42804571 Iii. Command collection 1. Get the number of

Optimize SQL Execution path to improve report performance and SQL Execution path report When performance problems occur in reports and data source computing needs to be optimized, it is difficult to determine the execution path. Therefore,

T-SQL time format CONVERT (), t-sqlconvertFunctionReturns the expression converted to the provided data type.Syntax CONVERT (data type, expression [, format-style]) Example: convert(varchar(10),getdate(),112) Parameters The data type expression

Parse xml to initialize the database, parse xml to initialize To facilitate the development or launch of the project, you may need to initialize the database, including users, permissions, or some other basic data. I use the parsing Xml file to

Oracle Database Synonyms (SYNONYM), oraclesynonym This tutorial uses examples to illustrate how to create and delete Synonyms (SYNONYM) in Oracle Data ). Concept Synonyms refer to database objects (tables, views, sequences, stored procedures, and

Thinking about orcle 11g select count (*) from v $ lock, orcle11g recently, we found that the query by orcle 11g select count (*) from v $ lock is very slow, and I think it is necessary to perform a detailed analysis: select count(*) from v$lock;--