Database Administrator

Mysql Installation and Use In OJ, mysql is mainly used to store user information. It is easy to install and use. The following is a brief introduction. First, I will explain that my Linux branch environment is Ubuntu 12.04, and the general steps of

MYSQL service cannot be started: InnoDB:. \ ibdata1 can't be opened in read-write mode, innodbibdata1 I did an experiment there today and dumped the mysql database. Later I found that the service could not be started. The following error was

Oracle 11g replica uard creation in ORA-01665 resolution, dataguardora-01665Oracle 11g fails to restore the standby control file when creating data guard. When I mount standby database, tell me that the control file is not a standby control file and

T-SQL view, t-SQL View View [Younger brother build view previously is visual operation rarely write T-SQL statement, but in the work of release version is necessary, write some T-SQL statements, so we still write more points better] 1. What is a

Database trigger introduction and instance, database trigger instanceTrigger It is a special stored procedure. A general stored procedure is called directly through the stored procedure name, and the trigger is mainly Triggered by an event (add,

Oracle Performance Optimization Operation 10: decomposing complex queries, replacing variables with constants, and optimizing oracle Performance For complex Where condition combinations, Where contains multiple indexed fields, use the IF statement

Oracle Performance Optimization Operation 14: using function-based indexes, oracle Performance Optimization As mentioned above, any operations on columns may cause full table scanning. For example: select * from emp where substr (ename, 1, 2) =

MYSQL master-slave synchronization configuration for CentOS and centosmysql master-slave 1. Both the master and salver close the firewall iptables and execute the service iptables stop command: Set SELINUX = disabled for The SELINUX file ,: 2.

Avoid regionServer downtime and regionserver downtime Because regionserver management information is mainly recorded in zookeeper, regionserver's downtime judgment is based on session expired. OK So what are the causes for the session expired of

Good habits of database design and use, good habits of Database Design Good habits need to be constantly cultivated and strengthened until they become a habit and then part of their thoughts. Before or after work, I want to read "three character

Oracle performance optimization operation 8: Use HINT to forcibly specify the index, oraclehint When the ORACLE optimizer cannot use a reasonable index, the HINT is used to forcibly specify the index. In the example of "oracle Performance

Oracle performance optimization operation 5: Remove "<>", oracle performance optimization whenever possible Oracle performance optimization operation 5: Remove "<>" whenever possible" Remove "<>" whenever possible to avoid full table scan. If the

One ORA-00130: invalid listener address error, ora-00130listener Log on to the 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 2015 Copyright (c) 1982,200 9

Before the hardware engineer moves the storage, Oracle dba's preparation and review work, oracledba This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/42425491 Before the

Oralce time conversion usage TO_CHAR (DATE, FORMAT), oralceto_char 1. This week, this month, and this year -- This week select trunc (sysdate, 'D') + 1 from dual; -- Monday select trunc (sysdate, 'D') + 7 from dual; -- Sunday -- select trunc

C # Datatable export CSV algorithm, c # datatable export csv/// /// Export data to a CSV file/// /// datatable to be exported /// name of the exported column dictionary, key datable column, and value column to be exported /// exported file path

Compressed database and access compressed DatabaseZookeeper 1. display the disk space reserved and used by the entire database. EXEC SP_SPACEUSED 2. display the database file list SELECT * FROM SYSFILES 3. Set the database recovery mode to

Oracle password attempts and oracle attempts Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright. Deep

Oracle performance optimization operation 1: Avoid Column Operations and optimize oracle Performance Any operation on a column may cause a full table scan. Here, the so-called operations include database functions, calculation expressions, and so

Oracle deletes data and oracle deletes data. The syntax for Oracle to delete data in a table is: Syntax structure: Delete from table name WHERE Condition Code Demonstration: SQL> delete from infos where stuid = 's100103 '; 1 row deleted SQL>