PHP

This article introduces the InnoDB Index-related knowledge of MySQL, from various trees to the indexing principle to the details of storage. InnoDB is the default storage engine of MySQL (MyISAM before MySQL5.5.5, This article introduces the InnoDB

Install MySQL in Linux, usually by using RPM and source code. For the production environment, you need to customize the installation path, data file location, Character Set, and supported Install MySQL in Linux, usually by using RPM and source code.

Oracle flash back data archiving can be used to automatically track and archive data in tables with flash back data archiving enabled. This ensures that the flash query can obtain the SQ of the database object version. Oracle flash back data

This document describes how to create an Oracle database that complies with the OFA specification using the createdatabase command of the Oracle database. This document describes how to create an Oracle database that complies with the OFA

Today Oracle Database suddenly cannot connect, reported ORA-00257 error (insufficient space error), by looking for information, the vast majority of said this is because the Archivelog archiving log too much, accounting Today Oracle Database

In this article, we will introduce the Starting sequence of 11gR2GI and introduce common problems and corresponding solutions during GI startup. In this article, we will introduce the Starting sequence of 11gR2GI and introduce common problems and

1. In the experiment environment, I used three servers to build the mysqlcluster environment. The SQL node and data node are on the same server, and the Management node is a separate one. clusternode1: 192.168.1 1. In the experiment environment, I

Statspack is a product of the Oracle9i era. It has a cross-milestone significance for monitoring and analyzing database performance and is the predecessor of AWR. After Oracle10g, AWR replaces statspac Statspack is a product of the Oracle 9i era. It

The query performance of MySQL5.7.4 is greatly improved, doubled from MySQL5.6, and reaches 512000 read-only QPS per second on the test platform. The maximum query performance of MySQL5.6 is MySQL 5.7.4 significantly improves query performance,

In general, we choose to install Oracle databases in traditional server operating systems such as Linux and AIX. Even in a Windows environment In general, we choose to install Oracle databases in traditional server operating systems such as Linux

The main function of the MySQL permission system is to verify the user connected to a given host and grant the user the related DML and DQL permissions on the database. MySQL Access Control has two levels The main function of the MySQL permission

After restarting the RAC server, we found: rac1-gt; crs_stat-tNameTypeTargetStateHost ---------- After restarting the RAC server, we found: rac1-gt; crs_stat-tName Type Target State Host ---------- Homepage → Database

SPFILE is a binary file automatically maintained by the Oralce server process. This file cannot be manually modified. Once it is manually modified, it becomes invalid. On UNIX, the default bit of this file SPFILE is a binary file automatically

Today to do Linux under the DG configuration, encountered a phenomenon, tnsname. ora file configuration are normal, tnsping is also normal, listening is also normal, but still reported ORA-12514 error: Today to do Linux under the DG configuration,

A ORA-12516 error occurs when you use swingbench to perform a stress test on the oracle database. This error is generally reported because the number of oracle sessions exceeds the limit. A ORA-12516 error occurs when you use swingbench to perform a

MySQL upgrade is very necessary. We listed various questions about MySQL upgrade best practices on PerconaSupport. This article recommends upgrading MySQ in some different situations. MySQL upgrade is necessary. We listed various questions about

I wanted to learn about mybatis a long time ago. It is said that many companies use this framework. In the past, I used DBCP, Which is outdated. Hibernate feels too big. Now I want to learn this neutral framework. I wanted to learn about mybatis a

After the Oracle11gR2GridInfrastructure and Database software are installed, the following error is reported when DBCA is executed to create a Database to 30%. Click OK and the system prompts to ignore and After Oracle 11gR2 GridInfrastructure and

Automatic undo Management (AUM) requires almost no configuration. Basically, you only need to define the time needed to keep the previous image available. This is through Parameters Automatic undo Management (AUM) requires almost no configuration.

Use the EXPIMP derivative tool to set the client character set. The client character set is completed by setting NLS_LANG (language_territory.clientscharacterset ). Note the setting of the client character set when using the EXP/IMP derivative tool.