[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