| InnoDB clusterd Index databasedesign [message #3221] |
Wed, 25 June 2008 14:33  |
erkules Messages: 58 Registered: December 2007 |
Member |
|
|
Playing around with InnoDB, i wonder for tips how to design tables for InnoDB.
Are there some special things you can recommend?
|
|
|
| Re: InnoDB clusterd Index databasedesign [message #3306 is a reply to message #3221 ] |
Wed, 16 July 2008 07:22  |
Speeple Messages: 91 Registered: August 2006 |
Member |
|
|
Try to get the most out of your primary key and/or keep the PK small because for each additional index substantially more space will be used for including the PK.
Martin Gallagher | Speeple: The latest news
|
|
|