Internal Behaviour of the MySQL Server
Hello,
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!
Regards
Lars Werdes
Subject
Views
Written By
Posted
Internal Behaviour of the MySQL Server
2163
January 11, 2013 03:45AM
1176
January 13, 2013 04:34AM
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.