Database Administrator

Slave have equal MySQL Server UUIDs Recently, When I deployed The MySQL master-slave replication architecture, I encountered "Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs

Restore the backup set created by mysqldump Restore the backup set created by mysqldump: SQL format recovery Create a table structure first Method 1: [Mysql @ mysql1 ~] $ Mysql-usystem-p123456-S/data/mysqldata/3306/mysql. sock hugc Method 2:

Unzip problems when installing Oracle database software in a HP-UX When you first install the Oracle database under hp-ux, you will encounter the Oracle database software medium (*. zip Format) cannot be decompressed, because there is no unzip

Oracle column commands The Oracle column command can be used to format the column title and data. The syntax of this command is as follows:COL [UMN] [{column | expr} [option...]Column nameOptions specifies one or more options used to format columns

Oracle get command Oracle can use the get command to read file content to the buffer zone,The get command syntax is as follows:Get [file] file_name {list | nolist]File_name indicates an external file, which is included in the SQL * plus buffer.List

Size of SGA during Oracle 10 Gb startup The size of the SGA started in Oracle 10g Database is determined by sga_target and sga_max_size. The following three cases are discussed: Sga_target = sga_max_size Parameter file

Slow query caused by incorrect MySQL prefix Index The front-end time is related to a DB project. alanc reports a query. Using indexes is much slower than not using indexes. So I followed up and used explain to look at two different query

Six important practical skills in MySQL ProgrammingEach command line ends with a semicolon (;). For MySQL, you must keep in mind that each line of its command is ended with a semicolon (;), but when a line of MySQL is inserted in PHP code, it is

MySQL uses binary logs to restore the database 1. Introduction to binary logs MySQL has different types of logs, in which the binary file records all changes to the database. If the database loses data due to improper operations or other reasons, it

Oracle problems with number type conversion to_char Oracle problems with number type conversion to_char Select to_char (0.1) nums from dual; It is observed that if the integer of a decimal number is 0 and the preceding 0 is not displayed after

MongoDB achieves regular currentOp capture Problem description: When analyzing performance problems in the production environment, it is often impossible to get started because there is no real-time basis. The author captures db. currentOp () to the

Analysis on the string type in Redis, Xinxing redis The string type is the most basic data storage type in Redis. It is binary safe in Redis, which means that this type can accept data in any format, for information such as data or json objects, the

Interface ResultSetMetaData, resultsetmetadata Definition: public interface ResultSetMetaData extends Wrapper Can be used to obtain information aboutResultSetThe object of the column type and attribute information in the object. Create the following

[Translated from mos] Why does rman not use the unused block compression function during Backup? rmanunused Why does rman not use the unused block compression function during the backup process?Source:Why is RMAN not using Unused Block Compression

Atitit. automatically generate a database structure script or change the database, based on hibernate4, atitithibernate4 Atitit. automatically generate the database structure script or change the database, based on hibernate4   Current situation ::  

Path to mathematics-sas memo (5), path to mathematics-sas memo Import and export data PROC IMPORT DATAFILE = "file name" // specifies the complete path and file name of the file to be imported OUT = logical reference database name. Dataset DBMS =

How to purge objects that have been dropped, purgeddrop objects How to purge objects that have been dropped Log on to sqlplus as the user of the drop object Then show recyclebin; F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release

Install POSTGRESQL on FREEBSD, freebsdpostgresql It took a long time to reinitialize it many times. During installation, run the command pkg search postgresql. Select the latest 9.4 to install the server, and the client will be installed together.

Flashback query, flashback The FLASHBACK Technology includes multiple aspects: flashback database, flashback drop, flashback query, and flashback table. Among them, flashbackdatabase uses the flash back log, the recycle bin used by flashback drop,

Perform an experiment where initial is larger than uniform size multiplied by minextents, and summarize the distribution rule of initial extent, minextentsinitial This article is the original article, reproduced please indicate the source: