Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » InnoDB clusterd Index databasedesign
InnoDB clusterd Index databasedesign [message #3221] Wed, 25 June 2008 14:33 Go to next message
erkules is currently offline 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?
Report message to a moderator
Re: InnoDB clusterd Index databasedesign [message #3306 is a reply to message #3221 ] Wed, 16 July 2008 07:22 Go to previous message
Speeple is currently offline 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
Report message to a moderator
Previous Topic:Com_admin_commands extremely high (90%) - what's going on?
Next Topic:Multiple categories and index problems
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 04:02:24 EDT 2009

Total time taken to generate the page: 0.11513 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.