MHA Routine Management

MHA Routine Management MHA is the best choice for many enterprises that use MySQL databases for high availability. It is easy to use and powerful, and implements automatic master-slave failover Based on the MySQL replication architecture. This

Asm disk Group loading ORA-15183 error example

Asm disk Group loading ORA-15183 error example In Oracle 11gR2, ASM (Automatic Storage Management) is removed from the Database Component, and as an independent Component, it enters the scope of Grid Management. This article mainly introduces a

Cleaning temporary tablespace in Oracle

Cleaning temporary tablespace in Oracle Oracle temporary tablespace is mainly used to query and store some buffer data. Temporary tablespace consumption is mainly caused by sorting the intermediate query results. The main functions of temporary

View the version of the remote Redis Server

View the version of the remote Redis Server How can I view the version of a remote Redis server? What should I do if I have no SSH access permission for the remote Redis server and want to know which version of the Redis server is used? It's easy to

MD5 encryption in Oracle

MD5 encryption in Oracle Because MD5 encryption is used, I searched the internet for relevant information and studied it carefully. Its core is the MD5-encoded data packet function: DBMS_OBFUSCATION_TOOLKIT.MD5, which involves the RAW type, which is

How to install and deploy Cassandra distributed NoSQL Database

How to install and deploy Cassandra distributed NoSQL Database Apache Cassandra is an open-source Distributed Key-Value storage system. It was initially developed by Facebook to store particularly large data. Cassandra is suitable for real-time

Node. js remotely connects to the MongoDB database server on another host

Node. js remotely connects to the MongoDB database server on another host My MongoDB is installed in linux. First, add a user 1. First, run the terminal command line on the MongoDB server host and enter Mongo 2. Enter use admin to access the user

Oracle 11g TNS connection error ORA-12532 troubleshooting

Oracle 11g TNS connection error ORA-12532 troubleshooting TNS connection errors are common problems for Oracle users. In practice, due to the complexity of the user terminal environment, various TNS connection problems often plague daily users.

MySQL Performance Optimization-Block Nested-Loop Join (BNL)

MySQL Performance Optimization-Block Nested-Loop Join (BNL) 1. IntroductionI believe that many developers/DBAs are still not satisfied with the way MySQL processes multi-Table associations or the performance when using MySQL. Join queries submitted

How to do the truncate operation for a primary table associated with a foreign key

How to do the truncate operation for a primary table associated with a foreign key The primary and Foreign keys are mandatory associations between two tables provided by the database. They can also be implemented at the application layer.  

Use Hive's regular parser RegexSerDe to analyze Nginx logs

Use Hive's regular parser RegexSerDe to analyze Nginx logs 1. Environment: Hadoop-2.6.0 & apache-hive-1.2.0-bin 2. Use Hive to analyze nginx logs. The website access logs are as follows: Cat/home/hadoop/hivetestdata/nginx.txt192.168.1.128--[09/Jan/20

About Oracle cvu and cvuqdisk, oraclecvucvuqdisk

About Oracle cvu and cvuqdisk, oraclecvucvuqdisk About Oracle cvu and cvuqdisk Download link of cvu:Http://www.oracle.com/technetwork/products/clustering/downloads/cvu-download-homepage-099973.html Cvuqdisk is the installation package on linux.

Dynamic Registration listening and dynamic listening

Dynamic Registration listening and dynamic listeningSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release

Data Table field attribute query, data table field attribute

Data Table field attribute query, data table field attribute --- Query all database table namesSelect id, name from sysobjects where xtype = 'U' order by name--- Query all the field attributes of a tableSelect * from syscolumns where id = object_id

Oracle dblink causes too many remote database sessions. oracledblink

Oracle dblink causes too many remote database sessions. oracledblink The database of the on-site reporting network company could not be connected. I checked the database processes = 1500 and session = 2200 first. I think it is very big. Few people

Dell shareplex and HVR data replication software, shareplexhvr

Dell shareplex and HVR data replication software, shareplexhvr Today I have a general understanding of Dell shareplex data replication software, web site: http://software.dell.com/products/shareplex/ You can see from this URL,Shareplex is the

PreparedStatement and Statement, preparedstatement

PreparedStatement and Statement, preparedstatement PreparedStatement is one of the APIs used to execute SQL query statements. Java provides Statement, PreparedStatement, and CallableStatement to execute query statements. Statement is used for

Install and use mongodb

Install and use mongodb 1. Install and start MongoDB Widndows and linux are basically the same 1. Download the database, Mongodb-linux-x86_64-ubuntu1404-3.0.3.tgz: linux 2. decompress the file and place it in a proper location. Tar-vxf mongodb-linux-

Extended map and extended map of associated queries

Extended map and extended map of associated queries select one.*,tw.id sid,tw.catlevel slevel,tw.name sname,tw.code scode,thr.id tid,thr.catlevel tlevel,thr.name as tname, thr.code as tcode from tb_sort one join tb_sort tw on

JDBC connection pool with the best performance: HikariCP, jdbchikaricp

JDBC connection pool with the best performance: HikariCP, jdbchikaricp HikariCP claims to be the best-performing JDBC connection pool component. I have not carefully tested the specific performance, but from the perspective of its development, it

Total Pages: 1013 1 .... 154 155 156 157 158 .... 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.