MySQL storage engine architecture design, compared with other relational database management systems, such as Oracle,SQL Server and other databases, this is the biggest feature of...
This article hopes that the principles of database indexing will be helpful. The first part discusses the mathematical basis of MySQL database index in terms...
There are three steps for periodically backing up the database in the solution: schedule scheduler: Windows schedule scheduler, Linux Crontab scheduler and timers in programming...
Loss of "update in the database concurrency" usually should be completely avoided, but update to prevent data loss, and can't count on a database transaction...
The search process of binary search method is: the records are arranged in order, and the midpoint position of the sequence is the comparison object...
Describes the ACID properties underlying transactions, transaction control statements, four types of problems associated with concurrent transactions, and transaction isolation levels for dealing with concurrent...
Download download address: https://dev.mysql.com/downloads/mysql/ a, download the installation process is a condensed version, shear to the directory you want position, decompression. 2. Add the following...
Some time ago, the company encountered an internal problem, that is, the same batch of tasks we created were assigned to different instances to execute,...
This personal blog: https://www.leafage.top/posts/detail/20815YW6T when using the foreach, collection of attribute value three conditions: if the incoming parameter type for ar
Integrity Constraints To ensure the correctness and validity of the inserted data, a field in a table is added with other constraints besides the data...
MySQL query optimization can not use SELECT *, do not use NULL fields, create indexes properly, SELECT the appropriate data type for the field..... Do...
Varchar storage rules below version 4.0, vARCHar (20), refers to 20 bytes, if stored UTF8 characters, can only store 6 (3 bytes per character). Version...
What is a partition #### What is a partitioned table A partitioned table divides the data of the same table into multiple storage locations according...
MySQL is the most popular relational database management system and one of the best RDBMS(relational database management system) applications in WEB applications.