By Bertrand Matthelie-Oracle on Sep 05, 2013
We recently looked at InnoDB, Real-World Experiences and Performance Tuning sessions at MySQL Connect. Let's now focus on the MySQL tutorials. You indeed have this year the opportunity to add a third day of tutorials to your MySQL Connect registration. They will be held on Monday September 23 at Moscone South. Whether you are getting started with MySQL or an experienced user, you will get the chance to acquire in-depth knowledge, directly from the source.
Tutorials and Schedule:
10:15 a.m.–12:30 p.m.
Getting Started with MySQL: Learn the Essentials
Ligaya Turmelle, Principal Technical Support Engineer, Oracle - Moscone South 200
“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, Oracle - Moscone South 236
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, Oracle - Moscone South 200
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, Oracle - Moscone South 236
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.
4:00 p.m.–6:15 p.m.
Getting Started with MySQL Cluster
Bernd Ocklin, Director, MySQL Cluster Engineering, Oracle - Moscone South 200
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, Oracle - Moscone South 236
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.
Not registered yet? Sign-up Now to save US$300!