General procedure for optimizing SQL statements The show status command counts the execution frequency of SQL statements. Syntax: Show status specifies a parameter to count...
Mysql database installation for developers, is we will inevitably face the problem, its installation process is not complex, and the network installation tutorial is also...
This article is for my notes management only. Avoid full table scan, dictionary. Greatly improve query data. The four features of database transactions can be...
1. Introduction We all know that when Using explain to analyze SQL statements, if Using index is found in the Extra column, the operation performance...
The introduction of Buffer Pool does improve the efficiency of data reading and writing. Of course, it also brings problems. My account balance is 200...
We have an overview of the issue of transaction view isolation. Today, I'll talk about index selectivity. Improve processing performance with index selection! Take you...
Common functions /* Concepts: encapsulate a set of logical statements in a method body, exposing the method name benefits: Hides implementation details and improves code...
We know that InnoDB supports transactions. So one of the functions of the transaction is to support rollback. Transactions can be designed to add, delete,...
Take notes on a couple of blog posts you've read recently about distributed transactions. Ha ha ~ database transactions (referred to as: transactions), is a...
Concurrency Control is a common concurrency control for database management systems. We know that concurrency control is often done with locks, which are a very...
MySQL instructions are basically divided into three categories: DDL(Data definition Language), DML(Data manipulation language), and DCL(Data Control language). DDL: the function of DDL directive is...
Indexes are implemented at the storage Engine level, not the Server level. Not all storage engines support all index types. Even if multiple storage engines...
~~ Bug is the natural enemy of programmers, and also the ladder of programmers' progress. ~~ Previously, some time ago, my colleague reported that another...
MySQL 8.0.17 MySQL 8.0.17 MySQL 8.0.17 MySQL 8.0.17 MySQL 8.0.17 MySQL 8.0.17 MySQL 8.0.17 Because there are more than 400 meters, it takes a little...
A transaction is a logical unit of DBMS execution consisting of a finite sequence of database operations. This series of rigorous operations must be completed...