Can an InnoDB page contain data from different indexes?
0
votes
1
answer
37
views
(In this question, I assume that the data of a table is acťually an index (
PRIMARY
), so I don't differentiate between table data and column indexes)
I've compacted an "old" InnoDB table (via null ALTER TABLE), and observed the space taken by the indexes, before and after, via the mysql.innodb_index_stats
table.
The size decreased (for some indexes, significantly); this lead to a question: can a single InnoDB page contain data from different indexes?
Asked by Marcus
(390 rep)
Jul 30, 2017, 02:07 PM
Last activity: Jul 30, 2017, 10:12 PM
Last activity: Jul 30, 2017, 10:12 PM