Database Administrator

Case study of MySQL startup failure data recovery Forcing InnoDB Recovery provides six levels of repair mode. Note that when the value is greater than 3, the data file will be permanently damaged and cannot be recovered. The six levels are excerpted

The permissions of Oracle Applications under grid and Oracle users are inconsistent, resulting in failure to connect to ASM In RAC, the following error is reported when the database is started: Oracle instance started. Total System Global Area 807682

Install the Oracle client on Ubuntu There are a lot of graphical tools on the Ubuntu Desktop to connect to the Oracle database, such as DBeaver, but sometimes you still need to connect to the remote database through sqlplus, then you need to install

MySQL Cluster in a MySQL Cluster1. References 2. Introduction MySQL-Cluster is a technology that allows you to deploy "in memory" database clusters in a non-shared system. Without a shared architecture, the system can use cheap hardware without

MongoDB update document Update () method The update () method is used to update an existing document. The syntax format is as follows: db.collection.update( , , { upsert: , multi: , writeConcern: }) Parameter description:

PostgreSQL9.5 new features-row-level security and application-level solutions PostgreSQL 9.5 introduces the row-level security policy feature (RLS), which provides fine-grained control beyond the traditional authorization security system in the data

Compare the date difference between MySQL and Oracle by using a create statement Today, a developer submitted an SQL change and found a problem during deployment.A statement is a simple create statement.Create table 'test _ user '('Openid' varchar (6

Tutorial on installing PostgreSQL on Mac OS, ospostgresql Let me start with it. For a long time, I have been cooperating with MySQL, a long-tested old friend. However, after learning a little about PostgreSQL, I have been fascinated by its rich

Build a MYSQL master-slave replication structure and a mysql master-slave replication Structure 1. Select two servers as the master and backup databases respectively. 2. log on to the server, Yum install mysql; Yum install mysql-server; 3. Start the

How Does oracle obtain the SQL Execution Plan of the client to optimize the SQL statement? Today is September 25,. I continue to learn about SQL optimization and have written two notes on how to obtain the SQL Execution Plan. Although the notes are

EXP is very different from the previous 10G and 9I versions when exporting a database of 11G, that is, tables without data will not allocate space. Since Oracle 11.2.0.1, Oracle provides a new space allocation method: when creating a non-partition

For the UI Layer of an application that focuses on data processing, we often need to write a considerable amount of code to bind data. If some agreed ing relationships are stored between controls on the interface and entity types as data sources, we

In fact, the indexes in MongoDB are similar to relational databases. They are designed to improve the efficiency of query and sorting, and the Implementation Principles are basically the same. The keys (fields) in the set can be common data types or

Author's note Because of living money), it has been almost half a year since I switched to work as an electronic product for Apple accessories. After the transfer, my income has indeed increased a lot and my life has indeed benefited a lot, however,

Editor's note: Is DataReader or DataSet used? First, you need to know the similarities and differences between them and the applicable working environment. After learning about this information, you can easily solve the problem when to use it. The

In the previous article "differences between read in the current mode and consistent read", I used two special examples to describe the differences between read in the current mode and consistent read, it also mentions that "if the corresponding

In the second article in the SQL Server series, I have mentioned that I want to write historical data. The history here mainly describes the historical data of the database and the SQL Server itself. To be honest, this part of content should be

This document assumes that you have the permission to back up the database. That is to say, you are either a system administrator, db_owner, or backupadministrator. In addition, we also assume that your operating system provides the right to access

To improve the development efficiency, the company's development uses a large number of LINQ To SQL for development. Here we will share with you the problems encountered in the project. (That is, the problem of connecting to the conditional query

I. Control File multiplexing features The principle of multiplexing is actually very simple, that is, the control file is stored in multiple disk partitions or multiple hard disks on the database server. When the database system needs to update the