InnoDB Sessions at the 2008 MySQL User Conference

April 13th, 2008

Heikki Tuuri, CEO and Founder of Innobase, and Oracle’s Ken Jacobs will be presenting at the MySQL User
Conference in Santa Clara, California, Monday–Thursday, April 14-17, 2008. Several sessions are devoted to InnoDB and the new InnoDB Plugin. Please attend these sessions to get the latest information about InnoDB:

  • Tuesday 2:00–3:00 InnoDB: Status, Architecture, and New Features
    Heikki and Ken will present details about the latest version of InnoDB – the InnoDB Plugin 1.0 for MySQL 5.1. Be sure to attend this session describing the features, benefits and use of the new InnoDB Plugin, and learn how it can deliver better performance, reliability, flexibility and ease of use. Download the presentation here.
  • Tuesday, 04/15/2008 4:25-5:130 InnoDB: Fast, Reliable, Proven Transactional Storage for MySQL
    You’ll want to come to this session if you’re just starting to learn about MySQL and its storage engines. If you’re new to MySQL, new to transactional applications, or wondering about how InnoDB compares to other emerging storage engines, this session is for you. Ken Jacobs will describe the features, architecture and benefits of InnoDB. Your business can depend on reliable, fast, and proven transactional capabilities. Make the right decision for your application! The presentation is available
    here.
  • TBD: Birds of a Feather
    Meet and greet fellow InnoDB users for a lively and wide-ranging discussion about technology and directions for InnoDB. At this BoF session, you and fellow InnoDB users will have an opportunity to network with one another, discuss best practices, and raise technical questions about how InnoDB works. Heikki and other InnoDB developers will be on hand to answer your most probing questions about how InnoDB works. This will be your best opportunity to learn more about the new InnoDB Plugin, and its new features and benefits.

Also be sure to attend the following sessions regarding InnoDB:

  • Tuesday 3:05-3:50 Investigating Innodb Scalability Limits
    Peter Zaitsev and Vadim Tkachenko of MySQLPerformanceBlog.com
    will discuss InnoDB and scalability. Find out what limitations have been solved in MySQL 5.0 and MySQL 5.1 versions.
    In this presentation, Peter and Vadim will look at several workloads and investigate how different versions behave on different operating systems and hardware.
    They will look at scaling in terms of CPUs as well as efficient use of multiple hard drives which can be a bottleneck for disk bound systems.
  • Thursday 10:50-11:50 Optimizing MySQL and InnoDB on Solaris 10 for World’s Largest Photo Blogging Community
    Farhan Mashraqi from Fotolog will describe how Fotolog depends on InnoDB for its business. Fotolog is a top 19 Internet destination with more than 12 million members, 315 million photos and more than 3 billion page views a month. In just a few years Fotolog has become a social phenomenon in Europe and South America. Through modifications to its data architecture, Fotolog was able to serve four times the number of users using the same number of database servers. A non-conventional, hybrid presentation that conveys the importance of scalability, performance tuning and schema optimizations in a practical way.
  • Thursday 2:00-2:45 Scaling Heavy Concurrent Writes In Real Time
    Dathan Pattishall of Flickr will describe how MySQL and InnoDB scale to meet the demands this leading online photo management and sharing application.
    Flickr implemented a real-time collection of referrers to Photos, streams, sets and collections. Currently the data is gathered real time for every single user on Flickr. The data is then cooked and reported with a 24 hour lag for filtering out referrer SPAM. MySQL myISAM, InnoDB, curl, Java are the only components used in the setup and it scales linearly. This talk is about building a model for capacity planning, scaling for triple the request rate, and scaling linearly for an intensive application.
  • Thursday 11:55-12:40 Helping InnoDB Scale on Servers with Many CPU Cores and Disks
    Mark Callaghan of Google describes performance improvements in InnoDB to improve scalability on systems with many CPU cores and many disks. He will describe the performance problems in the official release and fixes for the problems that have been developed by InnoDB, Google, and the MySQL community.
  • Wednesday 5:15-6:00 Deadlocks, Wait Timeouts, and Other Transaction Issues
    Jess Balint of MySQL will discuss advanced issues in dealing with transaction processing.
    Most application developers have no problem handling the basics of transactions in their applications. However a number of issues can be encountered and these are usually missed during development. This session aims to deepen understanding of transaction processing and show how to properly deal with transactional issues.
    After examining the details of transaction conflicts, we will look at example error handling routines and review how the application can be affected. Finally some specific details of transaction processing in InnoDB and Falcon will be compared.