Labels: index

brief introduction Migration is like database versioning, which allows teams to define and share database schema definitions for applications. If you ever told a teammate that after pulling your changes from source control

Because the hash table is unordered, while the underlying layer of the regular Redis collection (not the IntSet implementation) is based on the hash table, it is also unordered. In order to make the collection elements become

Primer The previous college introduced the data structure and practical application of Redis through the system of more than 20 tutorials. Starting from today's tutorial, let's go deep into Redi

Review of basic theories In the previous tutorials, Xuejun has successively demonstrated the performance optimization of single table query, statistical query, associative query and fuzzy matching in Larave database

Next, let's look at an example of fuzzy matching query optimization. The so-called fuzzy matching is LIKE query. The basic principles of LIKE query optimization are as follows:

In front of you, I will give you an overall introduction from the overall architecture of the server side to InnoDB index, transaction and database high availability through 32 tutorials

What are the unexpected problems online In the daily maintenance of websites or applications, you may encounter some MySQL sudden performance problems: for example, a slow query will drag down the entire database, leading to the core

In the previous tutorials, Xuejun has introduced how to optimize based on indexes in MySQL for full value matching, range matching, paging, sorting, grouping, and join queries

Basic usage of connection query MySQL is called relational database because the association between data tables can be established through foreign keys. In the actual project development, the number in the database

When we perform daily SQL queries, we often use additional constraints such as LIMIT and ORDER BY to filter the result set, so that the returned results meet our expectations

In the last tutorial, you introduced the use of database indexes in full value matching queries, as well as the underlying principle and practical application of the leftmost prefix principle. Today, let's continue to look at another common database query

In the last tutorial, you will show us two data table initialization methods. Because the use of stored procedures is faster, this method is recommended for data filling. Next, let's analyze different types of

brief introduction Larravel Scout provides a simple, driver based solution for the implementation of Eloquent model full-text search. By using model observers, Sc

brief introduction Migration is like database version control. This mechanism allows teams to easily edit and share the database table structure of applications. Migration is usually the same as Laravel's Sc

Review of B+Index Tree In the last tutorial, Mr. Xuejun introduced how to maintain the B+tree corresponding to different types of database indexes, which is actually the bottom layer when updating database table records