PostgreSQL9 connection information to the database

PostgreSQL9 connection information to the database To connect to the database, sql9 must provide the following parameters: Host or host address, port number, database instance name, user name, and user password. When you log on to the server, you

Use XtraBackup to back up and restore the MariaDB Database

Use XtraBackup to back up and restore the MariaDB Database Use xtrabackup for backupIntroduction to XtrabackupXtrabackup is a mysql database backup tool provided by percona. According to the official introduction, Xtrabackup is the only open-source

ORA-19571 for RMAN backup

ORA-19571 for RMAN backup A ORA-19571 error occurred while performing an RMAN backup, resulting in the end of the backup task with the following error: RMAN-00571: ========================================================== ===========================

Simple role-based permission management of RBAC

Simple role-based permission management of RBAC 1. What is permission management? permission management refers to the subdivision of background functions and the management of jobs divided by different employees How RBAC is implemented is managed

Collection iterator pickler fetch appears in the execution plan

Collection iterator pickler fetch appears in the execution plan Today, when I used explain plan for to view the SQL Execution plan, the following strange execution plan appeared: SQL> explain plan for select * from test where object_id = 100;

Oracle synonym + dblink Application

Oracle synonym + dblink Application Oracle synonym + dblink Application Business Requirements: original database (10.2.0.4.0), new database (11.2.0.3)Due to program requirements, you need to map a user in the new database to the user in the old

Use YCSB to test MongoDB's performance

Use YCSB to test MongoDB's performance MongoDB database-Level Lock MongoDB is currently the most popular NoSQL database. It is favored by many developers with its natural document-type data structure, flexible data models, and easy-to-use horizontal

MongoDB common optimization settings in Linux

MongoDB common optimization settings in Linux Below are some common optimization settings recommended by MongoDB. Selecting an appropriate parameter value in the production environment, such as the preread value and the number of default file

Use mysqldump to back up MariaDB

Use mysqldump to back up MariaDB Introduction to mysqldump backupMysqldump is a utility used by mysql to store databases. It mainly generates an SQL script, including the CREATE TABLE INSERT command required to re-CREATE a database from scratch. It

Automatic Discovery and monitoring of apsaradb for Redis Based on Zabbix monitoring

Automatic Discovery and monitoring of apsaradb for Redis Based on Zabbix monitoring System Version: CentOS5.10Python version 2.4.3 1. python supportYum-y install python-simplejson 2. discovery script[Root @ localhost etc] # cat redis_port.py #! /Usr/

Install and configure MySQL in CentOS

Install and configure MySQL in CentOS MySQL is preferred. The first MySQL database version is released on Linux. Other options include postgreSQL and Oracle. Install the mysql database on Linux. You can download the rpm package of the MySQL database

AWR export/import/Generate Report

AWR export/import/Generate Report The customer's production system is always so important that you will not perform operations on their production machines for a long time. However, analyzing and generating AWR reports is a relatively

Oracle user password Problems

Oracle user password Problems Oracle users seldom pay attention to their passwords. Generally, the password expiration time is set to never expire after the database is installed, but an error occurs when autotrace is enabled, it attracted my

Use LVM to back up and restore the MariaDB Database

Use LVM to back up and restore the MariaDB Database Comparison with mysqldump to introduce LVM snapshot volumesMysqldump: Hot Backup cannot be performed, and the backup time is long when the database is large. The advantage is that the Backup

Oracle TDE transparent data encryption technology

Oracle TDE transparent data encryption technology From ORALE 10GR2, Transparent Data Encryption technology (TDE) emerged ). TDE is used to encrypt data. Generally, the application logic executed by SQL statements does not need to be changed and can

Summary of the hit rate query statements of the Oracle database

Summary of the hit rate query statements of the Oracle database 1) hit rate of Library CacheFormula: Library Cache Hit Ratio = SUM (PINHITS)/SUM (PINS)Select sum (PINHITS)/SUM (PINS) from v $ LIBRARYCACHE; The hit rate cannot be lower than 99%.

Disable task execution using the DBMS_STAT Function

Disable task execution using the DBMS_STAT Function Use the following statements to view SQL statements with large physical reads Select executions,Disk_reads,Buffer_gets,Round (buffer_gets-disk_reads)/buffer_gets, 2) Hit_radio,Round

Oracle client simple connection error ORA-12154, TNS-03505

Oracle client simple connection error ORA-12154, TNS-03505 Environment:Server: RHEL6.5 + Oracle Server 11.2.0.4Client: Win2003 + Oracle Client 10.2.0.11. symptom 2. Troubleshooting 3. Solve the Problem 1. symptom The Oracle database is installed on

Unix/Linux Kernel Parameters closely related to Oracle

Unix/Linux Kernel Parameters closely related to Oracle The following are several Unix/Linux Kernel Parameters closely related to Oracle. During database installation, the parameters must be adjusted according to the actual situation. Init.

Oracle 11g Silent Installation Software + manual database creation

Oracle 11g Silent Installation Software + manual database creation Because it is a secondary jump + remote operation, the GUI cannot be used and cannot be directly installed on the GUI. Use silent software installation + manual database creation to

Total Pages: 1013 1 .... 111 112 113 114 115 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.