High-availability installation of Redis in CentOS

High-availability installation of Redis in CentOSHigh-availability installation of Redis in CentOS [x] environment Introduction: Master: T1 Slave: T2 VIP: 192.168.68.45 [X] installing Redis (Master, Slave) Note: The flushall modification before

Performance of MariaDB 10.1 and MySQL 5.7 on common commercial hardware

Performance of MariaDB 10.1 and MySQL 5.7 on common commercial hardware When you read my previous article about MariaDB 10.1 GA performance, you may be confused why I haven't mentioned MySQL 5.7 words. There are two reasons: First, MySQL was not GA

What happens to MySQL when the disk space is full?

What happens to MySQL when the disk space is full? Guide What happens to MySQL when the disk space is full? What should I do? What will happen When the disk space is full, MySQL cannot write any data, including writing data to the table and

Oracle tree query start with connect

Oracle tree query start with connect I. IntroductionIn Oracle, start with connect by (prior) is used to query data in a tree structure. Here, start with conditon gives the range of data searches, and connect by gives the conditions for Recursive

Analysis on Causes of slow sorting SQL upgrade to MySQL 5.6

Analysis on Causes of slow sorting SQL upgrade to MySQL 5.6 Background:After a service DB is upgraded from MySQL 5.5 to MySQL 5.6, the same SQL Execution time has soared from milliseconds to 20 seconds. The SQL text is as follows:Select * from

Transaction design strategies for MongoDB, Cassandra, and HBase

Transaction design strategies for MongoDB, Cassandra, and HBase NoSQL databases (such as MongoDB, Cassandra, Hbase, DynamoDB, and Riak) make application development easier. They provide quite flexible data models and rich data types, and are easier

Linux Oracle deletes archive logs

Linux Oracle deletes archive logs Oracle reported this error today: ORA-00257 Check that the archive logs of Oracle are full. Solution: Two 1. Increase the archive log size. 2. Delete useless archive logs. (select this solution) In Linux:

Oracle RMAN repairs logical Bad blocks

Oracle RMAN repairs logical Bad blocks RMAN implements block recoveryThe trial of Rman can achieve block-level data recovery. In the traditional restoration method, that is, a data block of a data file is damaged, the entire data file cannot be used

MySQL (ICP) index push-down comparison with Oracle

MySQL (ICP) index push-down comparison with Oracle The first time I saw this term, I thought of it together with Oracle FPD-filter push-down, but later I found that they were just the same thing, when an index contains all the access fields, you can

Percona MySQL5.6 semi-synchronous Replication

Percona MySQL5.6 semi-synchronous Replication Configure normal clone first Two servers, one master and one slave Master Server: 10.10.1.30 Slave: 10.10.1.200 Modify the my. cnf file of each machine and the server_id Master server server_id = 1,

SQL statement used by MySQL to query duplicate table data

SQL statement used by MySQL to query duplicate table data MySQL queries duplicate data in a table. For example, to query records with duplicate bar codes in the table, the SQL statement is as follows: SELECT GUIDE_BARCODE FROM checker_barcode

Accelerate mydumper and myloader Export and Import

Accelerate mydumper and myloader Export and Import Mydumper and myloader are excellent third-party mysql database logical backup and recovery tools that use multi-thread export and import. Makes up for the insufficiency of mysqldump single thread.

Oracle GoldenGate introduction and installation configuration tutorial

Oracle GoldenGate introduction and installation configuration tutorial Introduction to Oracle GoldenGate GoldenGate is a log-Based Structured Data replication software. GoldenGate can capture, transform, and deliver a large amount of transaction

The SQL statement used to query the data between the nth and NTH rows in the database in SQL SERVER.

The SQL statement used to query the data between the nth and NTH rows in the database in SQL SERVER. When writing a program today, You need to generate an SQL statement from the start id to the end id. This function is not required now. In SQL

In-depth explanation of batch row-column conversion in SQL, sqlbench

In-depth explanation of batch row-column conversion in SQL, sqlbench Rotate rotate the table value expression by converting the unique value in a column of the expression to multiple columns in the output, and aggregate the values of any other

Error code: 1100 Table 't_ depart_info 'was not locked with lock tables, tableoftables

Error code: 1100 Table 't_ depart_info 'was not locked with lock tables, tableoftables Analyze the cause of error code generation step by step. Be patient. Step 1: Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: insert

What are the integrity constraints of database design?

What are the integrity constraints of database design? What are the integrity constraints of database design? Here are four aspects: 1. Domain integrity:The columns in the database table must meet certain data types or constraints. The

How to use SQL select distinct, selectdistinct

How to use SQL select distinct, selectdistinct Duplicate values may exist in the table. This is not a problem. However, sometimes you may want to list only different values. The keyword distinct is used to return a unique value. Table: Example 1

What are the types and features of database indexes?

What are the types and features of database indexes? It effectively optimizes the VPS performance and increases the running speed of the VPS server. In addition to configuring the WEB Server properly, we need to be able to optimize our website

Another Implementation Method for SQL like clauses (faster than like), like clauses

Another Implementation Method for SQL like clauses (faster than like), like clauses Generally, when fuzzy search is used, you will think of LIKE Select * from table where a like '% character %'If an SQL statement uses multiple like fuzzy queries and

Total Pages: 1013 1 .... 88 89 90 91 92 .... 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.