New Foreign Keys in 6.1

Konstantin Osipov (MySQL), Peter Gulutzan (MySQL AB)
Architecture and Technology
Location: Ballroom F

A new standard conforming and engine-neutral implementation of foreign keys is being developed for 6.1 version of server.

During this session we will cover features supported by this new implementation such as column references, recursive relationships and checks done as if they happen at the end of statement.

We will also discuss how different levels of foreign key support depend on engine capabilities (e.g. we will look at differences between transactional and non-transactional engines).

Then we will compare new and old, InnoDB-specific implementation and discuss the migration process and possible issues which may arise during it.

Next thing we will look at is performance impact of new foreign keys (as compared to case when there are no foreign keys and case when one has old foreign keys).

Finally we will discuss possible future development in this area such as possible optimizations of foreign key checks and support of foreign keys for distributed engines (NDB or Federated).

Photo of Konstantin Osipov

Konstantin Osipov

MySQL

Konstantin Osipov has been a software engineer and engineering lead at MySQL since 2003. His main areas in the server are locking, parsing, execution of prepared statements and stored procedures. He was the implementer of support for Dynamic SQL in 5.0. In his other life Konstantin is a Moscow dweller with a not uncommon combination of such hobbies as yoga, running, and computers.

Photo of Peter Gulutzan

Peter Gulutzan

MySQL AB

Architect for many of the newer MySQL server features since 2003.

Member of ANSI SQL Standard Committee in 2009.

Co-author of four computer books

Co-presenter of MySQL User Conference 2009 session on New Foreign Keys in 6.1

From Edmonton.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.