Database Administrator

How to configure MariaDB replication in CentOS Linux This is a process of creating duplicate database versions. The replication process not only copies a database, but also synchronizes changes from the master node to a slave node. But this does not

Install PostgreSQL 9.4 in Linux Notes on how to install PostgreSQL 9.4 in Linux. I. Preface PostgreSQL, also known as Postgres, is a relational database management system applicable to various Linux operating systems, Windows, Solaris, BSD, and Mac

System-level alias vs Oracle ADR Functions The new feature ADR launched by Oracle in 11 GB, that is, Automatic Diagnostic RepositoryMy personal understanding is that this tool can efficiently manage some log files. For example, to view the Database

Relationship between innodb table level lock and lock table statement, innodbtable DDL statements only apply for intention-Level Table locks. In the lock table statement, mysql applies for mysql-Level table locks, and innodb also applies for innodb-

Restructuring the data room charging system-database design and data room Charging System Finally, we reached the stage of restructuring the data center charging system ...... I used the database of the charging system of the data center for the

Question 5: What does MySQL ---------- Consecutive Numbers and numbers mean? Write a SQL query to find all numbers that appear at least three times consecutively. + ---- + ----- + | Id | Num | + ---- + ----- + | 1 | 1 | 2 | 1 | 3 | 1 | 4 | 2 | 5

Create split and splitstr functions in Oracle, splitsplitstr It is recommended that SQL statements be created in sequence. /*************************************** Name: split * author: sean zhang. * date: 2012-09-03. * function: returns the table

Mysql paging negative SQL attack, mysql paging SQL1. Attack Analysis CleverCode's O & M colleague told me that when he checked the mysql error log, he found a large number of errors, so someone was attacking a specific address. This error occurs

Innodb independent tablespace configuration, innodb independent tableInnodb independent tablespace ConfigurationEnvironment Introduction:MySQL version: 5.5.401. Check whether the independent tablespace is enabled.Mysql> show variables like '%

Redis installation error: jemalloc/jemalloc. h: No such file or directory solution, redisjemallocError description When installing Redis 2.8.18, an error is reported: zmalloc.h:50:31: error: jemalloc/jemalloc.h: No such file or directoryzmalloc.h:5

MySQL DATE_FORMAT () function, mysqldate_formatDefinition and usage The DATE_FORMAT () function is used to display date/time data in different formats.Syntax DATE_FORMAT(date,format) DateThe parameter is a valid date.FormatSpecifies the output

Oracle FORALL usage (batch addition, deletion, and modification), oracleforall A key improvement of FORALL statements, which greatly simplifies code and significantly improves performance for programs that want to update many rows of data in PL/SQL

Mysql deadlock occurs when the disk is full. Today, I encountered a problem because the disk of the machine where mysql is located is full, leading to a mysql deadlock and not even querying the select statement. If I did not read the mysql Log, I

Understanding MySQL-index and optimization, understanding mysql Indexes Preface: indexes have a crucial impact on the query speed. Understanding indexes is also the starting point for optimizing database performance. Consider the following: Assume

PowerDesigner15.1 tips 4, powerdesigner15.1 PowerDesigner15.1 tips 4Read first PowerDesigner15.1 tips (1)PowerDesigner15.1 tips (2)-how to find official resourcesPowerDesigner defines cdm, ldm, and pdmThe data structure of a table is represented by

A binary tree for DS Traversal In some applications of Binary Trees, it is often required to search for nodes with certain features in the tree, or to process all nodes in the tree one by one. This raises the issue of traversing a binary tree, that

Paging performance exploration-mysql, paging exploration-mysql Paging technology is very common in development. I used paging technology for the two projects I just joined the company, so I thought about in-depth exploration of paging

PostgreSQL contains PM/AM Time Format Conversion to_timestamp, postgresql PostgreSQL help documentation 9.8. Data Type Formatting FunctionsThe specified sqlformatting functionsprovide a powerful set of tools for converting various data types

Database and database LearningSerializability of concurrent Scheduling DBMS may produce different results for different scheduling (schedule) of concurrent transactions.What kind of scheduling is correct? Serial scheduling is correct.For serial

Differences between Having and Where, and HavingWhere 1. The where clause is used to remove rows that do not meet the where condition before grouping query results. That is, data is filtered before grouping. The where condition cannot contain