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).
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.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at email@example.com
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.