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	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	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	ON OFF	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.