Question

The system variable to maintain InnoDB log buffer size is _________________

(a) innodb_log_buffer_size

(b) innodb_buffer_log_size

(c) buffer_log_innodb_size

(d) log_buffer_innodb_size

This question was posed to me during an interview.

This question is from Administrative-Level Optimizations topic in section Query Optimization of MySQL

Answer 1

The correct choice is (a) innodb_log_buffer_size

To elaborate: The InnoDB storage engine has its own cache used for buffering the data and index values. It maintains a log buffer. The size for this is controlled by innodb_log_buffer_size.