This article is compiled by Mr. Lai Zheng in the efficient operation and maintenance community 728 database salon sharing, Mr. Lai's topic is MySQL 8.0...
In a real development project, where an exposed interface often faces many requests, let's explain the concept of idempotence: Any number of executions has the...
Basic concept Dirty read refers to reading uncommitted changes from other transactions. The difference between unrepeatable reads and phantom reads is that unrepeatable reads focus...
First, DataBase knowledge DataBase is used for storing and managing data warehouse, its English word: DataBase, referred to as: DB. A database is essentially a...
Show processList and show full processList if blocked, kill id; The output from the processList command shows which threads are running, not just all the...
Mysql is divided into Enterprise edition and Community edition. The Community Office is an open source software licensed under the GPL and can be used...
Partitioning can solve query performance problems of large data tables, but staging is not a perfect solution. Understanding partitioning strategies and possible problems can help...
Original Po link https://blog.csdn.net/ThinkWon/article/details/106610789 summary 1 1, if there is a repeated abnormal, hope to catch exceptions, use the insert into 2
1. Data structure and index implementation Each InnodDB table has a clustered index, which is constructed using B+Tree. The data stored by leaf nodes is...
1. The first normal form 1NF is the atomicity of attributes, which requires that attributes have atomicity and cannot be decomposed again. Table: Field 1,...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) ERROR: Access denied for user 'root'@'localhost' (using password: NO) If it is Chinese standard...
Qunar real case sharing. Recently, a student in the group encountered a problem, saying that the database was killed by the service, no response, so...
SQL join SQL join Take you to quickly learn two tables of query statements, involving knowledge points: left join, left join, right join, right join,...
Transactions often appear in your business logic, today after small P's learning to write a summary here, there are incorrect welcome to point out what...
One-to-many, many-to-one, and one-to-one relationships exist between tables. Relationships between tables are maintained by primary keys and foreign keys. Foreign keys can be constrained by...
Percona Monitoring and Management (PMM) is an open source application dedicated to managing and Monitoring MySQL, MongoDB, PostgreSQL, ProxySQL, and AWS RDS performance
Previously we talked about MySQL database underlying data structure and algorithm, MySQL performance optimization some content. MySQL row locks and transaction isolation levels. This article...
Recently, some cloud activities, bought a server as usual learning and testing, the new machine is nothing, some common software installation is inevitable, so I...
Most of the top level services are web-based clients, server-side tools such as connection handling, authorization, security, and so on. The second layer is the...
Let's take a quick look at the logical architecture of MySQL. Layer 1: deal with client connection, authorization authentication, security verification, etc. Layer 2: Server...