> For the complete documentation index, see [llms.txt](https://docs.akamas.io/akamas-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.akamas.io/akamas-docs/3.2.1-1/akamas-reference/optimization-packs/mysql-pack.md).

# MySQL Database optimization pack

The MySQL optimization pack allows the user to monitor a MySQL instance and explore the configuration space of its parameters. The optimization pack provides parameters and metrics that can be leveraged to reach, among others, two main goals:

* Throughput optimization - increasing the capacity of a MySQL deployment to serve clients
* Cost optimization - decreasing the size of a MySQL deployment while guaranteeing the same service level

To reach the aforementioned goals, the optimization pack focuses on three key areas of tuning of the InnoDB, the storage engine for MySQL:

* Buffer management
* Threading
* Paging

## Component Types <a href="#installing" id="installing"></a>

The following table describes the supported component types by the MySQL optimization pack.

| Component Type                                                                                | Description                               |
| --------------------------------------------------------------------------------------------- | ----------------------------------------- |
| [MySQL 8.0](/akamas-docs/3.2.1-1/akamas-reference/optimization-packs/mysql-pack/mysql-8.0.md) | MySQL 8.0 Database, deployed on-premises. |

## Installing <a href="#installing" id="installing"></a>

Here’s the command to install the MySQL optimization-pack using the Akamas CLI:

```
$ akamas install optimization-pack MySQL
```


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.akamas.io/akamas-docs/3.2.1-1/akamas-reference/optimization-packs/mysql-pack.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
