Mohit Sharma

Engineer at @amazon in Morning, Love Anfield Nights ⚽ and F1 weekends. 🏎️
Ex : Software Developer && Instructor at @interview_bit @scaler_official

[Mohit Sharma @m__sharma_]

“i just hope the universe puts the right person in your path. like your mom was for me. you know, someone who brings out the good stuff in you. because my god, son, what a force you will be.” #ThisIsUs

[Beyond the Game @NoEasyWins_]

Whattttt a race!!! We have another GOLD!!! 🇮🇳🥇

Finally athletics gave us the GOLD we were all waiting for.

The GOLDEN GIRLS!!

We won GOLD in 4*400m Relay!

[Beyond the Game @NoEasyWins_]

🇮🇳 NEERU has won the GOLD!! 🥇

We finally have our first individual GOLD of the Asian Games 2026.

WHAT A PERFORMANCE. She was 1st in Qualifying and completed with GOLD. This is the dominance we all were waiting for.

This is exciting. 🥹

[Beyond the Game @NoEasyWins_]

🇮🇳🥇We have done it!!!
Indian women Kabaddi team wins the GOLD medal.

Defeated Iran and completed the revenge :
Jakarta, 24 August 2018. Iran 27, India 24.

The only time India have ever lost a women's kabaddi match at the Asian Games.

[Beyond the Game @NoEasyWins_]

Another !! Another medal! For INDIA
Mixed 4*400 got the SILVER!! We defended our medal. 🥈

[Beyond the Game @NoEasyWins_]

Whatt a race by SEEMA!!! Bags the bronze for India after 16 years in 10000m 🥉

[Beyond the Game @NoEasyWins_]

A request, one fan to the rest.

Our shooters are still there. Still in the village, still with finals this week. Every word we write today reaches them before they step on the line.

There'll be time to ask what went wrong. All of October.

This week, let's be what they hear.

[Beyond the Game @NoEasyWins_]

🇮🇳 DAY 3 — 🥇1 🥈4 🥉2

🥇 First GOLD — by our Power women in cricket
🏸 Lakshya from 14-19 down to taking India 3-0 Japan, medal assured
Roshibina Devi into wushu semis, medal assured
🏑 Hockey men 16-1
🎯 Naruka 2nd in skeet qualifying, final at 6:30 AM

🧵 for recap 👇

[Beyond the Game @NoEasyWins_]

🥈 ELAVENIL VALARIVAN — SILVER 🇮🇳

Led the 10m air rifle final for 22 of 24 shots. Lost gold to Japan's Hinata Taichi by 0.6 - decided on the very last shot, in front of a home crowd.

India's 2nd medal of the Games.

#AsianGames2026 #IndiaAtAsianGames

[Beyond the Game @NoEasyWins_]

🥈 INDIA'S FIRST MEDAL OF THE GAMES

Silver in the women's 10m air rifle team — Sonam Maskar, Elavenil Valarivan, Vidarsa K Vinod.

Not done yet: Maskar & Valarivan are in the individual final at 11 AM. 🔫

#AsianGames2026 #IndiaAtAsianGames

[Mohit Sharma @m__sharma_]

@Naman_Bhalla Pathway to do so ?

[Harsha Bhogle @bhogleharsha]

Test cricket is the greatest sport in the world

[Mohit Sharma @m__sharma_]

@arpit_bhayani I think it’s the way it is taught and the motivation (interviews) that makes it less interesting.

But if you start coupling every topic with its actual use cases, it actually makes you think differently.

[Mohit Sharma @m__sharma_]

@SumitM_X Second one is called implicit join. The results will be exactly same.

If I don’t consider execution plan and think logically, the difference is first will be using the condition while joining but the second first execute cross join and then apply where condition.

[Mohit Sharma @m__sharma_]

@arpit_bhayani Yes. And interesting thing is the more deeper you go the better your basics will become. And eventually everything is just basics.

Did a similar deep dive in mysql filesort.

[Mohit Sharma @m__sharma_]

I was digging through MySQL internals the other night and hit a curious thing: Using filesort.
I’ve seen it in query plans for years — never gave it much thought.
So I pulled the source.

Turns out it’s not one algorithm, but a smart orchestration of many.👇🧵

[Mohit Sharma @m__sharma_]

If this made you look at ORDER BY differently, retweet the first post.

Follow for more deep dives into systems internals, databases, and performance tricks from real-world production.

Got questions? Drop them below 👇
#MySQL #Databases #SQL #SystemDesign #Performance

[Mohit Sharma @m__sharma_]

I was digging through MySQL internals the other night and hit a curious thing: Using filesort.
I’ve seen it in query plans for years — never gave it much thought.
So I pulled the source.

Turns out it’s not one algorithm, but a smart orchestration of many.👇🧵

[Mohit Sharma @m__sharma_]

7. Why should you care?

Because every time you write ORDER BY, you’re triggering all this.

Understanding filesort helps you write faster queries, design better indexes, and avoid disk IO surprises in production.