Articles under the 'Back End' tag
Mysql Online DDL
About Online DDLDDL(Data Definition Language), that is, the data definition language, including new table, table add fields, change fields and other operations.Large table DDL at will execute dozens of minutes, even a few hours, such a long time to lock the table for the business is obviously unacce
...
More >>
2023-07-17
Back End
/
Mysql
CAP Theorem
The CAP theorem is a common criterion used by engineers to measure the design of distributed systems. The CAP theorem holds that a network-based data sharing system can only satisfy at most two of the three elements of data consistency, availability, and partition tolerance; during the system design
...
More >>
2023-07-11
Back End
/
CAP
Redis Big Key Problem: Causes, Impacts, and Solutions
1. What is the Redis big key problem?The Redis big key problem refers to a situation where a key in Redis has a value that consumes a significant amount of memory, leading to performance degradation, insufficient memory, data imbalance, and delayed master-slave synchronization, among other issues.Wh
...
More >>
2023-07-03
Redis
/
Back End
/
key
How Is an SQL Query Statement Executed?
Overview of mysql infrastructureMySQL can be divided into two parts: the server layer and the storage engine layer.
The Server layer includes connectors, query caches, analyzers, optimizers, executors, etc., including most of MySQL’s core service functions, as well as all built-in functions (such as
...
More >>
2023-06-19
Back End
/
MySQL
ChatGPT becomes a powerful tool for hackers to write malware!
Since the launch of ChatGPT, it has generated a lot of attention in tech circles, but there are also many researchers who are concerned that generative AI, while popularizing AI, will also popularize cybercrime.
This fear is not without merit, and in some hacker forums, security researchers have obs
...
More >>
2023-02-03
Back End
/
ChatGPT
/
AI
/
Python
Illustration of how Git works
This article illustrates the most common commands used in Git. If you have a little understanding of how Git works, this article will help you understand it more thoroughly.
Basic usage
The four commands above copy files between the working directory, the staging directory
...
More >>
2022-12-12
Back End
/
Front End
/
Git
Talking about database row and column storage
A good number of people first learn about databases as relational databases, where data is stored in tables, with one row representing one record. In fact, this is a typical Row-based store, which stores tables on disk partitions by rows.
And some databases also support Column-based st
...
More >>
2022-12-08
Database
/
Back End
/
Storage
Distributed system design patterns, which ones have you used?
1.Bloom filter
Bloom filter is a space-saving probabilistic data structure for testing whether an element is a member of a collection or not. It is used in scenarios
...
More >>
2022-11-22
Design pattern
/
Back End
/
Front End
/
Distributed system
What exactly is code neatness?
Write in frontThis article was not intended to write, until after several code review meetings, I realized that their own coding way is not systematic, still need to learn systematically, mastering the most applicable laws summed up by seniors is undoubtedly a good way. It so happens that a long tim
...
More >>
2022-11-10
Back End
/
Front End
/
Clean Neatness
Go will enhance Go1 backward compatibility!
Go1 Compatibility Guarantee
In Go1, the Go Compatibility Guarantee [Go 1 and the Future of Go Programs] ,was introduced, meaning that older versions of Go programs will also work correctly in newer versions that continue with Go. Of course, there are exceptions to this, such as security iss
...
More >>
2022-11-03
Go
/
Back End
/
Go1