Database Administrator

Oracle DBLink creation and maintenance and ORA-02085 Solutions Today's business needs to query Oracle data across databases, so we thought of dblink. Let's take a closer look at Oracle DBLink. First, Oracle DBLink is divided into the following three

How to install Percona Server on CentOS 7 In this article, we will learn about the Percona server, an open-source MySQL and MariaDB alternative. The InnoDB database engine makes the Percona server very attractive. If you need a high-performance,

How to rename a MySQL database [Preface] One of the databases needs to be backed up for business needs, and then imported into a brand new database; it is the fastest and easiest way to directly modify the name of the current database for backup.

Python3.4 connect to MySQL using PyMySQL Since the release of Python3, it has received negative comments from a large number of programmers, saying that it is unstable and incompatible. However, the negative comments are negative comments. Since

MySQL Order By Principle and Optimization 1 IntroductionFor business (MySQL) DBAs or business developers, order by is a common business function that sorts the results based on specified fields to meet front-end display requirements. However,

MariaDB command introduction and MariaDB architecture and Index Mariadb> show global variables; global variables affect GLOBAL operations on the server. Mariadb> SHOW [SESSION] VARIABLES; client variable, effective only for the current SESSION Note:

Oracle sets a scheduled task JOB to schedule and execute stored procedures or PL/SQL code blocks Currently, there are two methods for configuring scheduled job Scheduling in Oracle Database: dbms_scheduler to create job scheduling and dbms_job to

Use MongoDB C # official driver to operate MongoDB To use MongoDB in C #, you must first have a C # drive supported by MongoDB. C # has many types of drivers, such as samus. Most of the Implementation ideas are similar. Here we first use the

Simple configuration and application of Mybatis-plus and mybatis-plus Mybatis-plus is an enhanced version of mybatis, which is written by the Chinese gods and can automatically generate code.The configuration process is simple. First introduce two

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

Mybatis FAQ and mybatis FAQ1. Mybatis basics: # {...} and $ {...}MyBatis will #{...} It is interpreted as a parameter mark of JDBC prepared statement. And $ {...} Interpreted as string replacement. It is useful to understand the differences between

Make a little progress every day-mysql -- Percona XtraBackup (innobackupex), perconaxtrabackupI. Introduction Percona XtraBackup is an open-source and free MySQL Database Hot Backup Software. It can back up InnoDB and XtraDB storage engine databases

Some changes need to be made when Oracle Client 10g is installed on Windows 7, oracle10g The new notebook, Windows 7 Pro, needs to install the Oracle Client, the colleague gave a 10G version. Prompt during installation: "Checking operating system

HBase learning Summary (4): How HBase works and how hbase works I. Split and allocate large tables HBase tables are composed of rows and columns. HBase tables may contain billions of rows and millions of columns. The size of each table may reach TB

Operation 3: Enable slow query logs for mongodb and mysql, start mongodb from the configuration file, and enable mongodbmysql 1. Start mongodb from the configuration file Create a configuration file:/usr/local/mongodb/etc/mongodb. conf The

Oracle442 application scenarios --------- basic PL/SQL, basic plsql tutorial Bytes -----------------------------------------------------------------------------------The Application Scenario 207---231 is skipped after the backup and restoration of

MEAN framework learning notes, mean learning notesMEAN framework learning notes There is very little information about the MEAN development framework. The main information is from the introduction on the learn. mean. io website. Therefore, with a

PL/SQL smart call stack analysis, plsql PL/SQL smart call stack AnalysisOriginal article: http://www.oracle.com/technetwork/issue-archive/2014/14-jan/o14plsql-2045346.html The three DBMS_UTILITY functions(DBMS_UTILITY.FORMAT_CALL_STACK,

The database updates multiple records with different values, updates multiple fields at the same time, and updates multiple records Requirement The following two tables are student (student table) and score (test student table) Statistics: total

Oracle442 application scenarios ---------- database instances and access Database Application Instances The Application Scenario 1-7 is the installation process of Oracle. Here, I will explain a lot about it. There are a lot of materials on the