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

524288025769803776

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

164

The number of regions that the InnoDB buffer pool is divided into

no

mysql_innodb_thread_sleep_delay

integer

milliseconds

10000

01000000

The number of milliseconds each InnoDB thread sleeps before joining the InnoDB queue

no

mysql_innodb_flush_method

string

-

fsync

  • fsync

  • O_DSYNC

  • littlesync

  • nosync

  • O_DIRECT

  • O_DIRECT_NO_FSYNC

The method used to flush data to InnoDB's datafiles and log files

yes

mysql_innodb_log_file_size

integer

bytes

50331648

41943045368709120

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

01000

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.099.99

The limit on the percentage of dirty pages in the buffer pool of InnoDB

no

mysql_innodb_read_ahead_threshold

integer

pages

56

064

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

  • ON

  • OFF

Whether or not enable the adaptive hash index optimization for InnoDB tables

no

mysql_innodb_fill_factor

integer

percentage

100

10100

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.

Last updated