Shulou(Shulou.com)06/01 Report--

This article will explain in detail about InnoDB primary index tree and secondary index tree example analysis, Xiaobian think quite practical, so share to you as a reference, I hope you can have some harvest after reading this article.

We are discussing the InnoDB storage engine here, where data and indexes are stored in the same file student.ibd

Scenario 1: Primary key index tree

uid is the primary key, no index is added to other fields

select * from student;

If this is the query, this means the whole table search, traversing the leaf node list from left to right, accessing from small to large

select * from student where uid

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.