All the sessions for all the MySQL Camp days can be seen at, but here is today’s schedule in a nutshell (all sessions in Bayshore, on the mezzanine level of the hotel):
Tuesday 10:50 am – 11:35 pm
Matt Yonkovit (Sun/MySQL, Waffle Grid, Big DBA Head, [blog]) presents Learning from others’ MySQL Performance Mistakes. Matt has spent the last couple of years helping customers who are all dealing with the same MySQL related problems over and over again. During this session he will give you some of the most common issues in MySQL deployments he sees on a day to day basis, and how to fix or avoid them. These include:
* More is not always better
* Text Fields are not cool
* Data Size does matter
* Fun with Data Conversions
* Its all about IO
* Left join love
* Self Induced fragmentations
* MySQL is not Oracle
and more!!!! Come and join the fun.
Tuesday 11:55 am – 12:35 pm
Intro to XtraDB, a Scalable InnoDB-based Storage Engine Ewen Fortune (Percona)
XtraDB is a storage engine for MySQL based on the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a drop-in replacement for standard InnoDB.
XtraDB includes all of InnoDB’s robust, reliable ACID-compliant design and advanced MVCC architecture, and builds on that solid foundation with more features, more tunability, more metrics, and more scalability. In particular, it is designed to scale better on many cores, to use memory more efficiently, and to be more convenient and useful. The new features are especially designed to alleviate some of InnoDB’s limitations. Vadim will talk about current status of XtraDB and directions of development.
Tuesday 2:00 pm – 2:45 pm
Roland Bouman will present a session on Grand Tour of the Information Schema and its Applications
The following topics will be covered:
Introduction of the information schema and it’s components
How to generate WIKI documentation from the information schema
Generating code (triggers, SPs) to maintain a rich history database
Creating a stored procedure to check violated foreign key constraints
Creating a stored procedure to create federated tables
Tuesday 3:05 pm – 3:50 pm
Setting up MySQL on Amazon Web Services (AWS)
Ronald Bradford, Principal at 42SQL will step you though getting started with AWS.
This introduction will assume you no nothing about AWS, and have no account. With Internet access via a Browser and a valid Credit Card, you can have your own running Web Server on the Internet in under 10 minutes, just point and click.
We will step into some more detail using the supplied command line tools for more advanced usage.
Tuesday 4:25 pm – 5:10 pm
Yves Trudeau (Sun/MySQL, Waffle Grid, Big DBA Head ) presents NBD (MySQL Cluster) performance tuning and pitfalls. In the recent months Yves has worked on many NDB Cluster engagements and come through many unusual situations that are relevant to people interested in NDB Cluster. Here is a brief list of the topics to be covered:
* Identifying bottleneck
* Minimizing disk footprint
* Minimizing latency (logger type application)
* Realtime options
* Using CPUs efficiently
* The e1000 pitfall
Tuesday 5:15 pm – 6:00 pm
InnoDB Database Recovery Techniques
Peter Zaitsev (Percona)
Have you ever had Innodb database corrupted or have deleted data accidentally and want it back ? This session will go through various approaches you can use to get most of your data back using MySQL build in features as well as third party open source tool.
This session speaks about Innodb database recovery techniques (apart from recovering from back).
First we will discuss various types of Innodb corruption and data loss scenarios ranging from user error to hardware failures.
Then we will look at Innodb storage data structure to see what foundations does it has for corruption discovery and recovery.
Then we will go into approaches one can use to recover data including:
* Recovering Innodb dictionary running our of sync with .idb files
* Recovering minor corruptions using innodb_force_recovery and build-in MySQL Features
* Recovering deleted data and dropped tables using Innodb Recovery Tools package
* Dealing with complex data loss scenarios such as failed filesystem or failed RAID subsystem.