Database Administrator

Troubleshooting of MySQL cluster architecture and configuration problems First, let's talk about the advantages and disadvantages of MySQL. Advantages Solving single point of failure Automatic data redundancy The disadvantage is that maintenance

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

Differences between sysdba, sysoper, and dba For sysdba, sysoper, and dba, many terms may be used at work. If the environment is a server, sysdba may be frequently used. DBAs are required permissions for database maintenance. The official Oracle

DBMS_METADATE.GET_DDL, dbmsmetadata You can use the package dbms_metadata.get_ddl to view a table or table space DDL. Detailed parameters of the get_ddl function in the dbms_metadata Package: The GET_DDL function returns the DDL statement of the

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

Step by step, gathering small streams ------ oracle easily modifies the entire row of data, ------ oracle As you learn more and more about your knowledge and discover your own shortcomings, record the knowledge you learned this time. Although

8. mysql dual-host Master/Slave, mysql dual-host In this era of data explosion, data backup is the most important thing for every company. As a data storage warehouse, the importance of database is self-evident. Major databases include: 1. Large

Oracle query does not mean that the condition contains null values. oracle query contains null values. Requirement: currently, the is_use field in the oracle database has the following values: null, 0, 1, and 2. Now you need to query data not equal

04. Linear table (iii) chain storage structure. Single-chain table 2. Chain-chainChain storage structure. Single-chain table 2The creation of an ordered storage structure is essentially an array initialization. The storage space is continuous and

Database Course Design -- Summary of "coffee tea" sales management system and database Course Design The one-week database course design was finally completed to summarize some experiences and lessons learned. The basic knowledge should be kept in

Define system fields in QlikView and qlikview Fields In Settings-> User Preferences, there is a "Show System Fields" option. If this option is selected, you can select the system field when creating a List Box. Otherwise, no. How to define system

Oracle Installation tutorial, oracle Installation tutorial The installation of Oracle reminds me of the time when I installed SQL server last year. I 'd like to record the installation and hope to help some people. First of all, I will not talk much

Redis In-Depth Data Structure: redis Data StructureRedis main Data Structure Linked List Redis uses a C language that does not have a built-in data structure, so Redis has built its own linked list implementation. One of the underlying

SQL statement concise tutorial for linux --- CREATE VIEW, concise tutorial --- create A View can be considered as a virtual table. Unlike a table, a table stores actual data, while a table is built on a table architecture and does not actually store

Oracle database software patch on windows platform, oracledatabaseFor windows: Oracle provides bundled patches for Microsoft Windows platforms. recommended patches are encoded in these bundles rather than as separately downloadable patches. see Note:

About ORA-03113: End of communication channel, ora-03113 Channel Author: iamlaosong A SQL query statement, successful execution or error, irrelevant to the statement, but related to the value in the condition, the error is the ORA-03113: The end of

Description of Oracle 12c CDB and PDB database startup and shutdown, 12 cpdb     In Oracle 12c, it is divided into CDB and PDB. Their startup and shutdown operations are as follows.  1 Container Database (CDB)   For CDB, the startup and shutdown

A perl script, used to send remote MySQL commands, perlmysql Below is one of the basic scripts to write some scripts that simplify management operations. For a user who has never used a perl script, it is still difficult to directly use the

How to Use navicat for mysql to connect to a local database and import data files How to Use navicat for mysql to connect to a local database and import data files1. Introduction Navicat for mysql is a database management tool designed to simplify,

Check items before deleting oracle archive logs, oracle Archive This article is an original article, Reprinted please indicate the source Http://blog.csdn.net/msdnchina/article/details/41413313 To delete archived logs, you must confirm the