Geek Sync Webcast : SQL Diagnostic Manager for MySQL

Geek Sync | Tune MySQL Performance via Query Tuning

Presenter: Pinal Dave

Tuning SQL queries improves how well databases perform. By optimizing query performance, you can reduce resource usage, shorten execution times, and enhance the overall efficiency of the database system. Tuning SQL queries can lead to improved performance stability and predictability for applications relying on the database. Well-tuned queries can help maintain workload performance stability during upgrades to newer database compatibility levels.

No one wants the slow performance of their application. In this session, we will learn about three performance tuning tricks that DBAs must know to improve their MySQL performance. We will understand what those tricks are and how efficiently we can use them in just 60 minutes. We will explore various settings as well as SQL code that will kill MySQL performance. At the end of this session, every attendee will receive SQL scripts that will help them improve their server’s performance. The presentation is carefully crafted from the real-world experience for DBAs so they can learn tricks that can help them to improve their server’s performance.

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 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).

Topics : Database Performance,SQL Query Performance,

Products : SQL Diagnostic Manager for MySQL,

Register for Free Webcast

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.