This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB: is Aria's page cache and InnoDB's buffer pool shared across database connections for an embedded database?

If each thread in a multi-threaded application connects to an embedded database, will these threads share a buffer pool when using the InnoDB engine? Will they share a page cache when using the Aria engine? Or does each thread get a private buffer pool / page cache?

Answer Answered by Daniel Black in this comment.

Both InnoDB buffer pool and Aria page cache are a shared instance between all threads.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.