This article is used to record the pits encountered in the process of using MySQL, continuously updated. 1. The first project was officially launched after...
In MySQL, index belongs to the concept of storage engine level. Different storage engines implement index in different ways. This paper mainly discusses the index...
In MySQL, we can use the EXPLAIN command to obtain information about how MySQL executes SELECT statements, including how tables are joined during SELECT statement...
Why do we need to learn mysql? The first database management system that computer majors learn is mysql. Large, medium and small Internet companies and...
This article is based on the MySQL master-slave replication example in another article, to use MyCat as database middleware, to achieve MySQL read and write...
2. Create the mysql installation directory and data storage directory. 3. Create mysql users and user groups. 4. Grant permission to the directory where data...
Recently some partners, often because of mysql installation problems, hit the confidence of learning. To this end, I have summarized a super detailed mysql installation...
Advantages: Fast data access speed Disadvantages: Data cannot be permanently stored in a file Advantages: Data is permanently stored Disadvantages: 1) Slower than memory operations...
Use other columns (non-primary keys) as search criteria: Each record in a single-linked list can only be traversed starting with the smallest record. Obviously, in...
First, figure out when to introduce automated testing. If you have a leader who doesn't understand automation, your implementation process can be messy. Before the...
In the section of data Structure and Algorithms -- index https://url.wx-coder.cn/O07eI, we discuss file indexes such as B+Tree, LSM-Tree and the basic algorithms of full-text...
Anyone with a background in databases should know that databases can use indexes to find data quickly. It is possible to further understand that indexes...
1. Index types In MySQL, indexes can be roughly divided into several types in terms of logic or field characteristics: common index, unique index, primary...
Recently, many friends asked me for some basic information about MySQL, so I went through the cabinet and found this MySQL summary notes summarized by...