Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the purpose of the InnoDB buffer pool?

  1. A To store query results permanently
  2. B To cache table and index data in memory
  3. C To hold the binary log
  4. D To store user credentials
Answer

To cache table and index data in memory

The buffer pool caches pages in RAM so reads avoid disk. Sizing it correctly, typically a large share of available memory, is the single most important InnoDB tuning parameter.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as