MySQL Forums :: InnoDB :: Internal Behaviour of the MySQL Server
Internal Behaviour of the MySQL Server
Posted by: Lars Werdes
Date: January 11, 2013 03:45AM
I would like to understand the behaviour of the MySQL Server. What happens if I COMMIT a INSERT into a InnoDB table? Does the server allocate space in the memory (in the ranges of innodb_buffer_pool_size) and then, if scheduler or something begins a new cycle, it will be written to the ibdata-file and the allocated memory can be freed.
Or does the server firstly use the innodb_log_buffer or the innodb_log_file and then ibdata. What happens if either the innodb_log_buffer or the innodb_log_file or both is full? Is there maybe anywhere a picture for an timing overview of this kind of behaviour?
Many thanks in advance!
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.