MySQL Forums
Forum List  »  General

MySQL internal
Posted by: Hrishikesh Kumar Mishra
Date: September 19, 2019 03:21AM

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.


-
Hrishikesh

Options: ReplyQuote


Subject
Written By
Posted
MySQL internal
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.