Database Administrator

InnoDB two-phase log Submission mechanism ViewThe innodb_flush_log_at_trx_commit official website has some questions.For more information about the innodb_flush_log_at_trx_commit parameter, see the official website.One of them is written as follows:

How to install Oracle 11gR2 in Ubuntu 16.04Overview Ubuntu: ubuntu-16.04.3-desktop-amd64 Oracle: linux. x64_11gR2_database ------------------------------------------ Split line ------------------------------------------ Related File Download

Docker practice: mysql Master/Slave backup read/write splitting, dockermysql 1) download the msql Image File docker pull mysql/mysql-server You can also specify the mysql version. docker pull mysql/mysql-server:5.7 View image filesDocker images 2)

Detailed description of redis self-starting configuration and redis STARTUP configuration I. Overview 1.1 Principles How does redis auto-start work? After the Linux system is started, a program will scan files under a specific directory and execute

The WEB project on the server repeatedly fails to connect to the MySQL database. One reason is that the scheduled task plan for MySQL is not closed. MySQL runs an automatically updated scheduled task plan by default every morning. If the

Commonly used sQlite statements and the use and registration of sQlite developer, sqlitedeveloper Preface SQlite is a lightweight database commonly used in development. Generally, it only occupies several hundred KB of memory space. Therefore, in

Comparison between MySQL and Oracle: Function 3: mysqloracle Function No. Category ORACLE MYSQL Note 1 Numeric Functions Round (1.23456, 4) Round (1.23456, 4) Same:ORACLE: select round (1.23456

REVER-----54321 SQL> select reverse ('oracle ') from dual;REVERS------ElcarO SQL> select reverse ('test') from dual;REVE----???? NAME TYPE VALUE-----------------------------------------------------------------------------Nls_language string

I didn't want to write such a simple article. I searched for my title on Baidu, which is totally in line with the title. However, I have been following these articles for a long time, but I cannot. My environment: MySQL: mysql-essential-5.1.51-win32

The export/import mechanism provided by HBase can implement the Backup Restore function. In addition, Incremental Backup can be implemented. The following python script sets up Incremental backup. In this script, Incremental backup is performed

However, for those who have been using MySQL for a long time and are familiar with the MySQL ecosystem, changing MySQL is not so urgent. After all, it is not until the end of the day. However, it is time to come. Before Gentoo portage, the MySQL 5.5

It is said that MongoDB is slow. Objection: If no unique index is set, tens of thousands are inserted per second on a common office computer with only _ id, and tens of thousands are inserted per second on a common x86 server, what do you mean is

In Oracle databases, segments are often used to store all data of specific logical objects. For example, when a database table or index is created, Oracle will allocate storage space for these objects to store the information they need. Segments are

During the installation process, you can upgrade the existing instance of Analysis Services to migrate the existing Analysis Services database, or run the migration wizard after installation. This topic describes how to use the migration Wizard to

MySQL supports unidirectional and asynchronous replication. One server acts as the master server during the replication process, and one or more other servers act as slave servers. The master server writes updates to the binary log file and

I. SGA 1. Shared pool tunning The Optimization of the Shared pool should be given priority, because a cache miss occurs in the shared pool, which is more costly than the data buffer, because the dictionary data is generally longer than the data

This article describes some Oracle database migration techniques, including preparations before Oracle database migration and solutions for different types of migration. We hope to help you understand Oracle database migration. BKJIA database

This article discusses how to improve the performance of SQL Server databases. BKJIA database channel recommends "getting started with SQL Server" to help you better understand SQL Server databases. 1. SQL Server System database Introduction SQL

I. Purpose Previously, in the blog post SQL Server database minimal downtime migration solution, we mentioned that the full backup + differential backup feature has been used to complete database transfer, however, this method is obviously not

I. Usage of autonomous transactions Audit that cannot be rolled back: Generally, when a trigger is used to prohibit operations such as table updates, if logs are recorded, the trigger will cause log rollback when an exception is thrown. Autonomous