Database Administrator

Two auto-increment methods for Oracle Database primary key (SEQUENCE and trigger)1. Preparations Create an Oracle database table. In the user table SYS_USERS, user_id is the primary key. -- Create tablecreate table SYS_USERS( user_id NUMBER(9)

Oracle Index Clustering Factor (cluster Factor) I. Description: During the test today, we found that there was an index on the field, but the execution plan did not go through the index. After searching on the internet, we found that it was caused

Use XtraBackup for MySQL master-slave replication without locking tables Xtrabackup is an open-source project of percona to implement the innodb Hot Backup function similar to InnoDB's official Hot Backup tool. It can quickly back up and restore

Online MySQL backup script Recently, I am studying database backup and regularly execute the backup task. Here I set the backup script to the crontab command for regular execution. The script content is as follows:[Root @ mysql-db ~] # Cat

Compile MySQL source code using Eclipse-cpp in Ubuntu 1. Download The eclipse-cpp-mars-2-linux-gtk-x86_64.tar.gz package, decompress it in Ubuntu, and run it. Jdk errors may occur because jdk is not installed or the jdk version is too low. Jdk1.8

How to solve the INS-30131 error when installing Oracle You need to learn about SDE configuration. The Oracle Database Installation Error INS-30131 does not solve the problem. However, you have found a preliminary idea and recorded it for your

Install MongoDB in Linux MongoDB provides 32-bit and 64-bit installation packages on Linux. You can download the installation packages from the official website. : Http://www.mongodb.org/downloads Download the installation package and decompress

Precautions for revoking DBA roles Oracle has very fine-grained permissions. To facilitate the management of numerous permissions, Oracle introduces the role logic concept and also sets many roles in the system. In actual applications, application

Common PHP Redis operations, phpredis connect ('2017. 0.0.1 ', 6379);/** string */$ redis-> set ('name', 'huangyuxin'); echo $ redis-> get ('name '); $ redis-> setex ('name', 10, 'setex '); // set the lifecycle $ redis-> del ('name '); // delete/**

MySQL stored procedure details mysql stored procedure and mysql stored procedure details /* Create a stored procedure */ /* Specify an ending mark before creating a stored procedure */ DELIMITER $ CREATE PROCEDURE test_pro1() BEGIN SELECT * FROM

-- Create a tableDrop table test cascade constraints;Create table test (a varchar (30), B VARCHAR (30 ));-- View specific PermissionsSelect distinct privilege from DBA_SYS_PRIVS where privilege like '% DIRECTORY % ';-- Authorize SCOTT with SYS

How to Understand oracle 11g scan ip Before 11.2, the client should use vip when connecting to the database. If your cluster has four nodes, the client's tnsnames. in ora, there should be a connection string of four vip hosts. If a node is added to

MYSQL Basics1. Join multiple tables1. Inner join-the primary key of the table is connected to the foreign key, and only data with the same key value is retrieved.Select user. name, order_basic.oid from order_basic inner join user on order_basic.uid =

www.codeke.com List name enter a word enter the old word select Operation Type Add Delete change query Title: Add news query news www.codeke.com setDanci ($

In fact, I have been preparing the basic materials for another blog post, but I chatted with my friends and asked me what I was doing recently. I said I was working on the System Log Module, after talking with him, this blog came into being. All

Basic Concepts Nested loop join: Each row in the Outer table joins the corresponding records in the inner table, similar to a nested loop. Sort merge join: Sort the two tables and then join them. Hash join: Create a Hash table in the memory to scan

BKJIA: Ronald Bradford answered the last question. He is an RDBMS expert and one of the speakers at the upcoming MySQL conference. He has rich experience in MySQL integration. In the following Q & A, he discussed the advantages and disadvantages of

I have introduced a lot about databases before, for example, using dynamic databases to access objects. Next I will explain how to reduce database management overhead. Connect to the application Each application needs to identify the database server

With the development of enterprise business, there are more and more large data warehouses, and their scale is also expanding rapidly, increasing by three times every two years on average. Large Data Warehouses require scanning dozens, hundreds, or

Security Set the password to be used before other settings are made after the client connects. Warning because redis is quite fast, an external user can try a K password in one second on a better server, this means you need to specify a very