Database Administrator

InnoDB modifies the table object structure online Modify the table object structure online: Before MySQL5.6 1. Create a temporary table with the same structure as the original table object (invisible to users by implicit operations) and change the

ORA-00130: invalid listener address error resolved Log on to the Oracle database. The following message is displayed: Ora11g> sqlplus dcsopen/dcsopen1SQL * Plus: Release 11.2.0.1.0 Production on Mon Jan 5 18:49:31 2015Copyright (c) 1982,200 9,

Oracle user unlock Connect first SQL * Plus: Release 12.1.0.2.0 Production on Thursday February 12 15:40:422015 Copyright (c) 1982,201 4, Oracle. All rights reserved. Enter the User name: system Enter the password: Last Successful Logon Time:

Typical use cases of MySQL MHA 1. Manage the node deployment location1.1. Dedicated Manager server and multiple MySQL (master, slaves) serversUse a dedicated management server to manage multiple groups of MySQL Master/Slave servers Since MHA Manager

After the memory usage of apsaradb for Redis reaches the value set by maxmemory, the gamer data cannot be written. Let's talk about our company's redis application scenarios. Currently, online games use redis as the front-end cache of MongoDB to

Upgrade Goldengate 11.1.1.1.2 to 11.2.1.0.1, goldengateConfiguration environment: Source：OGG：11.2.1.0.1Name:zbdba1Target:OGG:11.1.1.1.2Name:zbdba2 Upgrade Target to the same version as the source. Backup Target ogg installation directory: [Root @

How Does oracle rac correctly Delete the actionlist and racactionlist of a single node? 1 Node 2 Use dbca to delete a node 2 node 1 alter database disable thread 2; 3 Node 1 verify whether a node database has been deleted [03:49:06 oracle (db) @ rac1

Db file async I/O submit waiting for event optimization, asyncsubmit Db file async I/O submit wait for event Optimization   I. Data Generation db file async I/O submit We often see Wait events for high db file async I/O submit from the database awr

Install and optimize Mysql in Linux.System Environment: CentOS 6.5Mysql version: mysql-5.6.19.tar.gzSoftware upload path:/doiido/soft1. Install Mysql1: Firewall opens the corresponding port#/Sbin/iptables-I INPUT-p tcp -- dport 3306-j ACCEPT#/Etc/rc.

Oracle Database fragmentation management, **************************************** **************************************** 1. tablespace fragments ************************************** **************************************** ** ---- 1. view the

Create a Stored Procedure Stored in SQL Server and call C, Stored ProcedureSome compiled and optimized SQL statements placed on the database server can be directly called by the program. Using Stored Procedures has the following advantages:1.

ORACLE 11G Official documentation Demonstration: Search for manual database creation statements, oracle11g Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them.

Basic principles and principles of locksBasic Principle of oracle032 lock1. Oracle lock typeLock function: protects data, and no concurrency is available without locks. The lock is used to limit concurrency.Slow database response may not be due to

Xin Xing talks about Redis transactions and Xin Xing talks about Redis transactions Redis also provides support for transactions. In Redis, we commonly use four commands: multi, exec, discard, and watch. The multi command is used to start a

Mysqlbinlog can not parse row based events, mysqlbinlogparse During the recent MHA test, the version of the mysqlbinlog client is lower than that of the server. The error message is mysqlbinlog is 3.2 (encoded in MySQL Client 5.0 or lower), but

The SQL statement queries the structure of all tables in the database. SELECT TableName=CASE WHEN C.column_id=1 THEN O.name ELSE N'' END, TableDesc=ISNULL(CASE WHEN C.column_id=1 THEN PTB.[value] END,N''), Column_id=C.column_id,

Latch: shared pool latch: library cache diagnostic script (latchprofx. SQL, latchprof. SQL), sonysharedlibraryThe execution method is as follows: @ D: \ latchprofx. SQL sid, name, laddr % cache 10000 @ D: \ latchprof. SQL sid, name, laddr % cache 100

SQL statement Dual Loop, SQL statement The shunxu field in Table j_wenzhang_aps201503 is null. Now you want to update the shunxu Field Based on lanmu_id and qishiye. 1. If the shunxu field is auto-incremented, there are no duplicates, And the

Com. mysql. jdbc. exceptions. jdbc4.MySQLSyntaxError Exception, jdbc4.0 1. Error description Com. mysql. jdbc. exceptions. jdbc4.MySQLSyntaxError Exception: You have an error in your SQL syntax check the manual that corresponds to your MySQL

Oracle 10046 event, oracle10046 10046 eventsOracle 10046 is an Oracle internal event. The most common method is to set SQL _trace (alter Session set SQL _trace = true) at the session level, that is, to enable Level 1.10046 debugging events. After a 1