summaryrefslogtreecommitdiffstats
path: root/vagrant_support/my.cnf
diff options
context:
space:
mode:
authorDylan William Hardison <dylan@hardison.net>2017-04-14 19:05:03 +0200
committerDylan William Hardison <dylan@hardison.net>2017-04-14 19:10:20 +0200
commit4a130afba58836ebb2f70a31c88588ea46017009 (patch)
tree200816c2c7525e76228559e6b0ee81dc46980c14 /vagrant_support/my.cnf
parent480bbf368b485a6a0317b9356ce90b75201b3efa (diff)
downloadbugzilla-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.cnf46
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