diff options
| author | Guilhem Moulin <guilhem@fripost.org> | 2017-06-15 11:21:53 +0200 |
|---|---|---|
| committer | Guilhem Moulin <guilhem@fripost.org> | 2017-06-15 11:21:53 +0200 |
| commit | 964d5a81ebd010c6f2c42b9c106e1a9652804b30 (patch) | |
| tree | 4d7324daefb7bf24596d9711659a5ba692dc1f37 /roles/common-SQL/files | |
| parent | 7d3a9a5340d5faae1347bf010c193c36e1771fa1 (diff) | |
MySQL: Use a single InnoDB file per table.
Diffstat (limited to 'roles/common-SQL/files')
| -rw-r--r-- | roles/common-SQL/files/etc/mysql/my.cnf | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/roles/common-SQL/files/etc/mysql/my.cnf b/roles/common-SQL/files/etc/mysql/my.cnf index c5c9454..6caeb64 100644 --- a/roles/common-SQL/files/etc/mysql/my.cnf +++ b/roles/common-SQL/files/etc/mysql/my.cnf @@ -82,40 +82,41 @@ query_cache_size = 16M #log_slow_queries = /var/log/mysql/mysql-slow.log #long_query_time = 2 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about # other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! innodb_flush_method = O_DIRECT +innodb_file_per_table = 1 # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] |