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
Answer: Option A
Solution (By Examveda Team)
This question is about how MySQL's InnoDB storage engine manages its log buffer. This buffer is crucial for transaction safety and data recovery.InnoDB uses a log buffer to store transaction changes before they are written to the disk. This allows transactions to happen faster because they don't have to wait for the disk write.
The system variable that controls the size of this log buffer is:
innodb_log_buffer_size
Let's look at the options:
* Option A: innodb_log_buffer_size - This is the correct answer. It directly controls the size of the InnoDB log buffer.
* Option B: innodb_buffer_log_size - This option doesn't exist in MySQL.
* Option C: buffer_log_innodb_size - This option doesn't exist in MySQL.
* Option D: log_buffer_innodb_size - This option doesn't exist in MySQL.
Therefore, the answer is Option A: innodb_log_buffer_size.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion