What is Buffer pool and list some of them?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    Answered by Dishant Ved

    The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. The buffer pool permits frequently used data to be processed directly from memory, which speeds up processing. On dedicated servers, up to 80% of physical memory is often assigned to the buffer pool.

Related Questions

Please Login or Register to leave a response.

Related Questions

DB2 Interview Questions

What is DB2 and what is the use of DB2 Optimizer?

DB2 is a huge relational database management system for the MVS (Multiple Virtual storages) operating systems, where th..

DB2 Interview Questions

Mention data types used in DB2 ?

The data types used in DB2 are: SMALLINT DECIMAL CHAR FLOAT INTEGER VARCHAR DATE TIME ..

DB2 Interview Questions

Explain PACKAGE in DB2 and its advantages?

PACKAGE:They are units, which consists of many executable codes that are meant for SQL statements for one respective DB..