SQL query performance plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. Join Senior Oracle MySQL Engineer and query tuning expert, Øystein Grøvlen, to learn how to speed things up.
He will cover how the MySQL Optimizer chooses a specific plan to execute SQL queries and then will show you how to use tools such as EXPLAIN (including the JSON-based output) and Optimizer Trace to analyze query plans.
Øystein will also review how the Visual Explain functionality available in MySQL Workbench helps to visualize these plans. The webinar will contain several examples of how to use query analysis to improve performance of MySQL queries, and improve application performance.
MySQL Cluster powers the modern real-time web applications and provides the reliability of carrier-grade communications services. MySQL Cluster with its in-memory, ACID compliant, distributed data storage and online operations for scalability and agility of large scale user applications, has a wide variety of use cases and supports both native SQL and NoSQL.
Discover new features of MySQL Cluster 7.5 and learn how to deliver the next generation apps in a distributed, cost effective and innovative manner for high availability.
Large to very large databases pose additional and unique challenges. Learn how new MySQL Enterprise Backup capabilities can greatly improve the backup and recovery all MySQL databases, but especially very large, multi-terabyte database backups.
Whether for disaster recovery or long term archival, whether backing up to disk, cloud or tape, whether sensitive data or not, MySQL Enterprise Backup 4.1 can provide big benefits – far faster, smaller, with less locking, shorter recovery times, and more.
Join MySQL Product Management Director, Mike Frank, to get an overview of MySQL Enterprise Backup, details on its new features, and real world examples of how to use them. Plus, you can get your MySQL backup questions answered with our online Q and A!