[redis series] redis learning 7. Details of redis configuration files you don't know

Detailed explanation of Redis configuration file Company When redis is started, it will read the configuration file redis conf 1k => 1000 bytes 1kb => 1024 bytes 1m => 1000000 bytes 1mb => 1024*1024 bytes 1g => 1000000000 bytes 1gb => 1024*1024*1024 bytes Units in redis are not case sensitive. For example, 1GB, 1GB and ...

Posted by marting on Sun, 06 Mar 2022 12:11:18 +0100

Mysql learning notes

first day 1. What is a database? What is a database management system? What is sql? What is the relationship between them? Database: The English word DataBase is called DB for short. A combination of files that store data in a format. As the name suggests: a warehouse for storing data is actually a pile of files. These files store data in a spe ...

Posted by andrewmay67 on Sun, 06 Mar 2022 12:07:50 +0100

Custom SQL collection metadata using graphite

Grabit yes Salmon data kinship analyzer It collects SQL scripts from various data sources and then uploads them to salmon for data kinship analysis. The analysis results can be viewed in salmon. At the same time, the data kinship results will be extracted into the local directory. At present, grab supports two modes of operation: graphical int ...

Posted by shiva on Sun, 06 Mar 2022 10:37:04 +0100

Interpretation of mysql source code -- transaction management

1, Transaction What is a transaction? According to the book, it is a set of operations of the system. In order to maintain the integrity of data, it must comply with the characteristics of ACID, namely atomicity, consistency, isolation and Durability. Atomic ity is easy to understand. Operations are either fully executed or not fully executed. ...

Posted by robinas on Sun, 06 Mar 2022 07:59:06 +0100

Using vscode to develop C + + programs on linux platform (including cmake and gdb)

The main purpose of writing this blog is to record the following knowledge points, and then introduce its concept and usage one by one. 1. Recognize and use vscode 2. Use g + + to compile and run a multi file C + + project 3. Compile a multi file C + + project with cmake 4. Compile, run / debug a multi file C + + project on cscode 5. Use gdb to ...

Posted by .-INSANE-. on Sun, 06 Mar 2022 07:44:29 +0100

Redis cluster usage example

Today, I learned about the use of redis cluster. Here, I will record the problems encountered in the process 1, Environment construction (docker needs to be installed first) Here, docker will be used to deploy four redis instances (node1-3 as the primary node and node4 as the standby node of 1) Here, four redis instances are deployed on th ...

Posted by drag0n on Sat, 05 Mar 2022 16:34:21 +0100

MySQL MMM high availability cluster

1, Overview of MySQL MMM cluster technology; Overview: MMM (Master Master replication manager for mysql) is a script program that supports dual master failover and dual master daily management. MMM is developed in Perl language and is mainly used to monitor and manage mysql master master replication. It can be said to be mysql master replicati ...

Posted by SocomNegotiator on Sat, 05 Mar 2022 15:59:12 +0100

MySQL notes: Chapter 08_ Aggregate function

Note: this content is compiled from the MySQL video of Shangshan Silicon Valley Station B >>MySQL video of Shangsi valley station B The previous chapter talked about SQL single line functions. In fact, there is another kind of SQL function, which is called aggregation (or aggregation, grouping) function. It is a function that summari ...

Posted by rcarr on Sat, 05 Mar 2022 15:50:16 +0100

redis breakdown, avalanche and penetration solutions

Redis breakdown Redis cache breakdown refers to the sudden failure of a very hot key (i.e. more keywords searched on the client). At this time, a large number of requests sent from the client cannot find the key in redis, they will find it in the data, and eventually lead to excessive pressure and collapse of the database. Solution: 1. Set th ...

Posted by foreverhex on Sat, 05 Mar 2022 15:46:02 +0100

MySQL data type

Transfer from Explain MySQL data types in detail , the content is slightly modified. integer data type Number of bytes Signed minimum Signed maximum Unsigned minimum Unsigned maximum TINYINT 1 -128 127 0 255 SMALLINT 2 -32768 32767 0 65535 MEDIUMINT 3 -8388608 8388607 0 16777215 INT 4 -2147483648 2147483647 0 4294967295 BIGINT 8 ...

Posted by Dogrox on Sat, 05 Mar 2022 10:33:48 +0100