Database Administrator

MySQL binary log recovery data error: @ GLOBAL. GTID_MODE = OFF. When MySQL Recovers Data using binary logs, the following ERROR occurs: ERROR 1781 (HY000) at line 16: @ SESSION. GTID_NEXT cannot be set to UUID: NUMBER when @ GLOBAL. GTID_MODE = OFF.

How to unlock accounts in Oracle databases When creating an Oracle database, SYS logs on to the Oracle database and unlocks it using the SQL * Plus tool as follows. 1. Use the data dictionary dba_users to check the locking status of the Oracle

Description of synchronization parameters for different databases and tables in MySQL master-slave Replication Description of synchronization parameters for different databases and tables in MySQL master-slave Replication In replication, the

Connection failure due to Redis high concurrency When ELK collected logs today, it found that the collection failed, looked for various reasons, and finally found an error in the redis log:[2, 2489] 02 Jun 10:43:42 # Error allocating resoures for

MySQL 5.6.x multi-instance ConfigurationPrerequisites For testing, the installation is in binary mode, which is simple, convenient, and fast.MySQL-5.6.x binary version installation record I do not like to configure multiple instances in mysqlmulti

Redis High Availability Redis Sentinel1. Redis master-slave configuration 1.1. Set master-slave Replication Master 10.24.6.5: 6379    1.2. Cancel master-slave Replication    1.3. Delete all data Flushdb: Delete the database.Flushall: delete all  2.

In-depth analysis of MySQL logon principles The first step in using the MySQL database is to establish a connection and log on, and then execute the SQL command above. Whether it is through the MySQL client, or through the C-API, JDBC standard

Asm creates and deletes disks, disk groups, and rebalance operations, and asmrebalance [grid@lzl1 ~]$ sqlplus / as sysasmSQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 20 15:20:44 2017Copyright (c) 1982, 2011, Oracle. All rights

In-depth understanding of the underlying implementation of MySQL This article comes fromGitChatFor more information, see "understanding the underlying implementation of MySQL" and "read the original article. 「 High energy at the end of the

Examples of the Mybatis paging plug-in are described in detail. Examples of Mybatis paging plug-ins 1. Preface: We know that in MySQL, paging SQL is implemented using limit. If we write SQL by ourselves, there is certainly no problem with paging.

MyBatis is used to obtain the auto-generated primary key Id and instance code. MyBatis obtains the auto-generated primary key Id and instance code. When using a MySQL database, we generally use the auto-incrementing primary key of the database to

Mybatis calls the PostgreSQL stored procedure to implement array input parameter transfer. mybatispostgresql Preface Mybatis is used in the project to call operations related to the PostgreSQL Stored Procedure (custom function). Because PostgreSQL

Method 1: Use the DBCA graphical interface. Method 2: run the following command: Three commands:SYS @ bys1> startup mount exclusive ORACLE instance started. Total System Global Area 631914496 bytes Fixed Size 1338364 bytes Variable Size 26424

Today, I used the attach function of SQL Server 2008 to attach a database. A problem occurred. The error message is: Unable to open physical file "D:\Documents\Dalt\XXXX.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: 

We can include the entire package in SSIS in a transaction. But what if a table needs to be locked during package execution? The built-in transaction processing of SSIS can solve this problem. Before that, familiarize yourself with the concept of

Today, I occasionally see the with keyword in SQL. I have been writing SQL statements for a few years, so I was the first to get in touch with it. After reading an article by a blogger, I added some content and made a simple summary. This statement

The database history can be traced back to fifty years ago, when data management was very simple. Data is processed by a large number of classification, comparison, and table-drawn machines running millions of punched cards. The running results are

When you roll back a long-running transaction in Oracle Database 10g-whether it is a parallel instance to restore the session or a rollback statement executed by the user-all you need to do is to view the view V $ SESSION_LONGOPS evaluate the time

BKJIA: If you use IBM DB2 for z/OS, DB2 for Linux, UNIX, and Windows (LUW), there is no problem. Let's review when to use XML storage, and some best practices for customizing XML storage! For an image description, I will use an XML document with the

I used to mix dba and sysdba. Today I am discussing the differences between them in the Forum. The special record is as follows:   SYSDBA is not a permission. When a user logs on to the database as SYSDBA, the user will become SYS. You can log on