Webcast : SQL Diagnostic Manager for MySQL

Tuning database indexes can improve database performance by enhancing the speed of data retrieval operations on a database table. We achieve this by providing rapid random lookups and efficient access to ordered records. When you create an optimized index, you can select or sort your rows faster than before, leading to improved query performance. Well-tuned indexes can cause major performance improvements.

Slow running queries are the most common problem that database professionals face while working with MySQL. While it may be easy to blame MySQL for unsatisfactory performance, the issue often persists with the way queries have been written, and how Indexes have been set up.

Join IDERA and Pinal Dave as he walks you through how to identify problems that slow down MySQL, and the secret indexing tricks to fix them. Database professionals will walk out with scripts and knowledge that can be applied to their servers immediately after the session.

Pinal Dave is a Developer Evangelist and SQL Server performance expert. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET).