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...
Indexes depend on the implementation of storage engines, so each storage engine may not have the same index, and each storage engine may not support...
The string types of the MySQL database are CHAR, VARCHAR, BINARY, BLOB, TEXT, ENUM, and SET. Different types have completely different implications for business design...
Index is similar to the bibliographic index of university library, which can improve the efficiency of data retrieval and reduce the IO cost of database....
Many programmers see SQL as a threat. SQL is one of the few declarative languages that operates in a completely different way from command-line languages,...
First normal form (1NF) the so-called first normal form (1NF) refers to the database table each column is indivisible basic data items, the same column
Database r&d engineer, currently engaged in RadonDB MySQL Kubernetes research and development, keen on database kernel, K8s related technology. > > Zhang Limei > >...
MySQL's built-in replication capabilities are the foundation for building large, high-performance applications. To distribute MySQL data to multiple systems, this distribution mechanism is achieved by...
Concurrency Control for multi-version Concurrency Control When accessing (read or write) a database concurrently, manage multiple versions of the data being processed within a transaction...
This article focuses on the key differences between MySQL storage engines InnoDB and MyISAM, as well as the application scenarios of each storage engine.
In the back-end development, we will inevitably encounter the situation of concurrent update of MySQL data. As a back-end developer, how to solve this kind...
MySQL provides the explain keyword to simulate the optimizer's execution of SQL statements, so that you know how MySQL is executing SQL statements, so that...