# MySQL 8.0

This page describes the Optimization Pack for the component type MySQL 8.0.

## Metrics

### Query

| Metric                            | Unit         | Description                                                                                                                          |
| --------------------------------- | ------------ | ------------------------------------------------------------------------------------------------------------------------------------ |
| mysql\_aborted\_connection        | connections  | The number of failed attempts to connect to the MySQL                                                                                |
| mysql\_connections\_current       | connections  | The current number of connection opened towards MySql                                                                                |
| mysql\_connections\_max           | connections  | The maximum number of connections that can be opened towards MySQL                                                                   |
| mysql\_innodb\_buffer\_pool\_size | bytes        | The size of the memory area where InnoDB caches tables and indexes                                                                   |
| mysql\_mem\_usage                 | bytes        | MySQL instance memory consumption divided by type (innodb\_buffer\_pool\_data, innodb\_log\_buffer, query\_cache, key\_buffer\_size) |
| mysql\_query\_throughput          | queries/s    | The number of queries per second processed by mysql                                                                                  |
| mysql\_slow\_query\_rate          | querys/s     | The rate of queries that are considered slow based on parameters mysql\_long\_query\_time and mysql\_long\_query\_min\_examined\_row |
| mysql\_statements\_rate           | statements/s | The rate at which each type of statement (select, insert, update, delete) executed per second.                                       |
| mysql\_threads\_running           | threads      | The number of threads running in the MySQL instance                                                                                  |
| mysql\_transactions\_rate         | transactions | The rate at which each type of transaction (handler label) is executed (commit. rollback, prepare, savepoint)                        |
| network\_in\_bytes\_rate          | bytes/s      | The number of network inbound data in bytes per second                                                                               |
| network\_out\_bytes\_rate         | bytes/s      | The number of network outbound data in bytes per second                                                                              |

## Parameters

### InnoDB

| Parameter                              | Type    | Unit         | Default value | Domain                                                                                                                                                                                                  | Description                                                                                                                                    | Restart |
| -------------------------------------- | ------- | ------------ | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- | ------- |
| mysql\_innodb\_buffer\_pool\_size      | integer | bytes        | `134217728`   | `5242880` → `25769803776`                                                                                                                                                                               | The size of the buffer pool used by InnoDB to cache tables and indexes in memory                                                               | no      |
| mysql\_innodb\_buffer\_pool\_instances | integer | regions      | `8`           | `1`→`64`                                                                                                                                                                                                | The number of regions that the InnoDB buffer pool is divided into                                                                              | no      |
| mysql\_innodb\_thread\_sleep\_delay    | integer | milliseconds | `10000`       | `0` → `1000000`                                                                                                                                                                                         | The number of milliseconds each InnoDB thread sleeps before joining the InnoDB queue                                                           | no      |
| mysql\_innodb\_flush\_method           | string  | -            | `fsync`       | <ul><li><code>fsync</code></li><li><code>O\_DSYNC</code></li><li><code>littlesync</code></li><li><code>nosyn</code>c</li><li><code>O\_DIRECT</code></li><li><code>O\_DIRECT\_NO\_FSYNC</code></li></ul> | The method used to flush data to InnoDB's datafiles and log files                                                                              | yes     |
| mysql\_innodb\_log\_file\_size         | integer | bytes        | `50331648`    | `4194304` →`5368709120`                                                                                                                                                                                 | The size of each log file in each log group maintained by InnoDB. The total size of log files cannot exceed 4GB.                               | yes     |
| mysql\_innodb\_thread\_concurrency     | integer | threads      | `0`           | `0` → `1000`                                                                                                                                                                                            | The limit on the number of os threads used by InnoDB to serve user requests                                                                    | no      |
| mysql\_innodb\_max\_dirty\_pages\_pct  | real    | percentage   | `10.0`        | `0.0` → `99.99`                                                                                                                                                                                         | The limit on the percentage of dirty pages in the buffer pool of InnoDB                                                                        | no      |
| mysql\_innodb\_read\_ahead\_threshold  | integer | pages        | `56`          | `0` → `64`                                                                                                                                                                                              | The number of sequentially read pages after which MySQL initiates an async read of the following extend (a group of pages within a tablespace) | no      |
| mysql\_innodb\_adaptive\_hash\_index   |         | -            | `ON`          | <ul><li><code>ON</code></li><li><code>OFF</code></li></ul>                                                                                                                                              | Whether or not enable the adaptive hash index optimization for InnoDB tables                                                                   | no      |
| mysql\_innodb\_fill\_factor            | integer | percentage   | `100`         | `10`→`100`                                                                                                                                                                                              | The percentage of each B-tree page that is filled during a sorted index build                                                                  | no      |

## Constraints

There are no constraints related to the component type MySQL 8.0.


---

# Agent Instructions: 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/reference/optimization-packs/mysql-pack/mysql-8.0.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.