Database Administrator

MySQL database startup and Shutdown MySQL database server usually refers to mysqld, while command line mysql is a mysql client program. These two concepts are often confusing. Generally, the mysql server is started to start the mysqld process. After

Install and test Redis in CentOS 6.5 Install and test apsaradb for Redis-CentOS 6.5 using NoSQL 1. Download redis You can install or download redis online. ① Check whether the rpm package does not exist before online installation. If you check

Detailed operation process of MySQL master/Master Synchronization This document is recorded when MySQL dual-master is deployed online at the company. For security purposes, IP addresses are changed to intranet IP addresses. Version: # Mysql-V Mysql

Obtain Oracle implicit parameter information The Oracle Database initialization parameters mainly come from two internal Oracle Data Dictionary tables: X $ KSPPCV and X $ KSPPI usually the V $ Parameter view we query or the show parameter command

MySQL disable generating Log File mysql-bin.000001 In a MySQL database, mysql-bin.000001, mysql-bin.20.02 files are database operation logs, such as UPDATE a table, or DELETE some data, even if the statement does not match the data, this command

Path Problems in MySQL 5.5 Below are the parameters of my. ini in MySQL 5.5. Basedir = "C:/Program Files/MySQL Server 6.0 /" Datadir = "" path for storing the table structure Innodb_data_home_dir = "" This is the path for storing table data,

The execution sequence of ROWNUM and order by in Oracle Database When SQL is used to query Oracle table data, the following two results may be required. Sorts the query result set and obtains the row number before sorting. After sorting the result

Common Methods for adding GoldenGate extraction processes The OGG configuration is very flexible. Each component has multiple configuration methods and can be prepared as needed. The following lists several common ways to add extraction processes.

An error occurred while recovering the RMAN Database Problem: This is an operation to restore the RAMN backup of a database in the RAC environment to a single database. The following error is reported when the data file is restored and the recovery

How to install MariaDB10.0.X in the latest version in Linux 1. Linux installation environment CentOS7-64 bit, latest version: MariaDB10.0.14 2. Linux terminal command line Create a file: vim/etc/yum. repos. d/MariaDB. repo File Content: #

Validate command-RMAN for backup and recovery Verification As an Oracle backup and recovery tool, RMAN provides us with powerful functions, including physical and logical detection of data files and validity detection of backup files. First, let's

MySQL deletes anonymous users to ensure login security Many MySQL programs use the anonymous logon function. After installing MySQL, you can log on to the database. This is basically nothing for MySQL, but this login method is definitely not

MySQL user addition Error How to solve the problem when adding a user to MySQL For example, add a user Insert into mysql. user (Host, User, Password) values ("localhost", "test", password ("1234 ")); Error: ERROR 1364 (HY000): Field 'ssl _

MySQL searches for field names through field annotations Sometimes there are too many fields in the MySQL table, just remember the table comment. To search for the field name through the field comment, you can use the following statement: SELECT

CentOS6.x upgrade MySQL 5.1 to 5.6 Some virtual machines and cloud host providers still use the old version of the installation suite. The pre-installed application software version is very low. Some IDCs use ECs instances. The pre-installed MySQL

Set the size of the Shared Pool in Oracle In Oracle 10g or 11G version, how to properly set the shared pool size has a great impact on the performance of Oracle databases. The size setting rules of the Shared Pool are as follows: 1. Check the

Basic mysql knowledge, mysql1. Why use the database:(1) reducing storage data redundancy(2) Higher Data Consistency(3) storage data can be shared(4) standards that can be followed by Databases(5) easy to maintain data integrity(6) Data Security2. In

Database Row Operations (2), Database Row Operations Continued: You can arrange it FOR not only UPDATE, but also an UPDATE flag. For example: To update a TABLE, the field ID is the primary key. Then A performs the following operations: Select

Oracle-function exercise, oracle-function /** Scm_iss.test_imti_fun2 * Function with input parameters */create or replace function TEST_IMTI_FUN2 (P_NO in number) RETURN VARCHAR2 IS P_IMTI_NAME VARCHAR2 (200); P_IMTI_DESC VARCHAR2 (200 ); p_RETURN

If the RMAN database fails to be restored, the RMAN database fails to be restored. Problem: This is an operation to restore the RAMN backup of a database in the RAC environment to a single database. The following error is reported when the data