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.
percona.tv/subscribe
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 👇👇👇
🎧 Watch / listen our MySQL Database Podcasts ⏩ percona.tv/database-podcast
✅ Watch Percona Live 2022 Talks ⏩ percona.tv/PerconaLive2022
👨💻👩💻 MySQL Jobs - Percona is Hiring ⏩ per.co.na/percona-jobs
✅ Percona Services ⏩ per.co.na/Q8eykw
✅ Monitor your Database For Free ⏩ percona.tv/pmm-yt
✅ Percona Operator for MySQL ⏩per.co.na/kubernetes-operators
Connect with us 👇👇👇
Twitter: per.co.na/twitter
Facebook: per.co.na/facebook
Instagram: per.co.na/instagram
LinkedIn: per.co.na/linkedin
Пікірлер: 17
Awesome Presentation ! Thank you so much for posting. we need some more videos like this.
Fantastic presentation! Thanks a lot !!
Very helpful and well-explained. Thank you.
Liked it, thankyou!
Great information , thanks for sharing
Excellent course, and some interesting questions at the end! Thanks!
@percona
3 жыл бұрын
Glad you enjoyed it! Don't forget 📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things. percona.tv/subscribe
Thank you so much :D
Exactly what I was looking for.
@percona
2 жыл бұрын
Glad this video is helpful for you! Don't forget 📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things. percona.tv/subscribe
I love the multiple range query optimisation technique. Thanks
@percona
Жыл бұрын
Thanks for your feedback! Don't forget 📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things. percona.tv/subscribe
Gold of Information!
@percona
2 жыл бұрын
Glad you enjoyed it! Don't forget 📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things. percona.tv/subscribe
Could you please let me know how did you find query time distribution tab.
Great explaination, such a shame it has so little views
@percona
2 жыл бұрын
Glad you enjoyed it Cristian! Don't forget 📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things. percona.tv/subscribe