Comments on: The depth of an index: primer https://shlomi-noach.github.io/blog/mysql/the-depth-of-an-index-primer Blog by Shlomi Noach Tue, 04 May 2010 06:46:06 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Reducing locks by narrowing primary key | code.openark.org https://shlomi-noach.github.io/blog/mysql/the-depth-of-an-index-primer/comment-page-1#comment-13065 Tue, 04 May 2010 06:46:06 +0000 https://shlomi-noach.github.io/blog/?p=545#comment-13065 […] the fact that a bloated PRIMARY KEY bloats the entire clustered index and secondary keys (see: The depth of an index: primer), it is also a source for locks. It’s true that any UNIQUE KEY can serve as a PRIMARY KEY. […]

]]> By: The Depth of a B-tree | Tokutek https://shlomi-noach.github.io/blog/mysql/the-depth-of-an-index-primer/comment-page-1#comment-6334 Mon, 09 Nov 2009 15:37:36 +0000 https://shlomi-noach.github.io/blog/?p=545#comment-6334 […] Noach recently wrote a useful primer on the depth of B-trees and how that plays out for point queries — in both clustered indexes, like InnoDB, and in […]

]]>