Skip to Main Content
MySQL 8 Administrator???s Guide
book

MySQL 8 Administrator???s Guide

by Chintan Mehta, Hetal Oza, Subhash Shah, Ravi Shah
February 2018
Intermediate to advanced content levelIntermediate to advanced
510 pages
16h 10m
English
Packt Publishing
Content preview from MySQL 8 Administrator???s Guide

Optimizing the use of memory

In order to improve the performance of database operations, MySQL allocates buffers and caches memory. As a default, the MySQL server starts on a virtual machine (VM) with 512 MB of RAM. We can modify the default configuration for MySQL to run on limited memory systems.

The following list describes the ways to optimize MySQL memory:

  • The memory area which holds cached InnoDB data for tables, indexes, and other auxiliary buffers is known as the InnoDB buffer pool. The buffer pool is divided into pages. The pages hold multiple rows. The buffer pool is implemented as a linked list of pages for efficient cache management. Rarely used data is removed from the cache using an algorithm. Buffer pool size is an important ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Hands-On MySQL Administration

Hands-On MySQL Administration

Arunjith Aravindan, Jeyaram Ayyalusamy
SQL Cookbook, 2nd Edition

SQL Cookbook, 2nd Edition

Anthony Molinaro, Robert de Graaf

Publisher Resources

ISBN: 9781788395199Supplemental Content