Database Administrator

In earlier versions, if a high-load machine is restarted and a large amount of hot data in the memory is cleared, it will re-load the data from the disk to the Buffer_Pool buffer pool, in this way, the performance will become very poor during peak

SQLArticle:1. Full list of classic SQL statements 2. MySQL database backup and recovery 3. SQL2K database development tutorial 4. Study Notes of SQLServer 2005 5. Configure SQL Servel 2005 in VMWare 6. SQL Server backup and recovery 7. Storage

1. Why do I need to use transactions?A transaction is a single unit of work. If a transaction succeeds, all data modifications made in the transaction are committed,Become a permanent component of the database. If the transaction encounters an error

Today, a colleague asked me a question: "After the mysql master uses binlog_ignore_db as a database, all statements executed using mysql-e will not write binlog? " I asked him about the situation. He tried to check his my. in cnf configuration,

In daily work, because I am not familiar with the InnoDB engine, many people in the group have deleted InnoDB ibdata files by mistake) and ib_logfileredo log redo transaction log files. If you have master-slave replication and synchronization, it's

When checking the system today, I found that the system reported an error message about the ORA-00376. In general, the data file:/database/data1/orcldata/d_datafile7.dbf is wrong?   How can we solve this problem, The following describes how to solve

Today, my buddy told me that some modules in OA are invalid. After checking the system logs, it turns out that the temporary tablespace of the Oracle database is full, during lunch, I restarted the database. This method is the easiest and not prone

Tutorial environment: ORACLE11GR2, CENTOS6.2 32-bit version removes the need to modify the redhat Yum source, ipset to 192.168.233.10, NAT Network), VM8.0 version For installation instructions, refer to the official website documents and some

First, you can download oracle11g version 2 from the Oracle Chinese official website. Here we demonstrate how to install it on a Windows 32-bit operating system ). Oracle11g Second Edition Chinese official website installation address:

This article introduces the manual failover operation and troubleshooting process in the redis master-slave environment. When the master instance goes down, the master instance is upgraded from the master instance to the master instance and data is

Introduction: indexing hot blocks are actually very different from the hot blocks of data blocks. They are also caused by a large number of sessions accessing the same index block. Our solutions include reverse indexing, partition indexes. We say

For large tables based on secondary indexes), range scanning will lead to many random IO. the bottleneck of a general disk is that the random IO performance is poor. In MySQL5.6, this situation is optimized, the emergence of a new term Multi-Range

650) this. width = 650; "border =" 0 "src =" http://img1.51cto.com/attachment/201212/102038943.jpg "alt =" "/> -- MySQL INNODB technology insider Jiang chengyao Here is my table structure: mysql> show create table p1\G;  **********************

Summary: Recently, we have been conducting business stress tests to improve the system's transaction processing capabilities. The transaction processing volume is nearly three thousand from the first 10 thousand to today, and some optimization

What are the meanings of the levels of the 10046 event? Level 0 Tracing is disabled. This is the same as setting SQL_TRACE = FALSE.    Level 1 Standard SQL trace information (SQL_TRACE = TRUE). This is the default level.   

1. Use row-level locks to avoid table-level or page-level locksTry to use a storage engine that supports row-level locks, such as InnoDB; use a storage engine that uses table-level locks only in scenarios where reading operations are significantly

At three o'clock P.M., the server was shut down and recovered several minutes later. remote connection to the Windows virtual machine showed abnormal shutdown.   The website is abnormal, and the database is damaged due to abnormal shutdown and data

This is an SQL statement they developed to delete duplicate data and the row whose id is the minimum value is not deleted: delete from jd_chapter a where a.`id` in (select `id` from jd_chapter group by book_id,chapter_id  having count(*)>1)   

A batch of data was updated last night. It took more than 20 minutes to use the old update method, but it took less than two seconds to end with merge. For details, see: Use the BIRTH field of T_TMP_SCHOOL135868) to update the BIRTHDATE field of

  1. Node 1 is damaged and cannot receive heartbeat from other nodes.Node 2 can receive the heartbeat of Node 3 and node 3 can receive the heartbeat of Node 2.Node 1, heartbeat information to votingdisk: "Only I am alive !"Node 2 and 3, heartbeat