JJB Blog

Posts Tagged ‘design’

Everything you need to know about designing MySQL InnoDB primary keys

22 October 2006 - 9 comments

There are two aspects of how MySQL/InnoDB use a table’s primary key on the file system that have important ramifications for the key’s design: The primary key determines the order in which the data is physically stored in the main data file, aka “the clustered index”. Another way of saying this: the main data file [...]