Database Administrator

Command summary for operating MySQL in Linux Command lines (Note: commands in the MySQL environment are followed by a semicolon as the command Terminator) 1. commands for starting MySQL in Linux: Mysqladmin start/Ect/init. d/mysql start (the

Quickly deploy an Oracle RAC environment using an Oracle VM Template Oracle VM templates are pre-packaged and pre-configured virtual machines. In the communication between enterprise-level customers, I often use "simple, fast, and error-free" to

Oracle snapshot standby database's scheduler jobs are not executed In Oracle 11g, the snapshot backup snapshot standby database feature of data guard is more suitable for rapid deployment of a temporary test database that is the same as the online

[Test] database system principle (II)-detailed explanation (database design and ER Model), database system principle er Everything has a lifecycle. Of course, the database system is no exception! The database design and ER model chapter mainly

[MongoDB] Installation of MongoDB, mongodb First what I wanna make clear is that in the official website the detailed process of installation has been described. you cocould call it throught the

Use init-connect and binlog in MySQL to track user operations, init-connectbinlog Preface:In the test environment, several important data records are deleted. Because only the public account is deleted in the binlog, you cannot query who logged on

Use MySQL Big Data Limit, mysql DATA limit Today, I am very surprised that the performance of the same function in MySQL varies by order of magnitude. First look at the unique id key index title of the ibmng (id, title, info) table. Let's take a

Question: In my daily work, I think MySQL plus is used in 99% to log on to the database and manage, optimize, and configure the database. If there are many databases, all of them are unified SQL after connection>, it may happen that we do not know

Oracle databases differ significantly from MSSQL data operations, but there is an analogy in image operations. This article describes how MSSQL database images are implemented in Oracle databases. What are the differences between them.First, the

Migrate SQL server data to mysql and sqlmysql The newly added project is just getting started, and many technologies have not yet been finalized. Originally, the team lead decided to use SQL server. These days they have been busy designing

MySql Performance Tuning (5) demonstration of using a proper lock mechanism for table locks, mysql Tuning MySql locks take the following forms: 1. Table-level locks; low overhead, fast locking; no deadlock; large lock granularity, the highest

Oracle transparent data encryption (TDE) real-world use analysis, oracletde Since the R2 version of Oracle Database 1Og, a feature called TDE makes data encryption extremely easy. All we need to do is to declare a column as encrypted, and the rest

Content Define Collection type Declare Collection variables Initialize and reference Collection Reference Collection Element Assign a value to Collection Multi-dimensional Collection Compare Collection Collection Method Collection

SQL statement implementation that limits the number of data queries in ORACLE and SYBASE databases. oraclesybase I. Overview For some software that needs to deal with a large amount of data through databases, processing performance is very

Overview This is to install Oracle 10 on LinuxGThe first part of the main software component guide series. These articles detail all three of Linux's certified English release kits without introducing Asianux) and assume that cheap Intel x86

NoSQL has now become a very popular topic in the IT industry. In this article, we will introduce you to the basic knowledge of CouchDB, a member of NoSQL, and take you into the world of NoSQL.   What is NoSQL? NoSQL (short for not only SQL, also

Many friends think that in simple mode, the heap table cannot retrieve a record because there is no log record. In fact, in a sense, it can be recovered, because the heap table only changes the row offset when deleting records, and the actual data

Using script files to manage Oracle databases has great advantages. For example, you can reduce the command input. For example, you can save the commands that pass the debugging test so that you can use them again when needed. For example, you can

Use the transparent data encryption (TDE) of the Oracle database introduced as part of Oracle Advanced Security Option Version 10.2 and later ), you can selectively Encrypt sensitive database data stored in the underlying database data files and all

When sorting, grouping and summarizing, and indexing are performed in the Oracle database, a lot of temporary data is generated. If there is an employee information table, the database stores the installation record creation time. If you use the