At present, the database is the basic component for data storage in most systems. The efficiency of the database has a vital impact on the stability and efficiency of the system; in order to have a better user experience, the optimization of the database is extremely important. So from what aspects should we optimize our database? Let us discuss and learn together in the course "Boolean Education Yan 18 MySQL Optimization Video Tutorial"!
Course playback address: http://www.php.cn/course/200.html
This video is created by Bull Education Yan Shiba. The teacher’s teaching style is:
The teacher’s lectures are vivid and witty Witty, witty and touching. A vivid metaphor is like the finishing touch, opening the door to wisdom for students; an appropriate humor brings a knowing smile to students, like drinking a glass of mellow wine, giving people aftertaste and nostalgia; a philosopher's aphorisms, cultural references Proverbs are interspersed from time to time in the narration, giving people thinking and warning.
The more difficult point in this video is the clustered index:
The clustered index reorganizes the actual data on the disk to specify one or more An algorithm for sorting the values of a column. The characteristic is that the order of storing data is consistent with the order of indexing.
Generally, the primary key will create a clustered index by default, and only one clustered index is allowed to exist in a table.
The difference between clustered index and non-clustered index is explained in the book "Database Principles":
The leaf nodes of the clustered index are the data nodes, not the leaf nodes of the clustered index. It is still an index node, but it has a pointer to the corresponding data block.
Therefore, it is easy to explain that different data storage engines in MYSQL have different support for clustered indexes.
But this definition is too abstract. In SQL Server, the index is described through the data structure of a binary tree. We can understand the clustered index this way: the leaf nodes of the index are the data nodes. The leaf nodes of non-clustered indexes are still index nodes, but have a pointer pointing to the corresponding data block.
Here we also recommend downloading source code resources: http://www.php.cn/xiazai/learn/1842
The resources are shared with you. Video courseware and ppt:
mysql optimization.ppt
MySQL optimization notes-organized version.doc
The above is the detailed content of Boolean Education Yan Shiba MySQL Optimization Video Courseware Source Code Sharing. For more information, please follow other related articles on the PHP Chinese website!