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

Поділитися
Вставка
  • Опубліковано 18 лис 2024

КОМЕНТАРІ • 20

  • @debabratachoudhury538
    @debabratachoudhury538 9 днів тому

    Very Simple and Clear

  • @willk7184
    @willk7184 3 роки тому +3

    Very helpful and well-explained. Thank you.

  • @prondubuisi
    @prondubuisi Рік тому

    Great information , thanks for sharing

  • @srinivassripathy1439
    @srinivassripathy1439 3 місяці тому

    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?

  • @cz7743
    @cz7743 4 роки тому +2

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

    • @percona
      @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

  • @ArunManivannan
    @ArunManivannan 4 роки тому +1

    Fantastic presentation! Thanks a lot !!

  • @mohammedabulsoud1819
    @mohammedabulsoud1819 2 роки тому

    I love the multiple range query optimisation technique. Thanks

    • @percona
      @percona  2 роки тому

      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

  • @sks1717
    @sks1717 3 роки тому

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

  • @UmerAbbas8
    @UmerAbbas8 3 роки тому

    Exactly what I was looking for.

    • @percona
      @percona  3 роки тому

      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

  • @skantsoni
    @skantsoni 3 роки тому

    Gold of Information!

    • @percona
      @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

  • @srinivassripathy1439
    @srinivassripathy1439 3 місяці тому

    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?

  • @jayantagarwal6339
    @jayantagarwal6339 2 роки тому

    Liked it, thankyou!

  • @amitroy-cx2qb
    @amitroy-cx2qb 2 роки тому

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

  • @dylanngo4454
    @dylanngo4454 2 роки тому

    Thank you so much :D

  • @ginebro1930
    @ginebro1930 2 роки тому

    Great explaination, such a shame it has so little views

    • @percona
      @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