diff options
| author | Guilhem Moulin <guilhem@fripost.org> | 2016-05-12 11:34:42 +0200 |
|---|---|---|
| committer | Guilhem Moulin <guilhem@fripost.org> | 2016-05-12 11:34:42 +0200 |
| commit | 0ccfc6d389ec8677bff0de0798ef4f7f5312d5ee (patch) | |
| tree | 37d8e7cf4f0e515c1646ee0ed959e39cb48724b6 | |
| parent | e51921b1242b40eefd16f29bcc408c6ac0df1619 (diff) | |
MySQL: set flush InnoDB flush method to 'O_DIRECT'
| -rw-r--r-- | roles/common-SQL/files/etc/mysql/my.cnf | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/roles/common-SQL/files/etc/mysql/my.cnf b/roles/common-SQL/files/etc/mysql/my.cnf index 909236d..c5c9454 100644 --- a/roles/common-SQL/files/etc/mysql/my.cnf +++ b/roles/common-SQL/files/etc/mysql/my.cnf @@ -80,41 +80,43 @@ query_cache_size = 16M # # Here you can see queries with especially long duration #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 + # * 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] #no-auto-rehash # faster start of mysql but no tab completition |