Database Administrator

Parameter configuration for MySQL Performance Optimization 1. Purpose: Modify the MySQL System Parameters Based on the current status of the server to reasonably utilize the existing resources of the server and improve the MySQL performance. 2.

Monitor and manage the use of Oracle UNDO tablespace The monitoring and management of Oracle Database UNDO tablespaces is one of our most important tasks in daily life. The UNDO tablespaces are usually managed automatically by Oracle (determined by

Redis cluster _ 3. redis master-slave automatic switch Sentinel, redis_3.redisRedis SentinelSentinel (Sentinel) is a tool used to monitor the Master Status in redis clusters. It has been integrated into redis2.4 + versions.I. Role of Sentinel:1):

MySQL date types: DATETIME, TIMESTAMP, and datetimetimestampThere are three types of dates in MySQL5: DATETIME, DATE, and TIMESTAMP, except that DATE is used to indicate a DATE without time and second, and the other two have time and second.

Database Operations-triggers, databases-triggers A trigger is a special type of stored procedure. Unlike a stored procedure, a trigger is triggered by an event and automatically called for execution, the stored procedure can be called by the name of

Poor memory: 22-JAVA database connection pool C3P0, 22-javac3p0 C3P0 is an open-source JDBC connection pool that implements data source and JNDI binding and supports JDBC3 specifications and standard extensions of JDBC2. Currently, open-source

Implementation of Redis multi-host database and redis Database 1. Copy In Redis, You can execute the SLAVEOF command or set the slaveof option to let one server copy another server. We call the copied server as the master server ), the server that

Hp-ux slvm, slvm At first, I heard the name "hp-ux slvm. After searching, find a pdf document: , fourth edition in September 2009, find the slvm explanation: The shared LVM (SLVM) allows multiple systems in the Serviceguard cluster to share (read/

Install and configure the hadoop plug-in myeclipse and eclipse in windows/Linux, and myeclipsehadoop I recently want to write a test program MaxMapperTemper on windows, and there is no server around, so I want to configure it on windows 7. Succeeded.

Oracle uses triggers to implement auto-increment columns, and oracle uses triggers Oracle uses triggers to implement auto-increment Columns   Oracle does not have the auto-increment function. mysql and sqlserver use auto_increment and identity () to

MongoDB installation and simple commands, mongodb installation commands Mongo http://www.mongodb.org/downloads Vue tool download http://www.mongovue.com/downloads/ Create a folder and put the unzipped mongo file. Make a variable and specify the

ORA-14099: all rows in table do not qualify for specified partition, ora-14099qualify 1.Create a partition table Create table range_part_range (id number, deal_date date, contents varchar2 (1000 )) Partition by range (deal_date) ( Partition p1

Comparison of the two types of SQL statements and comparison of the two types of SQL statementsSUM (p. payable-p. single_price) AS profitCount,M. order_id AS orderId,M. create_time,M. dept_airport_code,M. arrv_airport_code,M. payable AS

Store data outside the database or file system to improve the performance and performance of the report system. In report applications, the proportion of reports queried for historical data is large. Such reports have the following features: first,

Create a root user in Mysql, and create a root user in mysql After mysql is installed in linux, an error occurs. At first I thought there was no password problem. I modified it according to this article: after the first login to mysql in linux, I

MYSQL registration Start and Stop unmount batch processing script (Supplement), mysql Batch Processing The batch file that was written earlier when the mysql interface was debugged. Register and start my_install.bat @echo offset MYSQL_DIR=%~dp0rem

MySQL series: innodb source code analysis-redo log recovery, innodbredo In the previous "innodb source code analysis-redo log structure", we know the basic structure and log writing steps of the redo log. How does the redo log recover data? When

How does Oracle12c import scott users and oracle12c import scott How does Oracle12c input scott users? After installing oracle12c, unlike the original one, there is no scott user by default, and there is no corresponding emp or other tables. Of

8. mysql dual-host Master/Slave, mysql dual-host In this era of data explosion, data backup is the most important thing for every company. As a data storage warehouse, the importance of database is self-evident. Major databases include: 1. Large

MySQL database backup and recovery methods, mysql Database BackupMySQL database backup and recovery methodsMysql-uroot-pShow databases;1. Export the database1). MySQL command line to export the entire database (including data)The exported files are