MySQL Forums
Forum List  »  InnoDB

Internal Behaviour of the MySQL Server
Posted by: Lars Werdes
Date: January 11, 2013 03:45AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Internal Behaviour of the MySQL Server
1461
January 11, 2013 03:45AM


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.