Database Administrator

How to Use SQLyog to remotely connect to MySQL 1. When the SQLyog client remotely connects to MySQL using the root user, the system prompts "Access Denied" and searches the internet for the reason. It turns out that MySQL does not authorize its

Solutions to OUI-25031 during Oracle 10g RAC setup The OS version is Enterprise Linux Server release 5.4.DB version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biWhen you install the clusterware component during RAC configuration,

Oracle Rac 11.2.0.3 migrate OCR and VOTEDISK, 11.2.0.3votediskEnvironment: AIX7.1 + Oracle Rac 11.2.0.3Migration Description: When Oracle Rac is installed today, the GB Data disk is incorrectly used as OCRDG. Therefore, it will be troublesome to

[MongoDB] The high query operation of MongoDB (III), mongodboperation1, Sort Needless to say, mongodb also support to sort data. THe positive one means sorting by asc order and negetive means by desc. 2. Group The grammar of group: Description Of

Redis speed limiter design (lua scripts and things are not used), redisluaThe company has a need to send a fixed number of requests per minute to a server other than the LAN, a fixed number of requests, it means that all requests sent by all

UML-Deja Vu and uml-Deja vu When I saw the UML, I felt that it was very tall. There was such a cultural name, and there was a more meaningful explanation: design tools, there was a kind of visual feeling immediately. Software Engineering is a design

SQLServer sets two primary keys, and sqlserver sets the primary keyZookeeper First, a table cannot have two primary keys. However, two fields can be combined into a primary key, which is why two fields in the table sometimes have a primary key flag,

Linux host monitoring information display, linux host monitoringStorage information display:Overall space and free space display[Root @ ora11g64 ~] # Df-hFile System capacity used available % mount point/Dev/mapper/VolGroup00-LogVol0037G 15G 20G 43%/

Oracle data file structure, oracle Data Structure Oracle data structures are divided into physical and logical structures. Physical Structure: data block of the Operating System-> data file datafiles Logical Structure: Minimum database block -->

[MySQL] grouping and sorting: obtain the first N records and generate an automatic number sequence, similar to group by after limit, mysqlgroupPreface:The business scenario of a colleague is to group by cid and author, and then reverse the id to

Atitit... Summary of the trigger mechanism ltrigger mechanic sumup. O8f, ltriggero8f Atitit... Summary of the trigger mechanism ltrigger mechanic sumup. O8f   1. Trigger type 1 2. Implementation Principle 1 3. After trigger Vs Instead Of trigger 1 4.

Oracle 11g's dependence judgment reaches the field level, oracle11g In Oracle 10 Gb, the dependency only reaches the object level. That is to say, once the object accessed by the Stored Procedure changes, Oracle sets the stored procedure to INVALID.

MySQL performance optimization (1), MySQL performance optimization ( Performance Optimization involves six points: 1. basic MySQL operations 2. common SQL skills 3. SQL statement optimization 4. mySQL database optimization 5. myisam Table lock 6.

ADO. NET 4-use the SqlCommand object to add records to the database --- ShinePans, Source code: Using System; using System. collections. generic; using System. data; using System. data. sqlClient; using System. linq; using System. text; using

If ash is stopped, report problems cannot be solved.1. database version Oracle 11.2.0.3.0 2. Problem When you use ashrpt. SQL to generate an ash report, there is no response after you enter the start time, specify the report file storage path, and

It is estimated that the Checkpoint Lag calculation method of the rep process on the Oracle GoldenGate (OGG) destination end is called oraclelag. This article is original. For more information, see the source. It is estimated that the Checkpoint Lag

Multi-Table query (Chapter Summary), Table query Chapter Summary1. Multi-Table query refers to a query operation that retrieves data from multiple tables at the same time.2. During Multi-table queries, because the database retrieval mechanism

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction, hy000restarting My friend asked me that the execution of a simple update statement failed. The symptoms are as follows:Mysql> update order_info set province_id = 15, city_id

Detailed use of RECORD, VARRAY, and TABLE in ORACLE, oraclevarrayLimit limit 1 Description 1.1 RECORD Define the record data type. It is similar to the STRUCTURE in C language. PL/SQL provides a holistic approach to combine several related,

What does SQL Server non-clustered index bring to us? SQL Server Profiler is used to track the execution of SQL statements when a page is accessed. Because the application is very simple, three SQL statements are detected during page loading, after