diff options
author | unknown <knielsen@knielsen-hq.org> | 2012-01-26 12:55:12 +0100 |
---|---|---|
committer | unknown <knielsen@knielsen-hq.org> | 2012-01-26 12:55:12 +0100 |
commit | 438ed0408c69faa9e5c4c026e24ef52eac62f08e (patch) | |
tree | 64c77b9ce8796cfc9147ca75b1176365a045e9d9 /debian/additions | |
parent | 6f142ee51c86032b14b89252ffbe9b44e4d677a7 (diff) | |
download | mariadb-git-438ed0408c69faa9e5c4c026e24ef52eac62f08e.tar.gz |
.deb packaging fixes: make mariadb-common a real package, which depends on
mysql-common and places mariadb-specific stuff in /etc/mysql/conf.d/mariadb.cnf.
This should allow to co-exist with default Debian mysql-common package and
help resolve dependencies when installing mariadb among multiple available
versions of MySQL from different repositories.
Diffstat (limited to 'debian/additions')
-rw-r--r-- | debian/additions/mariadb.cnf | 36 | ||||
-rw-r--r-- | debian/additions/my.cnf | 38 |
2 files changed, 36 insertions, 38 deletions
diff --git a/debian/additions/mariadb.cnf b/debian/additions/mariadb.cnf new file mode 100644 index 00000000000..12db9581469 --- /dev/null +++ b/debian/additions/mariadb.cnf @@ -0,0 +1,36 @@ +# MariaDB-specific config file. +# Read by /etc/mysql/my.cnf + +[client] +# Default is Latin1, if you need UTF-8 set this (also in server section) +#default-character-set = utf8 + +[mysqld] +# +# * Character sets +# +# Default is Latin1, if you need UTF-8 set all this (also in client section) +# +#default-character-set = utf8 +#default-collation = utf8_general_ci +#character_set_server = utf8 +#collation_server = utf8_general_ci +# +# * Fine Tuning +# +max_connections = 100 +connect_timeout = 5 +wait_timeout = 600 +sort_buffer_size = 4M +bulk_insert_buffer_size = 16M +tmp_table_size = 32M +max_heap_table_size = 32M +# +# * MyISAM +# +key_buffer_size = 128M +table_cache = 400 +myisam_sort_buffer_size = 512M +concurrent_insert = 2 +read_buffer_size = 2M +read_rnd_buffer_size = 1M diff --git a/debian/additions/my.cnf b/debian/additions/my.cnf index 1a176cc1dc1..ed19dcf5fc9 100644 --- a/debian/additions/my.cnf +++ b/debian/additions/my.cnf @@ -1,19 +1,5 @@ # MariaDB database server configuration file. # -# ================================================================= -# Base configuration courtesy of Open Query (http://openquery.com/) -# For production use, case-specific preparation is still required. -# 2009-10-07 -# -# This is *not* an optimised config, merely a more sane baseline: -# - InnoDB default (e.g., ACID out-of-the-box, same as on Windows) -# - strict mode (for proper input checks, same as on Windows) -# - various other useful settings -# - make use of MariaDB/Percona/OurDelta enhancements/extensions -# -# For tuning assistance, please see http://openquery.com/services -# ================================================================= -# # You can copy this file to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. @@ -32,8 +18,6 @@ [client] port = 3306 socket = /var/run/mysqld/mysqld.sock -# Default is Latin1, if you need UTF-8 set this (also in server section) -#default-character-set = utf8 # Here is entries for some specific programs # The following values assume you have at least 32M ram @@ -58,43 +42,21 @@ lc_messages_dir = /usr/share/mysql lc_messages = en_US skip-external-locking # -# * Character sets -# -# Default is Latin1, if you need UTF-8 set all this (also in client section) -# -#default-character-set = utf8 -#default-collation = utf8_general_ci -#character_set_server = utf8 -#collation_server = utf8_general_ci -# # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1 # # * Fine Tuning # -max_connections = 100 -connect_timeout = 5 -wait_timeout = 600 max_allowed_packet = 16M thread_cache_size = 128 -sort_buffer_size = 4M -bulk_insert_buffer_size = 16M -tmp_table_size = 32M -max_heap_table_size = 32M # # * MyISAM # # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched. On error, make copy and try a repair. myisam_recover = BACKUP -key_buffer_size = 128M #open-files-limit = 2000 -table_cache = 400 -myisam_sort_buffer_size = 512M -concurrent_insert = 2 -read_buffer_size = 2M -read_rnd_buffer_size = 1M # # * Query Cache Configuration # |