Database Administrator

New Features of Oracle 11g-HM (Hang Manager) In this article, we will introduce the new features of Oracle 11g-hang Manager. We need to note that HM only exists in the RAC database. When we diagnose database problems, we often encounter

Summary of new features in Oracle 12C SQL Multiple indexes on the same field Before Oracle 12c R1, a field cannot have multiple indexes in any form. Some may wonder why a field usually requires multiple indexes. In fact, there are many fields or

How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu This article has been tested by ourselves. The system is Ubuntu 14.04 server, and the Mysql database is Mysql 5.5. We are preparing to migrate it to Maria DB 10.1, for details about the

A simple Redis application and a simple Redis ApplicationRequirement I have heard of Redis for a long time, but I have never studied it. Because some friends needed to use it a while ago, I looked at it when I asked. I just recently met my own needs

Uninstall MySQL Enterprise Monitor and mysqlenterprise in LinuxMySQL Enterprise Monitor is an Enterprise-level monitoring designed specifically for MySQL databases. It can be well integrated with various MySQL features, including: mySQL's key

Sas memo (1), sas memo Simple dataset output Logs 85 libname saslib base 'e: \ sasdata '; NOTE: The logical Library Reference name "SASLIB" has been successfully allocated, as shown below: Engine: BASE Physical name: E: \ sasdata 86 87 data saslib.

Redis database of NoSQL Database: Redis introduction and installation and deployment, nosqlredisZookeeper NoSQL (NoSQL = Not Only SQL) refers to non-relational databases. With the rise of Internet Web websites, traditional relational databases are

Oracle uses a cursor to add a primary key statement to all user tables. oracle cursor Application Scenario: adding an auto-increment primary key to a data table can speed up data table access, and is the fastest in integer indexing. This program is

Ubuntu SQL tutorial for new mysql users and ubuntumysql for new users Ubuntu SQL tutorial for mysql beginners   1. Start the mysql database: Effect: 2. Enter mysql: Effect: 3. view all databases: Effect: 4. Create a database:

The path to installing and detaching Oracle databases: The Path to oracle databases ========================================================== ============================================== ====================================== 1. If there are two

Step by step, gathering small streams ------ oracle quick add test data, ------ oracle Some time ago, problems were found during implementation and need to be modified at that time. Because the data in the database is real data, it cannot be

Mysql build and basic commands, mysql build commands I. mysql setup process Install mysql on ubuntu 1. sudo apt-get install mysql-server 2. sudo apt-get install mysql-client 3. sudo apt-get install libmysqlclient-dev 2. Basic commands-Logon,

Oracle Partition Table Technology (Partitioned Tables), partitionedtables Since Oracle 8 (around 1997), the concept of Partition Table & partition index (Partitioned Tables & Indexes) has been introduced to adjust large Tables and large Indexes to

Innobackupex-based Incomplete recovery and Innobackupex-based recoveryFor incomplete MySQL recovery, we can use Innobackupex's multiple backups and binlog to restore the database to any point in time. Incomplete recovery (also called point-in-time

Hadoop authoritative guide Study Notes 3: hadoop authoritative study notesHDFS Introduction To put it bluntly, Hadoop is a File cluster that provides big data processing and analysis. The most important one is HDFS (Hadoop Distributed File System),

Summary of database Principles and Applications Review questions, database principles questions   Summary of database Principles and Applications Review questions I. Single-choice questions (1 point for each question, 20 points in total) 1. In the

SymmetricDS installation records and metrics ricds records This installation record is based on the example in the getting ricds Quick Start Guide and installed on two machines.Installation environment Machine1: hadoop3.highgo.com Machine2:

OLAP introduction (combined with personal work), olap introduction combined with personalOLTP and OLAPTraditional database systems are OLTP and can only provide raw data operations. Analysis is not supported. OLTP system: Performs online transaction

Oracle lock table troubleshooting example: Oracle lock table troubleshooting One time a developer directly runs the delete table operating system on the database server during peak hours, resulting in no response for a long period of execution. Then,

SQL Server synchronous replication troubleshooting method, SQL Server 1. the row cannot be found on the subscription server when the command copied by the application is run. Solution: Use System stored proceduresSp_browsereplcmds(Return the