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.