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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>

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 >>