mysql Attributes
Important
The AWS OpsWorks Stacks service reached end of life on May 26, 2024 and has been disabled for both new and existing customers.
We strongly recommend customers migrate their workloads to other solutions as soon as possible. If you have questions about migration, reach out to the AWS Support Team on AWS re:Post
Note
These attributes are available only on Linux stacks.
The mysql attributes
- basedir
-
The base directory (string). The default value is
'/usr'.node[:mysql][:basedir] - bind_address
-
The address that MySQL listens on (string). The default value is
'0.0.0.0'.node[:mysql][:bind_address] - clients
-
A list of clients (list of string).
node[:mysql][:clients] - conf_dir
-
The directory that contains the configuration file (string). The default values are as follows:
-
Amazon Linux and RHEL:
'/etc' -
Ubuntu:
'/etc/mysql'
node[:mysql][:conf_dir] -
- confd_dir
-
The directory that contains additional configuration files (string). The default value is
'/etc/mysql/conf.d'.node[:mysql][:confd_dir] - datadir
-
The data directory (string). The default value is
'/var/lib/mysql'.node[:mysql][:datadir] - grants_path
-
The grant table location (string). The default value is
'/etc/mysql_grants.sql'.node[:mysql][:grants_path] - mysql_bin
-
The mysql binaries location (string). The default value is
'/usr/bin/mysql'.node[:mysql][:mysql_bin] - mysqladmin_bin
-
The mysqladmin location (string). The default value is
'/usr/bin/mysqladmin'.node[:mysql][:mysqladmin_bin] - pid_file
-
The file that contains the daemon's process ID (string). The default value is
'/var/run/mysqld/mysqld.pid'.node[:mysql][:pid_file] - port
-
The port that the server listens on (number). The default value is
3306.node[:mysql][:port] - root_group
-
The root group (string). The default value is
'root'.node[:mysql][:root_group] - server_root_password
-
The server's root password (string). The default value is randomly generated.
node[:mysql][:server_root_password] - socket
-
The location of the socket file (string). The default value is
'/var/lib/mysql/mysql.sock'. The default values are as follows:-
Amazon Linux and RHEL:
'/var/lib/mysql/mysql.sock' -
Ubuntu:
'/var/run/mysqld/mysqld.sock'
node[:mysql][:socket] -
- tunable Attributes
-
The tunable attributes are used for performance tuning.
- back_log
-
The maximum number of outstanding requests (string). The default value is
'128'.node[:mysql][:tunable][:back_log] - innodb_additional_mem_pool_size
-
The size of the pool that Innodb
uses to store internal data structures (string). The default value is '20M'.node[:mysql][:tunable][:innodb_additional_mem_pool_size] - innodb_buffer_pool_size
-
The Innodb
buffer pool size (string). The attribute value is set by AWS OpsWorks Stacks and depends on the instance type, but you can override it by using custom JSON or a custom attribute file. node[:mysql][:tunable][:innodb_buffer_pool_size] - innodb_flush_log_at_trx_commit
-
How often Innodb
flushes the log buffer (string). The default value is '2'. For more information, see innodb_flush_log_at_trx_commit. node[:mysql][:tunable][:innodb_flush_log_at_trx_commit] - innodb_lock_wait_timeout
-
The maximum amount of time, in seconds, that an Innodb
transaction waits for a row lock (string). The default value is '50'.node[:mysql][:tunable][:innodb_lock_wait_timeout] - key_buffer
-
The index buffer size (string). The default value is
'250M'.node[:mysql][:tunable][:key_buffer] - log_slow_queries
-
The location of the slow-query log file (string). The default value is
'/var/log/mysql/mysql-slow.log'.node[:mysql][:tunable][:log_slow_queries] - long_query_time
-
The time, in seconds, required to designate a query as a long query (string). The default value is
'1'.node[:mysql][:tunable][:long_query_time] - max_allowed_packet
-
The maximum allowed packet size (string). The default value is
'32M'.node[:mysql][:tunable][:max_allowed_packet] - max_connections
-
The maximum number of concurrent client connections (string). The default value is
'2048'.node[:mysql][:tunable][:max_connections] - max_heap_table_size
-
The maximum size of user-created
MEMORYtables (string). The default value is'32M'.node[:mysql][:tunable][:max_heap_table_size] - net_read_timeout
-
The amount of time, in seconds, to wait for more data from a connection (string). The default value is
'30'.node[:mysql][:tunable][:net_read_timeout] - net_write_timeout
-
The amount of time, in seconds, to wait for a block to be written to a connection (string). The default value is
'30'.node[:mysql][:tunable][:net_write_timeout] - query_cache_limit
-
The maximum size of an individual cached query (string). The default value is
'2M'.node[:mysql][:tunable][:query_cache_limit] - query_cache_size
-
The query cache size (string). The default value is
'128M'.node[:mysql][:tunable][:query_cache_size] - query_cache_type
-
The query cache type (string). The possible values are as follows:
-
'0': No caching or retrieval of cached data. -
'1': Cache statements that don't begin withSELECT SQL_NO_CACHE. -
'2': Cache statements that begin withSELECT SQL_CACHE.
The default value is
'1'.node[:mysql][:tunable][:query_cache_type] -
- thread_cache_size
-
The number of client threads that are cached for re-use (string). The default value is
'8'.node[:mysql][:tunable][:thread_cache_size] - thread_stack
-
The stack size for each thread (string). The default value is
'192K'.node[:mysql][:tunable][:thread_stack] - wait_timeout
-
The amount of time, in seconds, to wait on a noninteractive connection. The default value is
'180'(string).node[:mysql][:tunable][:wait_timeout] - table_cache
-
The number of open tables (string). The default value is
'2048'.node[:mysql][:tunable][:table_cache]
