<commit_before>#
# Generated by Chef for <%= node['hostname'] %>
#
# Local modifications will be overwritten.
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port            = <%= node['mysql']['port'] %>
socket          = <%= node['mysql']['server']['socket'] %>

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = <%= node['mysql']['server']['socket'] %>
nice            = <%= node['mysql']['nice'] %>

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user            = mysql
pid-file        = <%= node['mysql']['server']['pid_file'] %>
socket          = <%= node['mysql']['server']['socket'] %>
port            = <%= node['mysql']['port'] %>
basedir         = <%= node['mysql']['server']['basedir'] %>
datadir         = <%= node['mysql']['data_dir'] %>
tmpdir          = <%= node['mysql']['server']['tmpdir'].join(':') %>
skip-external-locking
<%- if node['mysql']['tunable']['skip-name-resolve'] %>
skip-name-resolve
<%- end %>

# Charset and Collation
character-set-server = <%= node['mysql']['tunable']['character-set-server'] %>
collation-server     = <%= node['mysql']['tunable']['collation-server'] %>
<%- if node['mysql']['tunable']['lower_case_table_names'] %>
lower_case_table_names = <%= node['mysql']['tunable']['lower_case_table_names'] %>
<%- end %>
<%- if node['mysql']['tunable']['event_scheduler'] %>
event_scheduler      = <%= node['mysql']['tunable']['event_scheduler'] %>
<%- end %>
<%- if node['mysql']['tunable']['skip-character-set-client-handshake'] %>
skip-character-set-client-handshake
<%- end %>
<%- if (node['mysql']['tunable']['lc_messages_dir'] && node['mysql']['tunable']['lc_messages']) %>
lc_messages_dir	    = <%= node['mysql']['lc_messages_dir'] %>
lc_messages	    = <%= node['mysql']['lc_messages'] %>
<%- elsif (node['mysql']['tunable']['languages']) %>
languages	    = <%= node['mysql']['tunable']['languages'] %>
<%- end %>

#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = <%= node['mysql']['bind_address'] %>
#
# * Fine Tuning
#
key_buffer_size         = <%= node['mysql']['tunable']['key_buffer_size'] %>
max_allowed_packet      = <%= node['mysql']['tunable']['max_allowed_packet'] %>
thread_stack            = <%= node['mysql']['tunable']['thread_stack'] %>
thread_cache_size       = <%= node['mysql']['tunable']['thread_cache_size'] %>
sort_buffer_size        = <%= node['mysql']['tunable']['sort_buffer_size'] %>
read_buffer_size        = <%= node['mysql']['tunable']['read_buffer_size'] %>
read_rnd_buffer_size    = <%= node['mysql']['tunable']['read_rnd_buffer_size'] %>
join_buffer_size        = <%= node['mysql']['tunable']['join_buffer_size'] %>

auto-increment-increment = <%= node['mysql']['auto-increment-increment'] %>
auto-increment-offset    = <%= node['mysql']['auto-increment-offset'] %>

# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover          = <%= node['mysql']['tunable']['myisam-recover'] %>
max_connections         = <%= node['mysql']['tunable']['max_connections'] %>
max_connect_errors      = <%= node['mysql']['tunable']['max_connect_errors'] %>
concurrent_insert       = <%= node['mysql']['tunable']['concurrent_insert'] %>
connect_timeout         = <%= node['mysql']['tunable']['connect_timeout'] %>
wait_timeout            = <%= node['mysql']['tunable']['wait_timeout'] %><commit_msg>Add max-join-size parameter to mysql tunables<commit_after>#
# Generated by Chef for <%= node['hostname'] %>
#
# Local modifications will be overwritten.
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port            = <%= node['mysql']['port'] %>
socket          = <%= node['mysql']['server']['socket'] %>

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = <%= node['mysql']['server']['socket'] %>
nice            = <%= node['mysql']['nice'] %>

