NAV: SLTechnology News&Howtos > Database >

• 

  Detailed explanation of the use of physical backup and online backup tool pg_rman (9)

  Pg_rman tool is a backup tool for online backup, physical backup and recovery of PostgreSQL database. Can achieve full backup, incremental backup. Full: full Increment: incremental Archive: archiveUsage: P

  2022-06-01 16:44:03 Views: 247
• 

  Oracle Study-- an error case of Logical Standby Log Application

  Oracle Study-- Logical Standby log application error case system environment: operating system: RedHat EL54 database: Oracle 11gR2 I. error phenomenon: (when logically preparing database application log) LOGMI

  2022-06-01 16:44:02 Views: 260
• 

  Mongodb 3.0.2 and wiredTiger Storage engine installation Test

  Mongodb3.0 version, in addition to the previous default MMAP storage engine, but also launched a new wiredTiger storage engine. According to the test report on the official website, the write performance of mongodb 3.0 can be improved by 7-10 after using the wiredTiger storage engine.

  2022-06-01 16:44:02 Views: 297
• 

  The setting method of Oracle 11g Database automatically starting and shutting down with the system

  Note: this article is based on the practice and revision of online articles. RHEL6.8 64bit+Oracle Database 11g Enterprise Edition Release 11.2.0.1.0Oracle 11g

  2022-06-01 16:44:02 Views: 254
• 

  CentOS 7 installs zabbix3.2 in yum mode and explains the configuration file in detail

  1. An introduction to zabbix and a brief introduction to the environment can be found in the introduction to zabbix: CentOS 7 (node7): zabbix-server,web,mysql,agentmariadb:5.5.50za

  2022-06-01 16:43:56 Views: 225
• 

  Windows 2008 R2 x64 + oracle 11.2.0.4 x64 installation

  This blog is mainly aimed at novice database creation tutorials, so it is more detailed and verbose. In this paper, the creation of the database is divided into three steps: the first step is to install the Oracle database software; the second step is to create a new database listening in netca; the third step is to create a new database instance in dbca; the operating system uses

  2022-06-01 16:43:26 Views: 217
• 

  SP2-0110: Cannot create save file & quot;afiedt.buf"

  Sp2-0110: unable to create save file "afiedt.buf" provenance: this problem is due to changing Times error with ed when using define _ editor=vim: Cannot create save file "

  2022-06-01 16:43:23 Views: 304
• 

  01 introduction and installation of Oracle

  Introduction to Oracle and installation of 1.Oracle Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. The Oracle database system is currently

  2022-06-01 16:43:23 Views: 232
• 

  Basic operation of mysql database (table structure)

  The relevant configuration files will be automatically generated after the service is started with the package. The root initial secret initial password will be automatically generated when the service is first run. Look for grep-I password / var/log/mysql.log in the service log file and enter the mysqlmysql.

  2022-06-01 16:43:22 Views: 216
• 

  [MongoDB Learning Notes 21] compound Index of MongoDB

  The values of the index are arranged in a certain order, so using the index key to search and sort the document is faster; but the index is useful only if the index is used first; for example, in the following sort, the index on "username" does not work: > db.users.fi

  2022-06-01 16:43:16 Views: 213
• 

  Garbled codes when Chinese characters are very commonly used in ORACLE database

  As the system needs to support Chinese input from the mainland and Taiwan, there are often unusual characters that are not included in GBK coding. If the character set is not set properly, it will be reflected as Chinese garbled. For example, create table ttt (name varchar2 (10)); insert

  2022-06-01 16:43:16 Views: 252
• 

  About how to use MySQL's group_concat () function on vertica

  Today, when customers are using vertica, they want to use the group_concat () function of MySQL. The GROUP_CONCAT function returns a string result that is composed of value concatenations in the group. Because this function is in vertica

  2022-06-01 16:43:01 Views: 245
• 

  MongoDB-Manual-Master Reading Notes-introduction and installation

  MongoDB describes what MongoDBMongoDB is an open source documentation database that provides high performance, high availability, and high scalability. 1.1.1 A record of a document database in MongoDB is called a document, which can also be understood as a relational database.

  2022-06-01 16:42:55 Views: 254
• 

  Detailed explanation of "Index" of SQL server Database

  What is an index? An index in a database is similar to a catalog in a book. Indexing is an internal way for SQL Server to orchestrate data, which provides SQL Server with a way to route query data. An index page is the data page that stores the index in the data. Index pages store retrieval data

  2022-06-01 16:42:55 Views: 288
• 

  General cursor paging stored procedure PageSplit

  ALTER procedure [dbo]. [PageSplit] @ sql varchar (max),-- sql statement to be executed @ page int=1,-- Page number to be displayed @ pageSize int,--

  2022-06-01 16:42:54 Views: 250
• 

  Installation Oracle11gR2 RAC--- creates an ASM disk group

  Chapter 3: create an ASM disk group after logging in with grid users, enter asmca, enter the password, and then click the create button to start creating the disk group. Create a FRA disk group select the disk and set the disk group name to FRA. Click ok.ok to create DATA magnets in the same way.

  2022-06-01 16:42:28 Views: 291
• 

  Mongodb remote access configuration

  1. First, modify the configuration file of mongodb to listen to all public network ip editing files: / etc/mongodb.conf, the modified contents are as follows: bind_ip = 0.0.0.0port = 27017auth=true2,

  2022-06-01 16:42:27 Views: 235
• 

  Oracle with as usage

  The With query statement begins with with, which is equivalent to building a temporary table before the query, and the specified query results are stored in the temporary table, and then it can be used many times for further analysis and processing. Syntax: with _ tempTable as (select *

  2022-06-01 16:42:27 Views: 208
• 

  The database specifies the fields in the database table for backup, and sends mail to the specified mailbox ​ regularly in the form of a table.

  Backup data is sent to mkdir-p / opt/module/shell/mkdir-p / opt/module/shell/sql/revenue.sqlmkdir-p / opt/modul by regular mail.

  2022-06-01 16:42:27 Views: 253
• 

  Configure database read-write separation server

  Configure one master and one slave master-slave synchronization structure, and configure master51 > grant all on webdb.* to webuser@ "%" identified by "123456" on the client side; package rpm-

  2022-06-01 16:42:27 Views: 248