Database Administrator

Importance of indexes in mysql connection queries In mysql, connection queries are often used to read data from multiple tables. Connection query uses the fields in the two tables that match the connection relationship to establish the association

Performance Comparison of Redis and MongoDB paging/ranking at large offset, redismongodb In fact, the questions are not very accurate, because the database does not provide paging, ranking, and other functions. It only provides data access, and

Go to Oracle server connection and switch to oracle Server1. Two Connection Methods for the Oracle server Oracle database connections can be divided into two categories based on whether the client and server are running on the same machine. One is

[MongoDB] MapReduce programming model of MongoDB database, mongodbmapreduce When I first read the Mongodb getting started manual, I saw mapreduce. It was so difficult that I ignored it directly. Now, when I see this part of knowledge again, I am

How to connect Oracle 12c to CDB and PDB, 12 ccdb      1 connect to CDB   Same as a normal instance. After specifying ORACLE_SID, you can use OS authentication or password for connection.   [Oracle @ Ora12c/] $ echo $ ORACLE_SID Cndba [Oracle @

You cannot recover data with mysqlbinlog. Today, a new project was deployed locally, and the tables in another database were accidentally deleted. At that time, I did not find any hard disk recovery tools, I had to find another method. Fortunately,

MySQL root User forgot password solution (security mode, password modification methods), mysqlroot 1. Disable running MySQL2. Run the following command to start the Security Mode of MySQL: mysqld --skip-grant-tables Or mysqld-nd --skip-grant-tables

Summary of several balancing trees and summary of several balancing trees1. Introduction to 2-3-4 trees2-3-4 is a multiway tree. Each node has a maximum of four subnodes and three data items, the tree 2-3-4 can be regarded as the B tree with the

Work Summary: mysql uses strings as query conditions, mysql query Conditions Preface: I encountered a problem during mysql query today. The scenario is like this. Assume that one of my tables has a field scode (indicating the product number ), then

Oracle AVDF installation, Next: Introduction to Oracle audit and database firewall (AVDF) 1. Oracle AVDF installation and configuration Oracle AuditVault and Database Firewall installation is a little troublesome and requires high hardware

Configure Mysql to allow remote access in Linux. The procedure is very simple. The procedure is as follows: 1. Go to mysql: /Usr/local/mysql/bin/mysql-u root-p 2. Use the mysql database: Use mysql; 3. view the user table: SELECT

Kettle tool User Guide, kettle tool use You can directly use kettle.zip to run Spoon. bat.   Ii. Conversion example: Data Conversion between databases A) create a new conversion db to db. ktl B) Create a database connection I. Click the main object

SQLSTATE58030, sqlstate28000 An execution error occurred while optimizing an SQL statement. gtlions=# select t1.telnumber,t2.ua,t2.url,t1.apply_name,t2.apply_name from tb1 t1 gtlions-# left outer join tb2 t2 on t1.sid = t2.ipsid gtlions-# where t1.

[Practice] The sphsf-index merging script is used to implement the sphsf-index. Mkdir/usr/local/sphscripts/scripts ---- 0. Create all primary indexes #! /Bin/bash # ocpyang@126.com # main_index_update.sh/usr/local/sphinx/bin/indexer src2-c/usr/local/

Shell batch import mysql database, shellmysql Database Due to project collaborative development, my colleague sent an SQL file of the project and opened it in a directory containing hundreds of databases. Each database is used as a separate

The SQL view obtains one field based on the where condition. First, we will introduce the usage of Case... When... Then... End: CASEJiXiaoFind_RowID WHEN '1' THENJiXiao_Money1WHEN '2' THEN JiXiao_Money2WHEN '3' THEN JiXiao_Money3WHEN '4' THEN

In Linux, MySQL forgets the root password 1.1 and mysqlroot.1. First confirm that the server is in a secure state, that is, no one can connect to the MySQL database at will.Because, during the resetting of the MySQL root Password, the MySQL database

Generate multiple ADDM reports and oracleaddm reports in OracleI have written an article in Oracle to generate AWR reports in batches. We used to monitor AWR reports every day to eliminate performance risks in a timely manner. Now there is another

Haproxy + mysql cluster (MySQL cluster) configuration, haproxycluster I. Preparation 1. Prepare the server Establish a MySQL CLuster system with two nodes and build a Haproxy + mysql cluster (MySQL CLuster) system with six servers Node

Object-oriented features In UML, I learned about object-oriented, so I have a preliminary understanding of object-oriented, which lays a good foundation for a more convenient understanding of object-oriented in the future. Abstract, encapsulation,