diff options
author | Dylan William Hardison <dylan@hardison.net> | 2017-04-14 19:05:03 +0200 |
---|---|---|
committer | Dylan William Hardison <dylan@hardison.net> | 2017-04-14 19:10:20 +0200 |
commit | 4a130afba58836ebb2f70a31c88588ea46017009 (patch) | |
tree | 200816c2c7525e76228559e6b0ee81dc46980c14 /vagrant_support/my.cnf | |
parent | 480bbf368b485a6a0317b9356ce90b75201b3efa (diff) | |
download | bugzilla-4a130afba58836ebb2f70a31c88588ea46017009.tar.gz bugzilla-4a130afba58836ebb2f70a31c88588ea46017009.tar.xz |
Bug 1328874 - Add Vagrantfile for production-like development VMs
Diffstat (limited to 'vagrant_support/my.cnf')
-rw-r--r-- | vagrant_support/my.cnf | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/vagrant_support/my.cnf b/vagrant_support/my.cnf new file mode 100644 index 000000000..1daa4d745 --- /dev/null +++ b/vagrant_support/my.cnf @@ -0,0 +1,46 @@ +[mysqld] +datadir=/var/lib/mysql +socket=/var/lib/mysql/mysql.sock +user=mysql +# Disabling symbolic-links is recommended to prevent assorted security risks +symbolic-links=0 + +default_storage_engine = InnoDB +key_buffer_size = 32M +myisam_recover = FORCE,BACKUP +max_allowed_packet = 1G +max_connect_errors = 1000000 +innodb = FORCE +datadir = /var/lib/mysql +character-set-server = utf8 +collation-server = utf8_general_ci + +tmp_table_size = 32M +max_heap_table_size = 32M +query_cache_type = 0 +query_cache_size = 0 +max_connections = 500 +thread_cache_size = 50 +#open_files_limit = 65535 +table_definition_cache = 1024 +table_open_cache = 2048 + +innodb_flush_method = O_DIRECT +innodb_log_files_in_group = 2 +innodb_log_file_size = 256M +innodb_flush_log_at_trx_commit = 2 +innodb_file_per_table = 1 +innodb_buffer_pool_size = 1G +innodb_flush_neighbors = 0 +innodb_flush_log_at_trx_commit = 2 + +log_error = /var/lib/mysql/mysql-error.log +log_queries_not_using_indexes = 0 +slow_query_log = 0 +slow_query_log_file = /var/lib/mysql/mysql-slow.log +general_log = 0 +general_log_file = /var/lib/mysql/bmo_query.log + +[mysqld_safe] +log-error=/var/log/mysqld.log +pid-file=/var/run/mysqld/mysqld.pid |