I wanted to understand some of the MySQL internals (Version 5.7) in detail specially in two scenarios:
- What happens inside MySQL Server when we insert a row in a table. What all operations MySQL performs and in which orders. When it writes to redo log, bin log, how rollback happens. When index gets created?
- Second, where can I get internals of indexing specifically secondary index like how it handles sparse data, how MySQL handle index when a row gets deleted.
There is not much information able on internet and I am avoiding to read MySQL Server code. Is there any document, paper where these details are present.
September 19, 2019 03:21AM
September 19, 2019 09:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.