[debian-mysql] [RFC PATCH 4/9] Add mysql-common
Robie Basak
robie.basak at canonical.com
Wed Aug 13 17:03:46 UTC 2014
To be removed from src:mysql-5.5.
---
debian/additions/my.cnf | 127 ++++++++++++++++++++++++++++++++++++++++++++
debian/control | 13 +++++
debian/mysql-common.dirs | 1 +
debian/mysql-common.install | 2 +
debian/mysql-common.postrm | 9 ++++
debian/rules | 2 -
6 files changed, 152 insertions(+), 2 deletions(-)
create mode 100644 debian/additions/my.cnf
create mode 100644 debian/mysql-common.dirs
create mode 100644 debian/mysql-common.install
create mode 100644 debian/mysql-common.postrm
diff --git a/debian/additions/my.cnf b/debian/additions/my.cnf
new file mode 100644
index 0000000..4df5bd0
--- /dev/null
+++ b/debian/additions/my.cnf
@@ -0,0 +1,127 @@
+#
+# The MySQL database server configuration file.
+#
+# You can copy this to one of:
+# - "/etc/mysql/my.cnf" to set global options,
+# - "~/.my.cnf" to set user-specific options.
+#
+# One can use all long options that the program supports.
+# Run program with --help to get a list of available options and with
+# --print-defaults to see which it would actually understand and use.
+#
+# For explanations see
+# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
+
+# This will be passed to all mysql clients
+# It has been reported that passwords should be enclosed with ticks/quotes
+# escpecially if they contain "#" chars...
+# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
+[client]
+port = 3306
+socket = /var/run/mysqld/mysqld.sock
+
+# Here is entries for some specific programs
+# The following values assume you have at least 32M ram
+
+# This was formally known as [safe_mysqld]. Both versions are currently parsed.
+[mysqld_safe]
+socket = /var/run/mysqld/mysqld.sock
+nice = 0
+
+[mysqld]
+#
+# * Basic Settings
+#
+user = mysql
+pid-file = /var/run/mysqld/mysqld.pid
+socket = /var/run/mysqld/mysqld.sock
+port = 3306
+basedir = /usr
+datadir = /var/lib/mysql
+tmpdir = /tmp
+lc-messages-dir = /usr/share/mysql
+skip-external-locking
+#
+# 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
+#
+key_buffer = 16M
+max_allowed_packet = 16M
+thread_stack = 192K
+thread_cache_size = 8
+# This replaces the startup script and checks MyISAM tables if needed
+# the first time they are touched
+myisam-recover = BACKUP
+#max_connections = 100
+#table_cache = 64
+#thread_concurrency = 10
+#
+# * Query Cache Configuration
+#
+query_cache_limit = 1M
+query_cache_size = 16M
+#
+# * Logging and Replication
+#
+# Both location gets rotated by the cronjob.
+# Be aware that this log type is a performance killer.
+# As of 5.1 you can enable the log at runtime!
+#general_log_file = /var/log/mysql/mysql.log
+#general_log = 1
+#
+# Error log - should be very few entries.
+#
+log_error = /var/log/mysql/error.log
+#
+# 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!
+#
+# * 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
+
+[isamchk]
+key_buffer = 16M
+
+#
+# * IMPORTANT: Additional settings that can override those from this file!
+# The files must end with '.cnf', otherwise they'll be ignored.
+#
+!includedir /etc/mysql/conf.d/
diff --git a/debian/control b/debian/control
index a449b1e..83f6fdc 100644
--- a/debian/control
+++ b/debian/control
@@ -84,6 +84,19 @@ Description: MySQL database development files
.
This package includes development libraries and header files.
+Package: mysql-common
+Architecture: all
+Depends: ${misc:Depends}, ${shlibs:Depends}
+Multi-Arch: foreign
+Description: MySQL database common files, e.g. /etc/mysql/my.cnf
+ MySQL is a fast, stable and true multi-user, multi-threaded SQL database
+ server. SQL (Structured Query Language) is the most popular database query
+ language in the world. The main goals of MySQL are speed, robustness and
+ ease of use.
+ .
+ This package includes files needed by all versions of the client library,
+ e.g. /etc/mysql/my.cnf.
+
Package: mysql-common-5.6
Architecture: all
Depends: mysql-common, ${misc:Depends}, ${shlibs:Depends}
diff --git a/debian/mysql-common.dirs b/debian/mysql-common.dirs
new file mode 100644
index 0000000..a5a88ed
--- /dev/null
+++ b/debian/mysql-common.dirs
@@ -0,0 +1 @@
+etc/mysql/conf.d/
diff --git a/debian/mysql-common.install b/debian/mysql-common.install
new file mode 100644
index 0000000..f77a066
--- /dev/null
+++ b/debian/mysql-common.install
@@ -0,0 +1,2 @@
+debian/additions/my.cnf etc/mysql/
+debian/tmp/etc/mysql/conf.d/.keepme etc/mysql/conf.d
diff --git a/debian/mysql-common.postrm b/debian/mysql-common.postrm
new file mode 100644
index 0000000..8b12d46
--- /dev/null
+++ b/debian/mysql-common.postrm
@@ -0,0 +1,9 @@
+#!/bin/bash
+
+set -e
+
+if [ "$1" = "purge" ]; then
+ rmdir /etc/mysql 2>/dev/null || true
+fi
+
+#DEBHELPER#
diff --git a/debian/rules b/debian/rules
index df560e2..53da4cf 100755
--- a/debian/rules
+++ b/debian/rules
@@ -196,8 +196,6 @@ auto_install-stamp:
chmod 0644 $(TMP)/usr/share/mysql-test/suite/parts/r/partition_exch_qa*.result
chmod 0644 $(TMP)/usr/share/mysql-test/suite/sys_vars/r/sort_buffer_size_basic_32.result
chmod 0644 $(TMP)/usr/share/mysql/innodb_memcached_config.sql
- # getting rid of other extra files
- rm -f $(TMP)/etc/mysql/conf.d/.keepme
touch $@
# Use the --fail-missing to check for stuff that we should be installing
--
1.9.1
More information about the pkg-mysql-maint
mailing list