How database indexing works internally?

What is the sorting algorithm behind ORDER BY query in MySQL?

Interesting analogy to understand synchronous, callbacks and async await / promises!

System design : How Instagram computes real-time trending hashtags ?