… performed. But InnoDB‘s adaptive hash indexes require that the prefix is stored in every record R. An adaptive hash index tries to guess… Innodb secondary Indexes trees are allocated in two extents same as primary key tree or stored in the same extent ? HT: An InnoDB extent is a contiguous block of 64 pages, 16 kB each. Each B-tree index in InnoDB…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…about using solid state disks for storing ib_log* files; I know that innodb writes files in the log… facility we can run to show any table / index fragmentation, without having to run the OPTIMIZE? HT:… of the PRIMARY KEY, then InnoDB should have placed the rows in contiguous blocks of 64 pages == 1 …
