Advanced #MySQL Query Tuning Webinar - #Database Tutorial

preview_player
Показать описание
Tuning #MySQL queries and indexes can significantly increase the performance of your application and decrease response times. In this webinar, #Percona Principal Consultant Alexander Rubin will discuss advanced techniques for optimizing MySQL queries.

Topics include:

1. GROUP BY and ORDER BY optimization
2. MySQL temporary tables and filesort
3. Using covered indexes to optimize your queries
4. Loose and tight index scans in MySQL

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔
📺Subscribe To Our Channel and Get More information about #OpenSource #Databases, #kubernetes and many other things.

You can find more about #OpenSource #Databases and Percona Live Online 2020 in these links 👇🏻👇🏻👇🏻

Connect With us on our Social Networks 👇🏻👇🏻👇🏻
  1. Percona
  2. MySQL (Software)
  3. Query Tuning
  4. Percona
  5. MySQL Query
  6. MySQL Query Optimization
Рекомендации по теме
Advanced #MySQL Query 1:00:47

Advanced #MySQL Query Tuning Webinar - #Database Tutorial

Advanced Query Tuning 0:58:17

Advanced Query Tuning in MySQL 5.6 and Beyond

Webinar replay: MySQL 1:12:50

Webinar replay: MySQL Query Tuning Trilogy: Query tuning process and tools

Webinar replay: MySQL 1:15:42

Webinar replay: MySQL Query Tuning Trilogy: Working with optimizer and SQL tuning

Webinar: MySQL Query 1:01:28

Webinar: MySQL Query Patterns, Optimized

Mastering MySQL Query 1:07:32

Mastering MySQL Query Performance: An In Depth Analysis and Index Tuning Guide

Advanced Query Tuning 1:01:16

Advanced Query Tuning in MySQL 5.6 and 5.7 - MySQL Tutorial

Learn How MySQL 1:02:17

Learn How MySQL 5.6 Makes Query Optimization Easier

Really Large #MySQL 0:59:54

Really Large #MySQL #Queries: Advanced Optimization Techniques - #MySQL #Database Tutorial

Practical MySQL Performance 0:58:40

Practical MySQL Performance Optimization

Webinar replay: MySQL 1:23:31

Webinar replay: MySQL Query Tuning Trilogy: Indexing and EXPLAIN - deep dive

Percona Webinar: Best 1:01:25

Percona Webinar: Best Practices for MySQL Scalability by Peter Zaitsev

Practical MySQL Performance 1:01:44

Practical MySQL Performance Optimization - MySQL Tutorial

MySQL Query Optimization 0:00:42

MySQL Query Optimization and fine-tune

Tired of MySQL 0:57:48

Tired of MySQL Making You Wait?

How to Avoid 1:01:06

How to Avoid Common but Deadly MySQL Operations Mistakes

How to Avoid 1:00:05

How to Avoid Common but Deadly MySQL Development Mistakes

MySQL Performance Tuning 0:11:22

MySQL Performance Tuning - Part 1 of 4

Analyze MySQL Query 1:01:34

Analyze MySQL Query Performance with Percona Cloud Tools

Webinar replay: The 0:12:32

Webinar replay: The Holy Grail Webinar: Become a MySQL DBA - Database Performance Tuning - part 1

Optimizing MySQL Performance: 1:00:15

Optimizing MySQL Performance: Choosing the Right Tool for the Job

Need for Speed: 0:57:07

Need for Speed: Getting MySQL Query Tuning Right the First Time

Peter Zaitsev - 1:03:16

Peter Zaitsev - Practical MySQL Performance Optimization

MySQL 5 6 1:02:27

MySQL 5 6 Configuration Optimization Webinar with Peter Zaitsev

Комментарии
Автор

Useful and understandable, thank you!

lawrenceshen
Автор

please HELP, I'm new to mysql so I have a question  about the best practice, I'd like to have users to choose intrests or hobies so I got 2 tables:  "users" and "intrests" and I'd like to let users to choose multiple intrests, how should I do so? 
should I create a new table : "chosen intrests" and associate user_id and intrest_id together? how is it usually done? 

I'd really appreciate Your help, thanks

mikail
Автор

just a small advice for future videos: try to smack a little less and talk a bit more fluid. its hard at times to follow the speech if both is not given.

aueret
Автор

The talk is pure gold :) thx a ton
Just in-case anyone wants the URL:

osamaa.h.altameemi