MySQL- Many-to-many query, suitable for common many-to-many query scenarios. In this paper, a business scenario of student course selection is simulated through the student table...
For services configured with monitoring, basic statistics for some methods are collected. DubboMonitor collects simple statistics on the collected data, such as the number of...
Given ACID and the four isolation levels in database transactions, let's take a look at locks in transactions. Lock in MySQL is the concurrency control...
1. Connector: the user establishes the connection, obtains the permission, maintains and manages the connection, TCP handshake notes: 1. The administrator's modification of the user...
Summary: Prior to MySQL 8.0, the Server layer and storage engine (such as InnoDB) each kept a copy of metadata (schema name, table Definition, etc.),...
This paper will briefly introduce what I know about MySQL based on my interview experience and recent review. The knowledge points covered may be relatively...
In the preface, we learned that The Buffer pool is a unique memory structure of InnoDB. We initially learned that data addition, deletion and modification...
Learning database is to learn how to communicate with database software,SQL language is used for programmers and database software to communicate language. MySQL: The open...
Mysql basic table design, common character set, sorting rules, time types, autoincrement primary key, page compression, unstructured storage, etc. Summary and summary
Install MySQL (MySQL8.0 is used here). Disable the firewall or enable port 3306. Primary library: 192.168.10.151 Secondary library: 192.168.10.152 1. Primary library [mater] Configuration change...
Json.stringify () and json.parse () have been added to MySQL 5.7 to support JSON data types. Previously, we could only store JSON.stringify() and json.parse (),...
Master-slave replication refers to transferring the DDL and DML operations of the master database to the slave database through binary logs, and then re-executing the...
Preface Today for you to introduce the MySQL lock related knowledge. This article is the default InnoDB engine unless otherwise specified, or if other engines...