Database Administrator

MySQL stored procedures and triggers I. Stored Procedure The basic format of the stored procedure is as follows: -- Declare the Terminator-- Create a stored procedureDELIMITER $ -- declare the end of the stored procedureCreate procedure pro_test () -

MySQL database Chinese garbled Problem Solution After migrating a set of internal systems (confluence), the page is opened and all the question marks are garbled. Cause analysis: Create a database as follows: Mysql> create database confluence

Keyword conflict between MySQL data cannot be written Problem description: a new table is created using MySQL today. A syntax error is reported during data insertion. Because the mabits Automatic code generation tool is used, and the SQL statements

MySQL dual-master Configuration MySQL dual-master Configuration Prepare the environment: the server operating system is RHEL6.4 x86_64, to minimize installation. Both host A and host B disable the firewall and SELINUX. The IP addresses are 192.168.13

Automatically add partitions for Oracle user tables This program can be executed as an Oracle JOB before the 28 th day of every month (taking into account the reason for the day of May 1), automatically adding partitions to the partition table of

PostgreSQL uses C to complete Stored Procedure instances I recently wrote an example of a stored procedure written by PostgreSQL in C, which is recorded here. Objective: To use C to complete a stored procedure example. A stored procedure can update

Oracle tracks common internal event numbers Oracle internal event numbers are often used to track the system status. How to use these internal event numbers requires events and experience. Only these commonly used internal event numbers are recorded

DataGuard bug in adding temporary data files One environment is Oracle 10gR2, with one master node and two slave nodes. Because the 10 Gb slave database is not active, we will open the corresponding window time when there are some query requirements.

MySQL5.7 implement expression indexes for virtual Columns MySQL has not provided such complex functions as function indexing since ancient times. So how can this function be implemented in MySQL? Let's take a look at the concept of function indexing.

Impact of MongoDB planned Cache After creating an index for Primary in the MongoDB 2.6 replica set, it is found that the Secondary query does not follow the latest index. It is normal after the plan cache of the set is cleared temporarily. I have

Oracle 12c R2 new feature dbca command can create standby Database Since version 12c R2, the dbca command provides the syntax for creating the standby slave database: Syntax: Dbca-silent-plain-gdbName BOS.domain.com-sid BOS1-sysPassword

Oracle 12c new feature crsctl provides preview confirmation when stopping Resources In the Oracle 12c database version, crsctl provides the preview confirmation function when stopping related resources, but this function is not available in earlier

RedHat Linux 6.4 install Oracle 10g error Environment:Operating System: RedHat6.4 64-bitDatabase Version: 10.2.0.4 64-bitTest reason: Note: Install 10.2.0.1 64-bit on redhat6.4 and then upgrade to 10.2.0.4 64-bit. The following error is reported

MySQL multi-master and One-slave Synchronization Test preparation: host A and host B are the primary IP addresses 192.168.131.129 and 192.168.131.130, and host C is the slave server. Configure MySQL multi-instance on the slave server with the IP

Install Oracle 11gR2 in CentOS 6.6 Install Oracle 11gR2 in CentOS 6.6 I. Hardware requirements 1) The minimum memory size is 1 GB, preferably 2 GB or more. The memory here is 10 GB. 2) The official suggestions for swap partition size are as follows.

Filter MySQL slow query logs using commands An exception occurred on a web server.All requests are blocked due to CPU depletion, which may take 5 to 10 minutes. During this period, the overall database load is normal. Use the command to query slow

PostgreSQL exports table structure information The project uses a Postgresql database. The project team needs to write a table structure document, which is too troublesome. I want to use the slq script to export a document. I checked some

Processing When the Oracle tablespace is too large First, view the data usage of all Oracle tablespaces. SELECT Upper (F. TABLESPACE_NAME) "tablespace name", D. TOT_GROOTTE_MB "tablespace size (M)", D. TOT_GROOTTE_MB-F. TOTAL_BYTES "used space (M)",

RHEL6.4 install MySQL 5.6.27 RHEL6.4 install MySQL 5.6.27 Download (temporary address. If not available, please download it from the Oracle website) Use rpm to install mysql Server: Ftp://pepstack.com/pub/rpm/MySQL-server-5.6.27-1.el6.x86_64.rpm To

Connect Oracle to MySQL on Linux [Preface] The method for connecting Oracle to MySQL on the Windows platform has been introduced. Most of Oracle and MySQL are now on the Linux platform, and this requirement is also available recently, let's record