Database Administrator

Linux personal operation habits, linux personal habitsEdit ~ /. Add the following content to the bashrc file and define the alias #. bashrc # User specific aliases and functionsalias rm = 'rm-I 'alias cp = 'cp-I' alias mv = 'mv-I 'alias cls = 'clear'

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [], [], internalerrorcode SQL> startup nomount;ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] The root cause of

Oracle redo management, oracleredo1. Category Several types of log files in Oracle Redo log files-> online Redo log Archive log files-> Archive log Alert log files-> alarm log Trace files-> Trace logs User_dump_dest-> User tracking log

How to uninstall oracle11g and oracle11g Oracle 11g R2 x64 Redhat5 (rhel x64) 1. Use SQL * PLUS to stop a database [oracle@OracleTest oracle]$ sqlplus logSQL> connect / as sysdbaSQL> shutdown [immediate]SQL> exit2. Stop

[Translated from mos] visit the well-known ODBC driver list of Oracle Database, mosoracle Source:List of Well Known ODBC Drivers For Accessing An Oracle Database (Document ID 1932774.1) Applicable:Oracle ODBC Driver-Version 8.0.5.1 and

Mysql trigger, mysql trigger instanceCreate a trigger Delimiter $ change the end symbol of mysql to $ Create trigger the trigger contains the SQL statement to be triggered: The statement here can be any legal statement, including compound

Apsaradb for MongoDB basic knowledge1. Introduction: MongoDB is a distributed file storage-based database. Written in C ++. It is designed to provide scalable, high-performance data storage solutions for WEB applications.MongoDB is a product between

Mybatis exception: the element content must contain correctly formatted character data or tags ., Mybatis character When my colleague wrote a query interface today, an error occurred: the element content must consist of correctly formatted

Connect to MongoDB using Java, operate on mongodb, and connect to MongoDB using java Java is very simple to connect to MongoDB. Specifically, there are two steps:1: import the java-mongo driver package to the new project.: 2: create a link help

Mysql5.5.27 master-slave replication and mysql5.5.27 master-slave ReplicationMaster-slave replication principle: 1. Copy the architecture Diagram 2 initialization Diagram 3 replication Principle Mysql uses three threads to execute the

Mysql compilation and installation tutorial in Linux (centos), centosmysql How to compile and install mysql in Linux # Viewing the linux release version Cat/etc/issue # View the Linux kernel version Uname-r Test Environment centOS6.6   I.

One accident caused by 0.6 billion data entries and one accident caused by 0.6 billionThe business staff told me that the IO of a System Disk lasted as high as 300 MB/s, and the system platform was AIX, so the topas check was indeed the case. Run

Java playframework and playframework Shortly after learning java, let's try the architecture and choose a simple architecture. The running environment here is JDK1.7. I tried jdk1.8 but it won't work. The problem is that play-1.2.7 is used for

Consistent hash and hash Consistent hash is a special hash algorithm. After the consistent hash algorithm is used, the number of slots (size) in the hash table only needs to be re-mapped to K/n keywords on average, where K is the number of keywords,

Beckham _ mysql partition instance and Beckham _ mysql instanceMysql partition ExperimentBrief: 1. Create partitions Based on the partition type 2. Manage partitions 3. Examples of partitions and unpartitioned tables   1. Create a partition. Use

SUSE Linux source code compilation and installation MySQL 5.6, susemysql This article mainly introduces how to install MySQL 5.6 in SUSE Linux Source Code compiling mode. This article uses SUSE Linux Enterprise Server 10 SP3 (x86_64) system. For

Install mysql in ubuntu 1204 and ubuntu Check whether mysql is installed on the local machine sudo netstat -tap | grep mysql After executing the preceding command, the mysq socket is in the listening status, indicating that the installation is

High-concurrency and high-traffic website architecture: simple ideas and concurrent traffic Architecture*******************************Front end*******************************1. Increase the necessary hardware and bandwidth, and reserve an

Left join, right join, and mysqljoin in mysql Left (outer) join: The left table is dominated by all rows in the left table. The right table lists the data that meets the requirements of the record. Right (outer) join: The right table is the

Beckham _ mysql partition theory learning, Beckham _ mysql theory learningMysql PartitionBrief:I. Why mysql partition II? mysql partition type III. mysql partition technology comparison   I. Why mysql partitioning? 1. When business data increases,