MVCC is multi-version concurrency control. When performing SELECT queries at RC and RR isolation levels, the version chain of records is accessed without locking. This...
MySQL lock summary. Excerpt from each network platform, most of the original author, a few forgotten. MySQL lock summary. Excerpt from each network platform, most...
Students working in Party B are always faced with particularly bizarre questions. As I am engaged in database training and consulting services, sometimes I also...
Since MySQL5.5, MySQL has supported semi-synchronous replication. Semi-synchronous replication is between asynchronous replication and synchronous replication. The master database does not immediately return the results...
Mysql database names are alphanumeric underscores (_) and cannot start with a number. 2. SQL Library operations 2.1 Added basic syntax library options for the...
In our daily work, backup data is actually one of the important work of information security management. In this article, we will cover database backup...
The KeyTakeAwaysInnoDB engine has three AutoIncrement lock modes: Innodb_AUTOINC_LOCK_mode =0 (traditionallockmode) : Obtains the table lock, and the statement execution ends
The federated Query Optimizer view builds a query execution tree with minimal completion cost. If possible, it starts with a full single-table plan and examines...
The RedHat system automatically configures yum. 6. X system yum install MySQL, install 5.1, so you need to manually change the yum information. Repo :mysql-community....
1/ Why create index 2/Mysql index is divided into: 3/ What is single-column index and multi-column index 4/ Common commands about index 5/ Understand singleton...
In March 2018, children released a booklet entitled how MySQL Works: Understanding MySQL from the Root on the Nuggets Platform. This booklet is the first...
In all kinds of technical job interviews, it seems that MySQL related questions are frequently asked. Whether you're interviewing for a development role or an...
Mysql has three lock levels: page-level, table-level, and row-level. Table lock: low overhead, fast lock; No deadlocks occur; The lock granularity is large, and the...
The key core of designing statistical tables is the business type. For tables with low update frequency and small data volume, real-time synchronization or direct...
Go-mysql-elasticsearch is a service that automatically synchronizes mysql data to ElasticSearch. It first uses mysqldump to get the raw data, and then incrementally synchronizes the...
The Lock tables operation can be released either actively using UNLOCK Tables or automatically when the client is disconnected. MDL is automatically added when accessing...