MySQL Connect Tutorials

Moscone South—Monday, September 23

Join us for a full day of MySQL tutorials delivered by Oracle’s MySQL Engineers. Whether you are getting started with MySQL or an experienced user, you will have the opportunity to acquire in-depth knowledge, directly from the source.

MySQL Connect Tutorials are available to MySQL Connect registrants, as an add-on package. For more information, go to the MySQL Connect registration page.

Tutorials and Schedule

10:15 a.m.–12:30 p.m.

Getting Started with MySQL: Learn the Essentials

Ligaya Turmelle, Principal Technical Support Engineer

“How do I…?” “What is…?”…: Whenever you start working with a new technology, you have a lot of questions. This tutorial is designed to answer many of the common questions and cover most of the highlights for starting out with MySQL and to help you get going. It covers the basics, including the background and features of MySQL, installing MySQL, “talking” to MySQL, MySQL’s architecture, storage engines, datatypes, and log files. In addition, it discusses security with MySQL, backups, and monitoring of the system.

How to Analyze and Tune SQL Queries for Better Performance?

Øystein Grøvlen, Senior Principal Software Engineer

Performance of SQL queries often plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning to increase performance. This tutorial covers query processing, optimization methods, and how the MySQL optimizer chooses a specific plan to execute SQL. It demonstrates how to use tools such as EXPLAIN and Optimizer Trace to analyze query plans the MySQL optimizer produces. Based on the analysis, the tutorial shows how to take the next steps for performance tuning. It might mean forcing a particular index, changing the schema, or modifying configuration parameters.

1:15 p.m.–3:30 p.m.

Enhancing Productivity with MySQL 5.6 New Features

Arnaud Adant, Principal Technical Support Engineer

This tutorial focuses on a selection of MySQL 5.6 new features that have a dramatic impact on productivity and agility for developers and DBAs:

  • NoSQL with the InnoDB memcached API
  • InnoDB FULLTEXT indexes
  • Major optimizer improvements
  • Enhanced EXPLAIN and tracing
  • Persistent statistics
  • Transportable table spaces and partitions
  • Table space management options
  • InnoDB online schema changes
  • Performance_schema in practice

Each subject is illustrated by sample code and bundled in a Web application demo.

MySQL 5.6 Replication Tips and Tricks

Luis Soares, Senior Software Engineer

MySQL 5.6 is the best release ever of the world’s most popular open source database, with the most-significant enhancements to MySQL replication. This tutorial imparts in-depth knowledge directly from the engineers behind MySQL replication. You’ll learn how to get started with features such as GTIDs and autofailover or manual switch-over, multithreaded and crash-safe slaves, checksums, and DevOps utilities. Previous releases are also covered. This intense, high-energy session will extend your portfolio of tips and tricks for building highly scalable, available database services, with a deep dive into MySQL replication and tools.

mean forcing a particular index, changing the schema, or modifying configuration parameters.

4:00 p.m.–6:15 p.m.

Getting Started with MySQL Cluster

Bernd Ocklin, Director, MySQL Cluster Engineering

This MySQL Cluster tutorial delivers an in-depth course on how to get started with MySQL Cluster. It guides you through all the steps needed to set up MySQL Cluster, either manually or in an automated manner, and provides an overview of its functionalities, with a focus on understanding how to size MySQL Cluster and its hardware resources. You will learn about typical gotchas and initial performance considerations. Finally, you will be guided through all design decisions, based on a real-world architecture.

MySQL 5.6 Performance Tuning and Best Practices

Dimitri Kravtchuk, Performance Architect

This tutorial is a deep dive into MySQL performance. There’s been spectacular progress over the past few years, and it’s hard to imagine that just five years ago, MySQL did not scale up well. MySQL 5.6 now may be able to use your 32-core server nearly to full power, but there’s no silver bullet and really high performance is rare out of the box. You must think, analyze, and tune your hardware, system, and MySQL configuration; learn your workload problematics; and be aware of MySQL internals, limitations, and workarounds. This session shows how to make MySQL fly! You’ll hear about the latest achievements and best practices.