| Index: trunk/debs/wikimedia-mysql4/debian/control |
| — | — | @@ -0,0 +1,13 @@ |
| | 2 | +Source: wikimedia-mysql4 |
| | 3 | +Section: unknown |
| | 4 | +Priority: extra |
| | 5 | +Maintainer: Domas Mituzas <domas.mituzas@gmail.com> |
| | 6 | +Build-Depends: debhelper (>= 5), autotools-dev, libncurses5-dev, g++-4.1, gcc-4.1, bison |
| | 7 | +Standards-Version: 3.7.2 |
| | 8 | + |
| | 9 | +Package: wikimedia-mysql4 |
| | 10 | +Architecture: any |
| | 11 | +Depends: libncurses5, adduser, libz1 |
| | 12 | +Provides: mysql-server |
| | 13 | +Conflicts: mysql-server-4.1, mysql-server-5.0, mysql-server-5.1 |
| | 14 | +Description: MySQL Four Oh Forever |
| Index: trunk/debs/wikimedia-mysql4/debian/dirs |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +usr/mysql-wikimedia |
| Index: trunk/debs/wikimedia-mysql4/debian/files |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +wikimedia-mysql4_4.0.40.r10-1_amd64.deb unknown extra |
| Index: trunk/debs/wikimedia-mysql4/debian/compat |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +5 |
| Index: trunk/debs/wikimedia-mysql4/debian/preinst |
| — | — | @@ -0,0 +1,56 @@ |
| | 2 | +#!/bin/sh |
| | 3 | +# preinst script for wikimedia-mysql4 |
| | 4 | +# |
| | 5 | +# see: dh_installdeb(1) |
| | 6 | + |
| | 7 | +set -e |
| | 8 | + |
| | 9 | +# summary of how this script can be called: |
| | 10 | +# * <new-preinst> `install' |
| | 11 | +# * <new-preinst> `install' <old-version> |
| | 12 | +# * <new-preinst> `upgrade' <old-version> |
| | 13 | +# * <old-preinst> `abort-upgrade' <new-version> |
| | 14 | +# for details, see http://www.debian.org/doc/debian-policy/ or |
| | 15 | +# the debian-policy package |
| | 16 | + |
| | 17 | + |
| | 18 | +case "$1" in |
| | 19 | + install|upgrade) |
| | 20 | +# creating mysql group if he isn't already there |
| | 21 | +if ! getent group mysql >/dev/null; then |
| | 22 | + # Adding system group: mysql. |
| | 23 | + addgroup --system mysql >/dev/null |
| | 24 | +fi |
| | 25 | + |
| | 26 | +# creating mysql user if he isn't already there |
| | 27 | +if ! getent passwd mysql >/dev/null; then |
| | 28 | + # Adding system user: mysql. |
| | 29 | + adduser \ |
| | 30 | + --system \ |
| | 31 | + --disabled-login \ |
| | 32 | + --ingroup mysql \ |
| | 33 | + --home /nonexistent \ |
| | 34 | + --no-create-home \ |
| | 35 | + --gecos "MySQL" \ |
| | 36 | + --shell /bin/false \ |
| | 37 | + mysql >/dev/null |
| | 38 | +fi |
| | 39 | + ;; |
| | 40 | + |
| | 41 | + abort-upgrade) |
| | 42 | + ;; |
| | 43 | + |
| | 44 | + *) |
| | 45 | + echo "preinst called with unknown argument \`$1'" >&2 |
| | 46 | + exit 1 |
| | 47 | + ;; |
| | 48 | +esac |
| | 49 | + |
| | 50 | +# dh_installdeb will replace this with shell code automatically |
| | 51 | +# generated by other debhelper scripts. |
| | 52 | + |
| | 53 | +#DEBHELPER# |
| | 54 | + |
| | 55 | +exit 0 |
| | 56 | + |
| | 57 | + |
| Index: trunk/debs/wikimedia-mysql4/debian/init.d |
| — | — | @@ -0,0 +1,25 @@ |
| | 2 | +#! /bin/sh |
| | 3 | +# |
| | 4 | + |
| | 5 | +DESC="MySQL Four Oh Forever" |
| | 6 | +NAME=mysql |
| | 7 | + |
| | 8 | +case "$1" in |
| | 9 | + start) |
| | 10 | + echo -n "Starting $DESC: " |
| | 11 | + /usr/mysql-wikimedia/bin/mysqld_safe & |
| | 12 | + ;; |
| | 13 | + stop) |
| | 14 | + echo -n "Stopping $DESC. It may take 10-20 minutes... " |
| | 15 | + killall mysqld |
| | 16 | + |
| | 17 | + ;; |
| | 18 | + *) |
| | 19 | + N=/etc/init.d/$NAME |
| | 20 | + # echo "Usage: $N {start|stop|restart|reload|force-reload}" >&2 |
| | 21 | + echo "Usage: $N {start|stop|restart|force-reload|status|force-stop}" >&2 |
| | 22 | + exit 1 |
| | 23 | + ;; |
| | 24 | +esac |
| | 25 | + |
| | 26 | +exit 0 |
| Index: trunk/debs/wikimedia-mysql4/debian/changelog |
| — | — | @@ -0,0 +1,6 @@ |
| | 2 | +wikimedia-mysql4 (4.0.40.r10-1) unstable; urgency=low |
| | 3 | + |
| | 4 | + * Initial release (Closes: #nnnn) <nnnn is the bug number of your ITP> |
| | 5 | + |
| | 6 | + -- root <domas.mituzas@gmail.com> Sat, 01 Nov 2008 19:08:50 +0000 |
| | 7 | + |
| Index: trunk/debs/wikimedia-mysql4/debian/copyright |
| — | — | @@ -0,0 +1,40 @@ |
| | 2 | +This package was debianized by root <domas.mituzas@gmail.com> on |
| | 3 | +Sat, 01 Nov 2008 19:08:50 +0000. |
| | 4 | + |
| | 5 | +It was downloaded from <url://example.com> |
| | 6 | + |
| | 7 | +Upstream Author(s): |
| | 8 | + |
| | 9 | + <put author's name and email here> |
| | 10 | + <likewise for another author> |
| | 11 | + |
| | 12 | +Copyright: |
| | 13 | + |
| | 14 | + <Copyright (C) YYYY Name OfAuthor> |
| | 15 | + <likewise for another author> |
| | 16 | + |
| | 17 | +License: |
| | 18 | + |
| | 19 | + This package is free software; you can redistribute it and/or modify |
| | 20 | + it under the terms of the GNU General Public License as published by |
| | 21 | + the Free Software Foundation; either version 2 of the License, or |
| | 22 | + (at your option) any later version. |
| | 23 | + |
| | 24 | + This package is distributed in the hope that it will be useful, |
| | 25 | + but WITHOUT ANY WARRANTY; without even the implied warranty of |
| | 26 | + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| | 27 | + GNU General Public License for more details. |
| | 28 | + |
| | 29 | + You should have received a copy of the GNU General Public License |
| | 30 | + along with this package; if not, write to the Free Software |
| | 31 | + Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA |
| | 32 | + |
| | 33 | +On Debian systems, the complete text of the GNU General |
| | 34 | +Public License can be found in `/usr/share/common-licenses/GPL'. |
| | 35 | + |
| | 36 | +The Debian packaging is (C) 2008, root <domas.mituzas@gmail.com> and |
| | 37 | +is licensed under the GPL, see above. |
| | 38 | + |
| | 39 | + |
| | 40 | +# Please also look if there are files or directories which have a |
| | 41 | +# different copyright/license attached and list them here. |
| Index: trunk/debs/wikimedia-mysql4/debian/docs |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +README |
| Index: trunk/debs/wikimedia-mysql4/debian/rules |
| — | — | @@ -0,0 +1,87 @@ |
| | 2 | +#!/usr/bin/make -f |
| | 3 | +# -*- makefile -*- |
| | 4 | +# Sample debian/rules that uses debhelper. |
| | 5 | +# This file was originally written by Joey Hess and Craig Small. |
| | 6 | +# As a special exception, when this file is copied by dh-make into a |
| | 7 | +# dh-make output file, you may use that output file without restriction. |
| | 8 | +# This special exception was added by Craig Small in version 0.37 of dh-make. |
| | 9 | + |
| | 10 | +# Uncomment this to turn on verbose mode. |
| | 11 | +#export DH_VERBOSE=1 |
| | 12 | + |
| | 13 | + |
| | 14 | +# These are used for cross-compiling and for saving the configure script |
| | 15 | +# from having to guess our platform (since we know it already) |
| | 16 | +DEB_HOST_GNU_TYPE ?= $(shell dpkg-architecture -qDEB_HOST_GNU_TYPE) |
| | 17 | +DEB_BUILD_GNU_TYPE ?= $(shell dpkg-architecture -qDEB_BUILD_GNU_TYPE) |
| | 18 | + |
| | 19 | +config.status: configure |
| | 20 | + dh_testdir |
| | 21 | + # Add here commands to configure the package. |
| | 22 | +ifneq "$(wildcard /usr/share/misc/config.sub)" "" |
| | 23 | + cp -f /usr/share/misc/config.sub config.sub |
| | 24 | +endif |
| | 25 | +ifneq "$(wildcard /usr/share/misc/config.guess)" "" |
| | 26 | + cp -f /usr/share/misc/config.guess config.guess |
| | 27 | +endif |
| | 28 | + ./configure --host=$(DEB_HOST_GNU_TYPE) --build=$(DEB_BUILD_GNU_TYPE) --prefix=/usr/mysql-wikimedia/ --mandir=\$${prefix}/share/man --infodir=\$${prefix}/share/info CFLAGS="-O3 -g" CXXFLAGS="-O3 -g" LDFLAGS="-Wl,-z,defs" CC=gcc-4.1 CXX=g++-4.1 --without-query-cache --without-docs --without-man --without-bench --with-big-tables --with-pstack --enable-assembler |
| | 29 | + |
| | 30 | + |
| | 31 | +build: build-stamp |
| | 32 | + |
| | 33 | +build-stamp: config.status |
| | 34 | + dh_testdir |
| | 35 | + |
| | 36 | + $(MAKE) -j 8 |
| | 37 | + |
| | 38 | + touch $@ |
| | 39 | + |
| | 40 | +clean: |
| | 41 | + dh_testdir |
| | 42 | + dh_testroot |
| | 43 | + rm -f build-stamp |
| | 44 | + |
| | 45 | + # Add here commands to clean up after the build process. |
| | 46 | + -$(MAKE) distclean |
| | 47 | + rm -f config.sub config.guess |
| | 48 | + |
| | 49 | + dh_clean |
| | 50 | + |
| | 51 | +install: build |
| | 52 | + dh_testdir |
| | 53 | + dh_testroot |
| | 54 | + dh_clean -k |
| | 55 | + dh_installdirs |
| | 56 | + |
| | 57 | + # Add here commands to install the package into debian/wikimedia-mysql4. |
| | 58 | + $(MAKE) DESTDIR=$(CURDIR)/debian/wikimedia-mysql4 install |
| | 59 | + install -d $(CURDIR)/debian/wikimedia-mysql4/etc/init.d |
| | 60 | + install -m 0644 debian/additions/my.cnf $(CURDIR)/debian/wikimedia-mysql4/etc/my.cnf |
| | 61 | + install -m 0755 debian/init.d $(CURDIR)/debian/wikimedia-mysql4/etc/init.d/mysql |
| | 62 | + |
| | 63 | + |
| | 64 | +# Build architecture-independent files here. |
| | 65 | +binary-indep: build install |
| | 66 | +# We have nothing to do by default. |
| | 67 | + |
| | 68 | +# Build architecture-dependent files here. |
| | 69 | +binary-arch: build install |
| | 70 | + dh_testdir |
| | 71 | + dh_testroot |
| | 72 | +# dh_installchangelogs |
| | 73 | +# dh_installdocs |
| | 74 | +# dh_installexamples |
| | 75 | +# dh_installinit |
| | 76 | + dh_link |
| | 77 | +# dh_strip |
| | 78 | + dh_compress |
| | 79 | + dh_fixperms |
| | 80 | +# dh_makeshlibs |
| | 81 | + dh_installdeb |
| | 82 | +# dh_shlibdeps |
| | 83 | + dh_gencontrol |
| | 84 | + dh_md5sums |
| | 85 | + dh_builddeb |
| | 86 | + |
| | 87 | +binary: binary-indep binary-arch |
| | 88 | +.PHONY: build clean binary-indep binary-arch binary install |
| Property changes on: trunk/debs/wikimedia-mysql4/debian/rules |
| ___________________________________________________________________ |
| Name: svn:executable |
| 1 | 89 | + * |
| Index: trunk/debs/wikimedia-mysql4/debian/info |
| — | — | @@ -0,0 +1 @@ |
| | 2 | +Docs/mysql.info |
| Index: trunk/debs/wikimedia-mysql4/debian/additions/my.cnf |
| — | — | @@ -0,0 +1,85 @@ |
| | 2 | +[client] |
| | 3 | +port = 3306 |
| | 4 | +socket = /tmp/mysql.sock |
| | 5 | + |
| | 6 | +[mysqld] |
| | 7 | + |
| | 8 | +# Start by default as reaD_only, no matter what |
| | 9 | +read_only |
| | 10 | + |
| | 11 | +datadir=/a/sqldata/ |
| | 12 | + |
| | 13 | +port = 3306 |
| | 14 | +socket = /tmp/mysql.sock |
| | 15 | + |
| | 16 | +# InnoDB does locking anyway |
| | 17 | +skip-locking |
| | 18 | + |
| | 19 | +#id = 1 + zero-filled last 4 digits of internal IP |
| | 20 | +server-id = 10000 |
| | 21 | + |
| | 22 | +log_bin |
| | 23 | + |
| | 24 | +set-variable = max_connections=2000 |
| | 25 | + |
| | 26 | +# GOOGLE OPTIONS |
| | 27 | +rpl_always_enter_innodb |
| | 28 | +rpl_transaction_enabled |
| | 29 | +temp-pool |
| | 30 | +tmpdir=/a/tmp/ |
| | 31 | +innodb_read_io_threads=8 |
| | 32 | +innodb_write_io_threads=2 |
| | 33 | + |
| | 34 | +back_log=1000 |
| | 35 | +skip-name-resolve |
| | 36 | + |
| | 37 | +log-slow-queries=slow_log |
| | 38 | +long_query_time=20 |
| | 39 | + |
| | 40 | +# Not really needed, but, oh well.. :) |
| | 41 | +slave-skip-errors=0,1213,1158,1053,1007,1062 |
| | 42 | + |
| | 43 | +# We never use MyISAM? |
| | 44 | +key_buffer_size=16M |
| | 45 | + |
| | 46 | +innodb_data_home_dir = |
| | 47 | + |
| | 48 | +# Needs adjustments for old copies |
| | 49 | +innodb_data_file_path = ibdata1:100G:autoextend |
| | 50 | + |
| | 51 | +# Reduce on non-32GB boxes |
| | 52 | +innodb_buffer_pool_size=28G |
| | 53 | +innodb_log_buffer_size=8M |
| | 54 | + |
| | 55 | +innodb_log_file_size=1000M |
| | 56 | +innodb_flush_log_at_trx_commit=0 |
| | 57 | + |
| | 58 | +innodb_file_io_threads=8 |
| | 59 | +innodb_lock_wait_timeout=10 |
| | 60 | +innodb_thread_concurrency=500 |
| | 61 | +innodb_additional_mem_pool_size=16M |
| | 62 | + |
| | 63 | +sort_buffer_size=8M |
| | 64 | +join_buffer_size=8M |
| | 65 | +max_heap_table_size=32M |
| | 66 | +read_buffer_size=8M |
| | 67 | +read_rnd_buffer_size=8M |
| | 68 | +tmp_table_size=32M |
| | 69 | +max_tmp_tables=10 |
| | 70 | + |
| | 71 | +# Data dictionary wastes space anyway ;) |
| | 72 | +table_cache=40000 |
| | 73 | +thread_cache=300 |
| | 74 | + |
| | 75 | +max_allowed_packet=16M |
| | 76 | +max_connect_errors=40000 |
| | 77 | +max_binlog_cache_size=512M |
| | 78 | +max_join_size=60000M |
| | 79 | +wait_timeout=900 |
| | 80 | + |
| | 81 | +[mysqldump] |
| | 82 | +quick |
| | 83 | +max_allowed_packet=16M |
| | 84 | + |
| | 85 | +[mysql] |
| | 86 | +no-auto-rehash |