Skip navigation links

MySQL Forums :: InnoDB :: Internal Behaviour of the MySQL Server


Advanced Search

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 688 Lars Werdes 01/11/2013 03:45AM
Re: Internal Behaviour of the MySQL Server 440 Marko Mäkelä 01/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.