[mysqld]
#
# * Basic Settings
#

#
# * IMPORTANT
#   If you make changes to these settings and your system uses apparmor, you may
#   also need to also adjust /etc/apparmor.d/usr.sbin.mysqld.
#

user            = mysql
pid-file        = <%= node['mysql']['server']['pid_file'] %>
socket          = <%= node['mysql']['server']['socket'] %>
port            = <%= node['mysql']['port'] %>
basedir         = <%= node['mysql']['server']['basedir'] %>
datadir         = <%= node['mysql']['data_dir'] %>
tmpdir          = <%= node['mysql']['server']['tmpdir'].join(':') %>
skip-external-locking
<%- if node['mysql']['tunable']['skip-name-resolve'] %>
skip-name-resolve
<%- end %>

# Charset and Collation
character-set-server = <%= node['mysql']['tunable']['character-set-server'] %>
collation-server     = <%= node['mysql']['tunable']['collation-server'] %>
<%- if node['mysql']['tunable']['lower_case_table_names'] %>
lower_case_table_names = <%= node['mysql']['tunable']['lower_case_table_names'] %>
<%- end %>
<%- if node['mysql']['tunable']['event_scheduler'] %>
event_scheduler      = <%= node['mysql']['tunable']['event_scheduler'] %>
<%- end %>
<%- if node['mysql']['tunable']['skip-character-set-client-handshake'] %>
skip-character-set-client-handshake
<%- end %>
<%- if (node['mysql']['tunable']['lc_messages_dir'] && node['mysql']['tunable']['lc_messages']) %>
lc_messages_dir	    = <%= node['mysql']['lc_messages_dir'] %>
lc_messages	    = <%= node['mysql']['lc_messages'] %>
<%- elsif (node['mysql']['tunable']['languages']) %>
languages	    = <%= node['mysql']['tunable']['languages'] %>
<%- end %>

#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = <%= node['mysql']['bind_address'] %>
#
# * Fine Tuning
#
key_buffer_size         = <%= node['mysql']['tunable']['key_buffer_size'] %>
max_allowed_packet      = <%= node['mysql']['tunable']['max_allowed_packet'] %>
thread_stack            = <%= node['mysql']['tunable']['thread_stack'] %>
thread_cache_size       = <%= node['mysql']['tunable']['thread_cache_size'] %>
sort_buffer_size        = <%= node['mysql']['tunable']['sort_buffer_size'] %>
read_buffer_size        = <%= node['mysql']['tunable']['read_buffer_size'] %>
read_rnd_buffer_size    = <%= node['mysql']['tunable']['read_rnd_buffer_size'] %>
join_buffer_size        = <%= node['mysql']['tunable']['join_buffer_size'] %>
<%- if node['mysql']['tunable']['max-join-size'] %>
max-join-size           = <%= node['mysql']['tunable']['max-join-size'] %>
<%- end %>

auto-increment-increment = <%= node['mysql']['auto-increment-increment'] %>
auto-increment-offset    = <%= node['mysql']['auto-increment-offset'] %>

# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover          = <%= node['mysql']['tunable']['myisam-recover'] %>
max_connections         = <%= node['mysql']['tunable']['max_connections'] %>
max_connect_errors      = <%= node['mysql']['tunable']['max_connect_errors'] %>
concurrent_insert       = <%= node['mysql']['tunable']['concurrent_insert'] %>
connect_timeout         = <%= node['mysql']['tunable']['connect_timeout'] %>
wait_timeout            = <%= node['mysql']['tunable']['wait_timeout'] %>
{'fraction_non_alphanumeric': 0.20275984865346094, 'fraction_numerical': 0.0004451368795904741, 'mean_word_length': 4.400841346153846, 'pattern_counts': {'":': 0, '<': 98, '<?xml version=': 0, '>': 98, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4094907', 'n_tokens_mistral': 2955, 'n_tokens_neox': 2664, 'n_words': 594}