Slow mysql Query? Make your Msqyl Fast and faster!

[@metalalive2006]

great-and-long video , thanks. This might save time for someone who already have basic knowledge of mysql ... 29:00 query a table of ~3m rows without index (order by `date` non-pk column) 29:26 using EXPLAIN to check the execution plan of the slow query 29:58 query the same table with index (order by pk column, which already has default index) 33:11 add secondary index for `date` (non-pk) column 34:09 query the same table again with the secondary index (order by `date` non-pk column) 38:35 Mysql configuration explanation

[@dannyokec]

You savedmy life🎉🎉. I had todelete tables before this

[@emadabdulhannan244]

amazing thank you, I was struggling with a slow complicated big MySQL query, now it is super fast ❤️❤️❤️❤️❤️❤️

[@Sj-yf2jg]

Premium knowledge, I subscribed

[@agussumawigena4565]

this is the most useful optimizing mysql tutorial i think, many many thank you

[@mikealibo]

i didn't finish yet the video. But i was starting to smile in my face because those scenarios that you create is also the same as me. Eventually i have also 6million data or even more in my database . And this video is very very usefull .

[@edutronixsystems4943]

Also started smiling after first 10 minutes. Great video

[@arjay_2002]

this is amazing... background birds so relaaxing..

[@bestdivisionhindi7799]

This is the best video for phpmyadmin optimization.... Love you bro... Hope you will continue your effort...

[@sassoleo]

Another advantage of innodb tables vs isam is that innodb allows foreign keys

[@dhrubavideos]

you are a very good instructor

[@ganztv3106]

Nice explanation Bro..2020 here and still watching..learned a lot here..keep it up..thanks

[@varenneriocha8712]

Same, in 2021!

[@ayazahamed8254]

Good Content and Well explained.

[@FerozAhmedBD]

Thanks a lot Sir, You made my day better.

[@jaysmainyt_channel1751]

I want to learn more!!

[@pavanganeshbhagathi1152]

really good

[@vkmishra.singer]

Nice vedio...hats off

[@bugsbane]

@34:00 - what if you did a subselect with the inner select with the index - then full table scan on the results (assuming small result set)

[@PA-ki9fy]

Does memory table support foreign key integrations?

[@soyal24]

it works good but when xampp restart the data lost, how to fix this ???

[@ParthaPMout]

Thanks mate ❤️

[@prashantkapse3047]

It's great sir thank you

[@jagjotsinghwadali3535]

I need a help regarding quering about reporting tables. Can you help in query optimization. I have to retrieve total number of data based on indian states and dates.

[@sureshgrandhi3781]

Can I get the configuration file which makes MySQL db to get the data very fast

[@tiganusconstantinrazvan3946]

yes and no ! the measuring method is never equal for the same script (if you hit f5=refresh key) so avoiding measuring 10 times or more then calculating the average to approximate the inexact result by using ab.exe (see one of my videos "my stuff") .I wrote the fastest php framework in the world in various form(classic,oop,anonymous functions+oop ,hundreds versions) and using mysql/mysqli/ even sqlite (but never pdo) even on php 8 i have over 80-120 executions /s with that cmd ab params you see in the video to a similar "hello world db select tables" and without using the database but only php from 150 to max 200 on windows 10 x64! (in Linux Ubuntu with db i got from 600 to 3200 ,the 3200 i got with ab measuring until running script then send headers). "The best results comes" when you will use dynamic constructs over public static functions and using mysqli (the union types aren't fast yet ,the old php 7 + opcache IN MY CASE doubling the results: i didn't make any video cause using opcache in my mind that is a cheating way)

[@ajexpomarocWebmaroc]

Nice video i need a help plz i have big probleme whith my large database i wante your contact

[@Oswee]

Latvian accent?

[@davis4010]

Pašam arī klausoties likās kkas pazīstams balsī :)