Course2454
Course Introduction:This set of courses is based on the design concept and data structure of MySQL index, index usage scenarios, index classification, index usage scenarios, index performance analysis, query optimization, slow query of MySQL index, etc. It mainly describes the solution of MySQL index optimization. It is very suitable for students who have basic knowledge of MySQL or have certain work experience. The course explains how to solve the problem of slow large-volume queries, how to write an efficient SQL, how to optimize query statements, what is the implementation principle of indexes, how to optimize indexes... and many other difficulties and interview points in SQL index optimization.
Course5948
Course Introduction:How to tune SQL according to execution plan under massive data? How does the mysql index system cope with massive data storage? How to design a mysql index with excellent performance under massive data Full analysis of clustered index and non-clustered index of mysql Must-ask nouns in mysql index interview: table return, index coverage, leftmost matching How to optimize indexes for specific SQL scenarios
Course2336
Course Introduction:If you have any questions, please contact WeChat: Le-studyg; in-depth exploration of PHP source code and understanding of its internal working principles is the path to advancement for every PHP developer. This course will lead students to analyze the source code of PHP (php-src), and comprehensively analyze the underlying implementation of PHP from core language features to extension mechanisms. By analyzing the source code, students will gain an in-depth understanding of PHP's internal mechanisms, such as memory management, garbage collection, function calls, etc., thereby improving their understanding of PHP performance tuning and extension development. This course is suitable for developers who have a certain foundation in PHP and who want to deeply understand the internal principles of PHP and improve their technical level. Let us explore the source code world of PHP and uncover the mystery of PHP!
Course4188
Course Introduction:The basic detailed explanation is the first part of the DOM exploration series of courses, which introduces the basic knowledge of DOM in detail and comprehensively. First, let you understand how DOM is used in actual development through a case. Understand how to determine the node type of an element, master the inheritance hierarchy of element nodes, and the classification and rules of various element nodes. Lay a solid foundation for subsequent courses.
Course22957
Course Introduction:Functions of smarty template engine
2023-11-16 14:36:03 0 12 290
TYPO3 V11: "PHP warning: undefined array key", $this->request->getArguments() is empty
2023-11-12 21:35:09 0 1 362
Implement filters and pagination using Laravel Eloquent
2023-11-12 18:42:35 0 1 310
macOS Ventura causes failure to install 'mysql2' due to 'ld: library not found for -lzlib'
2023-11-11 08:40:10 0 2 360
How to use open primitive tag in next js 13?
2023-11-10 23:03:51 0 1 527
Course Introduction:1. Index type Index can be divided into B-Tree index and hash index according to the underlying implementation. Most of the time we use B-Tree index because its good performance and characteristics are more suitable for building high-concurrency systems. According to the storage method of the index, the index can be divided into clustered index and non-clustered index. The characteristic of a clustered index is that the leaf nodes contain complete record rows, while the leaf nodes of a non-clustered index only have all fields and primary key IDs. According to clustered index and non-clustered index, it can be further divided into ordinary index, covering index, unique index and joint index. 2. Clustered index and non-clustered index Clustered index is also called clustered index. It is not actually a separate index type, but a data storage method. The clustered index
2023-05-26 comment 01508
Course Introduction:Today's MySQL database column introduces the comparison between MySQL index and ElasticSearch index.
2020-10-09 comment 01461
Course Introduction:MySQL index types include normal index, unique index, full-text index, spatial index and hash index. Indexing methods are BTREE, HASH, and RTREE. Choosing the appropriate index type and method depends on the data type and query mode, such as using a normal index or a hash index for range searches, using a full-text index for full-text searches, and using a spatial index for spatial queries. Using indexes improves query speed, reduces data I/O, and enforces data integrity.
2024-04-22 comment 0410
Course Introduction:The difference between B-Tree indexes and Hash indexes in MySQL: 1. B-Tree indexes support the leftmost prefix matching principle, while Hash indexes do not; 2. Both MyISAM and InnoDB support B-Tree indexes, while Hash indexes Indexes are only supported by Memory and NDB engine indexes.
2020-06-28 comment 02386
Course Introduction:Clustered Index (ClusteredIndex) A clustered index constructs a B+ tree based on the primary key of each table, and the row record data of the entire table is stored in the leaf nodes. For example, let’s intuitively feel the clustered index. Create table t, and artificially allow each page to store only two row records (it is unclear how to artificially control only two row records per page): Finally, the author of "MySQL Technology Insider" obtained this tree through analysis tools The general structure of the clustered index tree is as follows: the leaf nodes of the clustered index are called data pages. Each data page is linked through a doubly linked list, and the data pages are arranged in the order of the primary key. As shown in the figure, each data page stores a complete row record, while in the index page of the non-data page,
2023-05-27 comment 01198