Mysql > select * from Users where id=1; update Users where id=1; Mysql then creates a thread processing through the SQL interface, interpreter, optimizer, executor,...
MongoDB and MySQL are both good databases with excellent performance. Their application scenarios are different. This article explores the features and differences between the two...
Preface In this article, I summarized the development process of the most common several MySQL thrown exceptions and how to solve the problem, including high...
Canal positioning: based on database incremental log parsing, provides incremental data subscription & consumption, currently mainly supports mysql. Canal simulates the mysql slave protocol and...
Preamble functions encapsulate common functions in a function definition, and execute encapsulated code logic through function calls. Function has strong functionality and reuse. As a...
Database, is a collection of files, is composed of a data file; Database instance, is a program, the user program through the database program (that...
MySQL database is a relational database management system, which is a popular open source database system in the server field. At present, Oracle company is...
The atomicity of database transactions is guaranteed by undo rollback log. This paper introduces the mechanism of Undo log and the version chain formed by...
DDL is used to manipulate objects and properties of objects, including the database itself, as well as database objects such as tables, views, and so...
The previous article briefly introduced MySQL's transaction isolation levels, which are read uncommitted, read committed, repeatable reads, and serialization. In this article we will explore...
We are all familiar with mysql database service architecture and SQL execution sequence. Mysql data storage structure in disk and memory uses B+ tree data...
Operational database A database is an organized and shareable collection of data stored in a computer for a long time. SHOW DATABASES; Creating a database...
(1) B tree has multiple layers, each layer has multiple nodes, each layer node contains multiple elements, each element contains key and value, and different...