Database Administrator

As the database data volume continues to grow, some tables need to be converted from normal heap tables to partition tables. There are several different methods for this operation, such as exporting table data, creating a partition table, and then

I encountered a problem during development a few days ago. During the debugging process, I found that the transaction configured on the service layer does not work. After an exception is thrown, the database is updated successfully and the

Some objects cannot be compiled after the database is upgraded from 10.2.0.3 to 10.2.0.5 recently. The results show that these objects are mainly manifested in SQL syntax that is not strictly written before, which leads to the failure of compilation

1 mysq error log error: 11:29:54 22977 [ERROR] Slave SQL: The incident LOST_EVENTS occured on the master. Message: error writing to the binary log, Error_code: 159011:29:54 22977 [ERROR] Error running query, slave SQL thread aborted. fix the problem,

Zookeeper 1. pagination of large result setsMySQL:Limit M, N;M: Index of records starting from each page. The index of the first record on the first page is 0.N: How many records are retrieved each time? 10 records per pagePage 1: M = 0 N = 10Page 2:

A few times ago, the alert Log obtained the prompt that the Heap size exceeds the specified threshold, that is, Heap size 80869 K exceeds notification threshold (51200 K ). The threshold value has increased to 50 MB since Oracle 10.2.0.2.

Reprinted from: http://blog.csdn.net/fzhmoive/article/details/20042437,http://blog.csdn.net/leili0806/article/details/8573636 1. Download MySQL Community Server 5.6.162. decompress the MySQL packageDecompress the downloaded MySQL package to the

1. Install phpPgAdminDecompress the downloaded package Run the following command for tar.gz: Copy codeThe Code is as follows: gunzip phpPgAdmin-* .tar.gzTar-xvf phpPgAdmin-*. tar Run the following command for tar.bz2: Copy codeThe Code is as follows:

Connect to MongoDB using Java Package mymaven; import java.net. unknownHostException; import java. util. set; import com. mongodb. basicDBObject; import com. mongodb. DB; import com. mongodb. DBCollection; import com. mongodb. DBCursor; import com.

It provides multi-version parallel control, supports almost all SQL components (including subqueries, transactions, and user-defined types and functions), and provides a wide range of (Development) language binding (including C, C ++, Java, perl,

Migrate data files in the file system to the ASM Storage The RAC environment uses ASM for storage.Recently, some data files are stored in the file system during database maintenance, which is abnormal. As a result, the running instance on another

Both PostgreSQL and Oracle provide statements such as row_number () over () to rank corresponding fields, which is very convenient. MySQL does not provide such a syntax. Recently, due to the increasing demand for migrating data from Oracle to MySQL,

-- ===================================================== ========== -- Use an external table to manage Oracle alarm logs (ALAERT _ $ SID. LOG) -- ===================================================== ========== A part of Oracle alarm logs that DBAs

The first case applies: Oracle Net Services-Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]Information in this document applies to any platform.Checked for relevance on 8-jul-2013.Oracle Net and RAC from 10.1 onwards.SYMPTOMS In a RAC

Experimental Environment] platform centos6.4IP allocation 192.168.30.101 node1 mysql-proxy192.168.30.102 node2 mysql master node 192.168.30.103 node3 mysql slave Node 192.168.30.104 node4 client Note:1. mysql5.52 has been compiled and installed on

Many projects use latin1 encoding to store Chinese data because engineers are not rigorous or have insufficient levels to choose wrong database encoding during initial construction. As the complexity of the project increases, various coding problems

I. Classification of mysql commands Mysql commands can be divided into client commands and server commands: 1) Client commands \ C: early termination of concluding remarks \ G: Send the statement to the server for execution no matter what the

Oracle does not support Slackware Linux, but you will find this document useful for your learning. First, create a Linux User Group Groupadd oinstallGroupadd dba Create an Oracle user Useradd-g oinstall-G dba oraclePasswd oracle Set shared memoryAdd

Many software companies understand the importance of developing applications that do not depend on specific database types (such as Oracle, SQL Server, and DB2), allowing customers to choose their preferred platforms. Generally, software developers

ASP + Access security hazards ASP + Access the main security hazards of the solution come from the security of the Access database, followed by security vulnerabilities in the ASP Web page design process.1. storage risks of Access databases In the