difference between innodb_log_buffer_size and innodb_buffer_pool_size

Question

Difference between innodb_log_buffer_size and innodb_buffer_pool_size in mysql? Is the innodb_log_buffer_size is given out of innodb_buffer_pool_size. What data do innodb_log_buffer_size and innodb_buffer_pool_size contains.

Answer 1

I found the following explanation:

"The innodb_buffer_pool is the memory buffer that InnoDB uses to cache data and indexes of its tables. The larger you set this value, the less disk I/O is needed to access data in tables. You may set this to up to 50% of the machine physical memory size. However, do not set it too large because competition for the physical memory might cause paging in the operating system, or even out of memory problems.

The innodb_log_file_size is the size of the transaction log. By default there are two logfiles. The preferred value size for the log_file_size is 25% of the innodb_buffer_pool_size.

The size of the innodb_log_buffer_size that InnoDB uses to write to the log files on disk. A large log buffer allows large transactions to run without a need to write the log to disk before the transactions commit. If you have big transactions, making the log buffer larger will save disk I/O. This value should be 32Mb."