Read Uncommitted is when changes made by a transaction can be seen by other transactions before a transaction has committed. Generally speaking, someone else's transaction...
1, index refers to database optimization, most interviewees first want to say is to create an index, but after digging, we often understand the index...
Today, the customer encountered a problem: the background processing was very slow due to the large amount of data for operation with multiple files. The...
Master/slave replication principle Binlog and relay Log. Bin log: binlog Records all data changes and can be used for local data recovery and primary/secondary synchronization....
Logs are an important part of the mysql database and record various status information during the running of the database. Mysql logs are classified into...
MySQL Experiment: Practice index on full column matching, left-most prefix matching, range query and other conditions and understand dirty read, magic read, etc. - Web...
Yes, I'm going to learn mysql in the middle of the night. Install website: https://www.mysql.com/downloads/ window reference, but must remember to modify the path, video...
Download from the official website of MySQL. Considering that the new version may not be compatible with the client, it is recommended to download the...
In this article we focus on the latest version of MySQL 8.0.25 about SQL basic elements table, column, function, aggregation, grouping, sorting and other elements...
The last article covered the basics of indexing, and this article continues with the actual practice of indexing optimization. Before getting into the field of...