How to Analyze and Tune MySQL Queries for Better Performance
Argomenti:
Prestazioni e scalabilità,
Optimizer
Performance of SQL queries plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. This webinar covers how the MySQL optimizer chooses a specific plan to execute SQL queries. We will show you how to use tools such as EXPLAIN (including the new JSON-based output) and Optimizer Trace to analyze query plans. We will also review how the Visual Explain functionality available in MySQL Workbench helps us visualize these plans. The webinar will also contain several examples of how to take advantage of the query analysis to improve performance of MySQL queries.
Se disponi già di un account SSO (Single Sign-On) per Oracle, fai clic sul link Login. Oppure, puoi richiedere un account gratuitamente facendo clic sul link Registrati e seguendo le istruzioni.