MySQL Connect Only 25 Days Away, Focus On InnoDB Sessions
By Bertrand Matthelie-Oracle on Aug 27, 2013
You can check out the program in our content catalog as well as via a new Focus on MySQL Connect document listing all sessions with time and location. If you’d like to expand your InnoDB knowledge, below are the sessions specifically focused on InnoDB (although others such as performance tuning may also of course cover InnoDB topics):
InnoDB New Features in Version 5.6 - Sunny Bains, Oracle
Saturday, 2.30 pm, Union Square Room 3/4
This session covers the new InnoDB features and their benefits, including:
• Resize REDO
• Transportable tablespaces
• Online data definition language (DDL)
• Running InnoDB from read-only media and sharing datafiles
• Full text index
• memcache—using InnoDB as a NoSQL store
InnoDB: Table and Index Data Structures Architecture - Davi Arnaut, LinkedIn
Saturday, 4.00 pm, Imperial Ballroom A
InnoDB is the storage engine behind most busy MySQL databases in the world. How does it store and organize data? How does it manage free space? How does it retrieve rows? This presentation dissects InnoDB’s internal storage format and digs into how data pages are organized, stored, and accessed. It aims to provide an overview of the main on-disk data structures such as tablespaces, indexes, extents, pages, and records. After this session, you will be able to answer questions such as: How many bytes would it take to store rows in a particular schema? How does indexing affect storage? What expected and unexpected inefficiencies might you run into?
The InnoDB Buffer Pool and I/O: How It All Works - Sunny Bains, Oracle
Sunday, 10.00 am, Imperial Ballroom B
How do I tune my InnoDB instance? When and for what should I use a solid-state drive to get the best value? Where should I place the files? What I/O settings should I use for the best throughput? What are various types of flushing? How can I tune and control flushing? What is a checkpoint in InnoDB? What is the relationship between redo logs and the buffer pool? What instrumentation do I need in order to know if my system is properly tuned? If you’ve ever struggled with such questions, this session is for you. Hear InnoDB engineers discuss the I/O architecture and how to use InnoDB to the max.
MySQL As a NoSQL Store with the InnoDB/memcached Plug-in – Jimmy Yang
Sunday, 1.00 pm, Powell
In this session, you will learn how to leverage MySQL/InnoDB as a NoSQL store. The data can be accessed with traditional SQL and also as a key/value store. The presentation focuses on architecture, best practices, and future directions so that users can make use of this flexibility and use a single server for both types of access.The best of both worlds.
InnoDB Full Text Index– Jimmy Yang
Sunday, 2.30 pm, Powell
This session covers the InnoDB full text index in version 5.6. The InnoDB FTS architecture is very different from that of MyISAM. The full text index is implemented on a transactional engine (as compared to other common full text engines). It is better designed for processing and querying big data natively and comes with far better scalability than that of MyISAM. It also comes with some inherited differences from MyISAM. Thus it is important for users to pay attention in order to avoid migration issues. The presentation discusses the ongoing work on and some future plans for the feature.
Birds-of-a-Feather: Meet the InnoDB Team
Saturday, 5.30 pm, Imperial Ballroom B
Join Oracle's InnoDB engineers in this BOF to ask all your questions and discuss any and all InnoDB matters.
MySQL Connect is going to be an exciting conference, don't miss it!