Database Administrator

Add a new service to InfluxDB in CentOS7.3 Operating System: CentOS7.3.1611 _ x64 Go language version: 1.8.3 linux/amd64 InfluxDB version: 1.1.0 Here, we use the syncd service as an example to record the process of adding a new service to

Understanding the undo logs, redo logs, and checkpoints in the database This document describes a database file that stores data. The database content is cached in the memory. The name is db buffer. In an operation, we retrieve the data in a table

Python 3 using PyMySQL to connect to Inception When using PyMySQL to connect to the Inception, a value error occurs when determining the version. The reason is that pymysql is separated by '.', but the version information of Inception

Bind a variable of DATE type in SQL * Plus SQL * Plus is an essential tool for DBAs. According to TK, "DBAs that do not use SQL * Plus are not qualified DBAs ." Of course, this is not the case, but it is similar to this. We can see the importance of

How Does Oracle export system tables under sys users? Environment: Solaris 10 + Oracle 10.2.0.4 1. Export instances 2. References Reference 1. Export instances ExportHIST_HEAD$AndWRI$_OPTSTAT_HISTHEAD_HISTORYTwo tables:An error occurred while

MySQL Binary Package update MySQL 5.7 With mysql_upgrade MySQL is usually deployed using binary packages. Therefore, when you upgrade MySQL, You can decompress the latest MySQL package to basedir, of course, if MySQL does not have any data, you can

Use RMAN Incremental backup to update the transmitted tablespace To use RMAN Incremental backup to update the transmitted tablespace, you need to understand the Incremental backup of the transmitted tablespace and RMAN. Here we will mainly introduce

Implementation of the REVERSE function in DB2 Some guys asked DB2 if there were any built-in reverse functions in the group. I tested that DB2 does have built-in functions, but Oracle and SQL server both have built-in functions. Let's take a

Use pg_basebackup to build a PostgreSQL stream replication Environment This article introduces the high availability of PostgreSQL. Here we will first conduct a stream replication experiment. Environment:OS: [Ha @ node0 ~] $ Uname-Linux node0 2.6.32-

The size of Oracle archived logs is much smaller than that of online logs. Some users may be confused about the size of archived logs smaller than those of online logs:First, check whether your archive log files are compressed:SELECT to_char

Node. js nano library to process couchdb: timeout required I want to use the nano library. I used db. search/db. get/db. destroy/db. insert, but there is no way to add timeout. Many async functions can pass the callback as a parameter. I don't want

Use the AWK tool in Cygwin to view mysql binlog logs Linux tools are really powerful. However, as a person who does not have the right to use Linux machines or who does not use Linux for development, it is really inconvenient to use some commands, a

Install mysql on mac and mysql on mac Install mysql and check1. Download the dmg installation package from the mysql website2. After the download is complete, double-click the installation package and click Next step. The default setting is standard

Practical tutorial for importing data from sqlite3 to mysql, sqlite3mysql Preface Sqlite3 is small and lightweight, but does not support concurrent access. When the website concurrency is large, the database Request queue is long, which may cause

[Reference The Source: http://blog.csdn.net/bhq2010/article/details/12200533] The vs debugging pg source code used in the pg kernel source code parsing class. VS is easy to use, but it is a little troublesome to configure the debugging environment.

Editor's note: q a: Where did the experience come from? Answer: experience comes from practice and from some notes in life. Learn to sum up, learn to pay attention, learn to discover... you can also be reborn, jumping off the sublimation...

SQL Azure database is a cloud-based relational database service provided by Microsoft. Cloud-based data solutions provide many benefits, including fast provisioning, more economical scalability, high availability, and reduced management costs. This

Different enterprises may have different Personalized Requirements for databases. Such as the date display format. To meet the requirements of different enterprises in this regard, the concept of server variables is put forward in the MySQL database.

Editor's note: the goal of database optimization is to avoid disk I/O bottlenecks, reduce CPU utilization, and reduce resource competition. However, you must be careful not to optimize it blindly. Related Articles: Database optimization design

A butterfly in the South American jungle flags wings and may cause heavy snow in Moscow, indicating the complexity of the atmospheric system. However, DBAs often face similar problems in their daily work. We analyze the symptoms of faults to solve