I want to know if I fire query like insert into emp ... What are the steps involved in query ?
It will go through InnoDB buffer pool?
Thanks for your help.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Here's a broad answer to your broad question.
All DMLs and
SELECTs always goes through the buffer_pool in InnoDB. It is a cache of the blocks that compose the BTrees that compose the data (organized by the necessary
PRIMARY KEY) and each secondary
For DML (broadly):
Modifying a non-unique index involves the "Change buffer". That is sort of a "delayed write" for such changes.
Note: in both DML and SELECT, the discovery of where a row usually involves drilling down a BTree, which involves fetching nodes (blocks) of the BTree. They, too, are cached (and tend to live a long time in the buffer pool).
If you want more details, start another Question with more specifics.