How to Analyze and Tune MySQL Queries for Better Performance - MySQL Tutorial

Please watch Percona’s #MySQL #Database Administrator, Brad Mickel as he presents How to Analyze and #Tune #MySQL Queries for Better Performance.

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔

Query performance is essential in making any application successful. In order to finely tune your queries you first need to understand how MySQL executes them, and what tools are available to help identify problems.

📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, #MySQL and many other things.

In this session you will learn:
1) The common tools for researching problem queries
2) What an Index is, and why you should use one
3) Index limitations
4) When to rewrite the query instead of just adding a new index

Get more on #MySQL & #Database Tools + other Percona Database Talks below 👇👇👇

Connect with us 👇👇👇

[srinivassripathy]

Hi Brad, it was a fantastic a presentation on performance and usage of Indexes.

Please address my queries related to Indexes.


1. If a Composite Index is created on the frequently accessed columns, can we drop individual indexes on the columns created from a table on the same columns to avoid Index merge?

[willk]

Very helpful and well-explained. Thank you.

[cz]

Excellent course, and some interesting questions at the end! Thanks!

[ArunManivannan]

Fantastic presentation! Thanks a lot !!

[prondubuisi]

Great information, thanks for sharing

[sks]

Awesome Presentation ! Thank you so much for posting. we need some more videos like this.

[srinivassripathy]

Hi Brad, I'd like to use InnoDB on the master, for its transactional ability, but MyISAM on the slaves for the read scalability. Is this possible?

[amitroy-cxqb]

Could you please let me know how did you find query time distribution tab.

[mohammedabulsoud]

I love the multiple range query optimisation technique. Thanks

[ginebro]

Great explaination, such a shame it has so little views