Database Administrator

The Internet has proved to be the most effective way to share information since the first submarine cable laying across the Atlantic Ocean, costing up to $2 million a day in 1866. This cross-Atlantic submarine cable is the world's first network,

(1) privilege: the privilege is the power to execute a special type of SQL statement or access another user's object. There are two types of privileges: SYSTEM privileges and object privileges.System privilege: it is the right to execute a special

Here I will only briefly introduce these two commands, but they are used in the process of use. So I will mention them here. If you are interested in this, you can search for more introductions. Please share them ~~ A Database Transaction starts

When some SQL commands are executed in the MySQL database, it may need to create some internal temporary tables to perform complex sorting or grouping queries. MySQL temporary tables can be divided into in-memory and on-disk. If possible, MySQL

In Java Development, when using Oracle database, it is often encountered with ORA-01000: maximum open cursors exceeded. Error. In fact, the cause of this error is mainly caused by code problems. Ora-01000: maximum open cursors exceeded. Indicates

GC Resource ManagerOfficial documentation: administrator's Guide-> 24 Using the Database Resource ManagerUsage: less used in the actual production environmentPurpose: restrict the use of database resources, CPU memory undo tablespace I/O

This installation/uninstall method is applicable to various Mac OS versions, such as mavericks and lion. Installation: Only two steps are required: the first line command installs the tool homebrew, and the second line uses homebrew to install

Note:I originally wanted to create a replica uard test for the no target database by using the backup set of the target database. I found that it could not be implemented in principle, but it has a very useful function, allows you to quickly recover

Solutions to incompatibility during MySQL installation on Linux: [Root @ localhost ~] # Rpm-ivh MySQL-server-5.5.24-1.linux2.6.x86_64.rpmPreparing... ######################################## ### [100%]File/usr/share/mysql/charsets/README from

MongoDB cluster creation MongoDB replication cluster type: · Master-slave mode (master/slave) · Replica set mode (replica set) The copy and mode have at least three nodes (one master node and two slave nodes). The slave node is responsible for

DB2 logs are divided into two modes: log loop and archive log, which are non-archive and archive modes. The following describes the two methods and their relationship with backup archiving settings. 1. Log Loop This is the default mode, that is, non-

1. recently, I used Oracle many years ago to import oracle dmp files. The technology I used was nearly forgotten over time. Now I mark it here, so as not to feel helpless when you encounter the same problem again. To import a dmp file, you need to

Oracle, as the most popular commercial database, provides a series of HA solutions in addition to independent database DBMS, to meet actual O & M system requirements. Among them, RAC + Dataguard is our most common HA policy solution and is also

Normally, when the current control file is lost or the current control file is inconsistent with the control file to be restored, we need to re-create a control file or use unsing Backup controlfile to restore the control file. To put it simply, as

Indexes can be used for like 'xxx % 'in MySQL, but like' % xxx % 'cannot. mysql> desc artist;  +------------+-----------------------------------------------+------+-----+---------+-------+  | Field      | Type                                

After carefully studying the GoldenGate enterprise-level O & M practices, I focused on my understanding of several OGG processes. Combined with my understanding of the principles, I tried the experiment for nearly two days and configured it four

The Open Database Connection (ODBC) interface is defined by Microsoft Corporation and is a standard interface used in Windows to connect client applications to the database management system. You can specify the connection parameters to connect.

BKJIA: Both MongoDB and CouchDB are document-oriented databases, both of which use JSON document formats. They are generally seen as NoSQL databases and are very fashionable nowadays, there are many commonalities, but the difference between the two

XXXL transaction log Q: Our products use SQL Server to store data. We will release new product versions from time to time, including upgrade scripts for running databases. As we test our latest upgrade script in a typical test database, the size of

Sybase ase transaction log Each database of sybase ase, whether it is a system database master, model, sybsystemprocs, tempdb) or a user database, has its own transaction log, and each database has a syslogs table. Logs record user operations on the