head 1.14;
access;
symbols
OPENPKG_E1_MP_HEAD:1.12
OPENPKG_E1_MP:1.12
OPENPKG_E1_MP_2_STABLE:1.11.12.1
OPENPKG_E1_FP:1.11.12.1
OPENPKG_2_STABLE_MP:1.12
OPENPKG_2_STABLE_20061018:1.11.12.1
OPENPKG_2_STABLE_20060622:1.11
OPENPKG_2_STABLE:1.11.0.12
OPENPKG_2_STABLE_BP:1.11
OPENPKG_2_5_RELEASE:1.11
OPENPKG_2_5_SOLID:1.11.0.10
OPENPKG_2_5_SOLID_BP:1.11
OPENPKG_2_4_RELEASE:1.11
OPENPKG_2_4_SOLID:1.11.0.8
OPENPKG_2_4_SOLID_BP:1.11
OPENPKG_CW_FP:1.11
OPENPKG_2_3_RELEASE:1.11
OPENPKG_2_3_SOLID:1.11.0.6
OPENPKG_2_3_SOLID_BP:1.11
OPENPKG_2_2_RELEASE:1.11
OPENPKG_2_2_SOLID:1.11.0.4
OPENPKG_2_2_SOLID_BP:1.11
OPENPKG_2_1_RELEASE:1.11
OPENPKG_2_1_SOLID:1.11.0.2
OPENPKG_2_1_SOLID_BP:1.11
OPENPKG_2_0_RELEASE:1.10
OPENPKG_2_0_SOLID:1.10.0.2
OPENPKG_2_0_SOLID_BP:1.10
OPENPKG_1_3_RELEASE:1.5.2.2
OPENPKG_1_3_SOLID:1.5.2.2.0.2
OPENPKG_1_3_SOLID_BP:1.5.2.2
OPENPKG_1_STABLE_MP:1.9
OPENPKG_1_2_RELEASE:1.5
OPENPKG_1_2_SOLID:1.5.0.4
OPENPKG_1_2_SOLID_BP:1.5
OPENPKG_1_STABLE:1.5.0.2
OPENPKG_1_STABLE_BP:1.5
OPENPKG_1_1_RELEASE:1.2
OPENPKG_1_1_SOLID:1.2.0.2
OPENPKG_1_1_SOLID_BP:1.2
OPENPKG_1_0_RELEASE:1.1.1.1
OPENPKG_1_0_SOLID:1.1.1.1.0.2
OPENPKG_1_0_SOLID_BP:1.1.1.1
OPENPKG_0_0:1.1.1.1
OPENPKG:1.1.1;
locks; strict;
comment @# @;
1.14
date 2008.11.28.21.10.12; author rse; state Exp;
branches;
next 1.13;
commitid 5zjSaDmRuGREeqst;
1.13
date 2007.04.13.08.48.18; author cs; state Exp;
branches;
next 1.12;
commitid UmlN7ixHoCsUfTds;
1.12
date 2006.10.16.10.55.50; author rse; state Exp;
branches;
next 1.11;
commitid E52VlgkbevyoITQr;
1.11
date 2004.06.05.12.30.04; author cs; state Exp;
branches
1.11.12.1;
next 1.10;
1.10
date 2004.01.05.14.10.43; author rse; state Exp;
branches;
next 1.9;
1.9
date 2003.06.09.11.37.53; author rse; state Exp;
branches;
next 1.8;
1.8
date 2003.05.05.13.47.41; author cs; state Exp;
branches;
next 1.7;
1.7
date 2003.05.04.09.25.13; author cs; state Exp;
branches;
next 1.6;
1.6
date 2003.03.24.20.08.34; author rse; state Exp;
branches;
next 1.5;
1.5
date 2003.01.16.08.35.07; author rse; state Exp;
branches
1.5.2.1;
next 1.4;
1.4
date 2003.01.10.12.23.55; author mlelstv; state Exp;
branches;
next 1.3;
1.3
date 2002.12.04.10.02.43; author mlelstv; state Exp;
branches;
next 1.2;
1.2
date 2002.02.07.14.21.02; author rse; state Exp;
branches
1.2.2.1;
next 1.1;
1.1
date 2001.09.18.09.48.29; author rse; state Exp;
branches
1.1.1.1;
next ;
1.11.12.1
date 2006.10.16.14.53.04; author rse; state Exp;
branches;
next ;
commitid iZxwRSmmWscPXUQr;
1.5.2.1
date 2003.06.09.11.24.04; author rse; state Exp;
branches;
next 1.5.2.2;
1.5.2.2
date 2003.07.24.20.44.33; author rse; state Exp;
branches;
next ;
1.2.2.1
date 2003.03.18.15.33.58; author mlelstv; state Exp;
branches;
next 1.2.2.2;
1.2.2.2
date 2003.03.19.07.58.40; author mlelstv; state Exp;
branches;
next 1.2.2.3;
1.2.2.3
date 2003.03.20.15.10.47; author mlelstv; state Exp;
branches;
next ;
1.1.1.1
date 2001.09.18.09.48.29; author rse; state Exp;
branches;
next ;
desc
@@
1.14
log
@upgrade to MySQL 5.1
@
text
@##
## my.cnf -- MySQL configuration
##
[client]
socket = @@l_prefix@@/var/mysql/mysql.sock
port = 3306
[mysqld]
bind-address = 127.0.0.1
port = 3306
#skip-networking
tmpdir = @@l_prefix@@/var/mysql/tmp
log = @@l_prefix@@/var/mysql/common.log
#log-bin = @@l_prefix@@/var/mysql/binary.log
#server-id = 1
key_buffer_size = 64M
table_cache = 256
join_buffer_size = 1M
max_connections = 1000
max_connect_errors = 10
max_delayed_threads = 20
max_heap_table_size = 16777216
max_sort_length = 1024
max_user_connections = 1000
record_buffer = 131072
sort_buffer = 4M
key_buffer = 1M
tmp_table_size = 32M
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 32M
ft_min_word_len = 3
innodb_buffer_pool_size = 70M
innodb_additional_mem_pool_size = 2M
innodb_log_files_in_group = 3
innodb_log_file_size = 20M
innodb_log_buffer_size = 8M
innodb_lock_wait_timeout = 50
[mysqld_safe]
datadir = @@l_prefix@@/var/mysql
socket = @@l_prefix@@/var/mysql/mysql.sock
pid_file = @@l_prefix@@/var/mysql/mysqld.pid
user = @@l_rusr@@
basedir = @@l_prefix@@
@
1.13
log
@removed deprecated update log
@
text
@a38 6
bdb_cache_size = 8M
bdb_log_buffer_size = 32k
bdb_max_lock = 10000
@
1.12
log
@finally align the mysql package with mysql51 as close as possible to cause just one instead of two upgrade issues
@
text
@a17 1
log-update = @@l_prefix@@/var/mysql/update.log
@
1.11
log
@default config changes; provide directory for temporary tables
@
text
@d6 3
a8 2
socket = @@l_prefix@@/var/mysql/mysql.sock
port = 3306
a10 6
#
# Network settings
#
bind-address = 127.0.0.1
port = 3306
d12 2
a13 1
# Unix domain socket only, disables TCP/IP
d16 37
a52 59
#
# Log file settings
#
# log file destinations (must be in sync with settings in rc.conf)
log = @@l_prefix@@/var/mysql/common.log
log-update = @@l_prefix@@/var/mysql/update.log
# binary log (use instead of log-update, server-id must be unique for
# replication)
#log-bin = @@l_prefix@@/var/mysql/binary.log
#server-id = 1
#
# Performance settings
#
# most important tuning parameters for mysqld
set-variable = key_buffer_size=64M
set-variable = table_cache=256
# less important tuning parameters (change if special problems occur)
set-variable = join_buffer_size=1M
set-variable = max_connections=1000
set-variable = max_connect_errors=10
set-variable = max_delayed_threads=20
set-variable = max_heap_table_size=16777216
set-variable = max_sort_length=1024
set-variable = max_user_connections=1000
set-variable = record_buffer=131072
set-variable = sort_buffer=4M
set-variable = key_buffer=1M
set-variable = tmp_table_size=32M
# permanent query caching
set-variable = query_cache_type=1
# maximum caching size of an individual query
set-variable = query_cache_limit=1M
# maximum query cache size
set-variable = query_cache_size=32M
# minimum chars for full-text search (FTS) index
#ft_min_word_len=3
# Berkeley DB
set-variable = bdb_cache_size=@@l_mysql_bdb_cache_size@@
set-variable = bdb_log_buffer_size=@@l_mysql_bdb_log_buffer_size@@
set-variable = bdb_max_lock=@@l_mysql_bdb_max_lock@@
# Innobase DB
#set-variable = innodb_buffer_pool_size=70M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=20M
#set-variable = innodb_log_buffer_size=8M
#set-variable = innodb_lock_wait_timeout=50
#
# Miscellaneous
#
d54 2
a55 2
# directory for temporary tables
tmpdir=@@l_prefix@@/var/mysql/tmp
d57 5
a61 6
[mysqld_safe]
datadir = @@l_prefix@@/var/mysql
socket = @@l_prefix@@/var/mysql/mysql.sock
set-variable = pid_file=@@l_prefix@@/var/mysql/mysqld.pid
user = @@l_rusr@@
basedir = @@l_prefix@@
@
1.11.12.1
log
@Mass merge from CURRENT to 2-STABLE (all packages except those of JUNK class)
@
text
@d6 2
d9 4
a12 2
socket = @@l_prefix@@/var/mysql/mysql.sock
port = 3306
d14 2
a15 1
[mysqld]
d17 1
a17 2
bind-address = 127.0.0.1
port = 3306
d20 62
a81 37
tmpdir = @@l_prefix@@/var/mysql/tmp
log = @@l_prefix@@/var/mysql/common.log
log-update = @@l_prefix@@/var/mysql/update.log
#log-bin = @@l_prefix@@/var/mysql/binary.log
#server-id = 1
key_buffer_size = 64M
table_cache = 256
join_buffer_size = 1M
max_connections = 1000
max_connect_errors = 10
max_delayed_threads = 20
max_heap_table_size = 16777216
max_sort_length = 1024
max_user_connections = 1000
record_buffer = 131072
sort_buffer = 4M
key_buffer = 1M
tmp_table_size = 32M
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 32M
ft_min_word_len = 3
bdb_cache_size = 8M
bdb_log_buffer_size = 32k
bdb_max_lock = 10000
innodb_buffer_pool_size = 70M
innodb_additional_mem_pool_size = 2M
innodb_log_files_in_group = 3
innodb_log_file_size = 20M
innodb_log_buffer_size = 8M
innodb_lock_wait_timeout = 50
a82 1
d84 5
a88 6
datadir = @@l_prefix@@/var/mysql
socket = @@l_prefix@@/var/mysql/mysql.sock
pid_file = @@l_prefix@@/var/mysql/mysqld.pid
user = @@l_rusr@@
basedir = @@l_prefix@@
@
1.10
log
@cleanup config file
@
text
@d10 4
d16 9
a24 1
# logfile destinations (overwrite values of rc.mysql in rc.conf accordingly)
d27 2
a28 1
# binary log (use instead of log-update, server-id must be unique for replication)
d32 3
a34 6
[mysqld_safe]
datadir = @@l_prefix@@/var/mysql
socket = @@l_prefix@@/var/mysql/mysql.sock
set-variable = pid_file=@@l_prefix@@/var/mysql/mysqld.pid
user = @@l_rusr@@
basedir = @@l_prefix@@
d37 2
a38 2
set-variable = key_buffer_size=16M
set-variable = table_cache=64
d49 1
a49 2
set-variable = record_rnd_buffer=131072
set-variable = sort_buffer=2M
d53 10
d76 14
@
1.9
log
@Following our general rules for dealing with versioned packages (and
the fact that we only want _one_ single version in each release, of
course), the old (MySQL-3 based) "mysql" package was first merged up to
1-STABLE (for possible inclusion into OpenPKG 1.3), then "mysql" was
renamed to "mysql3" (in case you still have to drive MySQL 3 within
OpenPKG-CURRENT), "mysql4" become "mysql" and "mysql4" has gone.
@
text
@d15 1
a15 2
# binary log
# use instead of log-update, server-id must be unique for replication
a18 1
a36 1
# for max_user_connections=0 (unlimited) comment out the following line
d49 1
a49 1
# Innobase
a55 3
#innodb_data_home_dir =
#innodb_data_file_path = @@innodb_data_file_path@@
#innodb_flush_log_at_trx_commit = 1
@
1.8
log
@fixed comment
@
text
@d12 8
d21 1
a21 1
[safe_mysqld]
a27 4
# logfile destinations (overwrite values of rc.mysql in rc.conf accordingly)
log = @@l_prefix@@/var/mysql/common.log
log-update = @@l_prefix@@/var/mysql/update.log
d32 1
a32 1
# less important tuning paramaters (change if special problems occur)
d39 2
a40 1
set-variable = max_user_connections=0
@
1.7
log
@fixed interface binding
@
text
@d20 1
a20 1
# logfile destinations (update rc.mysql accordingly)
@
1.6
log
@speclint police: no need to use macros here, shell variables are sufficient
@
text
@d9 4
a16 2
host = 127.0.0.1
port = 3306
@
1.5
log
@cleanup package and make sure it binds to 127.0.0.1 by default
@
text
@d41 3
a43 3
set-variable = bdb_cache_size=@@mysql_bdb_cache_size@@
set-variable = bdb_log_buffer_size=@@mysql_bdb_log_buffer_size@@
set-variable = bdb_max_lock=@@mysql_bdb_max_lock@@
@
1.5.2.1
log
@merge last MySQL 3 state up to 1-STABLE branch for possible inclusion into OpenPKG 1.3
@
text
@a8 4
[mysqld]
bind-address = 127.0.0.1
port = 3306
d13 2
d18 1
a18 1
# logfile destinations (overwrite values of rc.mysql in rc.conf accordingly)
d41 3
a43 3
set-variable = bdb_cache_size=@@l_mysql_bdb_cache_size@@
set-variable = bdb_log_buffer_size=@@l_mysql_bdb_log_buffer_size@@
set-variable = bdb_max_lock=@@l_mysql_bdb_max_lock@@
@
1.5.2.2
log
@mass Merge-From-CURRENT (MFC) in preparation for OpenPKG 1.3 [class BASE only]
@
text
@a11 8
# logfile destinations (overwrite values of rc.mysql in rc.conf accordingly)
log = @@l_prefix@@/var/mysql/common.log
log-update = @@l_prefix@@/var/mysql/update.log
# binary log
# use instead of log-update, server-id must be unique for replication
#log-bin = @@l_prefix@@/var/mysql/binary.log
#server-id = 1
d13 1
a13 1
[mysqld_safe]
d20 4
d28 1
a28 1
# less important tuning parameters (change if special problems occur)
d35 1
a35 2
# for max_user_connections=0 (unlimited) comment out the following line
set-variable = max_user_connections=1000
@
1.4
log
@fix default settings, now hardcodes @@l_prefix@@/etc/mysql instead of /etc
@
text
@d1 4
d13 1
d18 1
a18 1
# Logfile destinations - you must update rc.mysql accordingly
d22 1
a22 1
# these are the most important tuning parameters for mysqld
d26 1
a26 1
# change these parameters if special problems occur
d40 1
a40 6
#
# BERKELEY DB
#
# memory parameters - set these to values <> 0 if bdb
# tables are used
d45 1
a45 21
#
# INNOBASE
#
# The common part of the directory path for all InnoDB datafiles.
# default is the mysql data directory
#innodb_data_home_dir =
# Tablespaces
# specify a list of pathtodatafile:sizespecification separated
# by semicolon. The last datafile can have options
# - :autoextend increment datafile in 8M chunks
# - :max:sizespecification max size of the datafile
#innodb_data_file_path=@@innodb_data_file_path@@
# Tunings
# Set buffer pool size to 50 -80 % of your computer's memory
# Set the log file size to about 25 % of the buffer pool size
# Set ..flush_log_at_trx_commit to 0 if you can afford losing
# some last transactions
# Set innodb_lock_wait_timeout to bail out of external deadlocks
a50 1
#innodb_flush_log_at_trx_commit=1
d52 3
@
1.3
log
@config + maintenance tasks
@
text
@d1 3
d6 2
a7 2
datadir = @@l_prefix@@/var/mysql/db
socket = @@l_prefix@@/var/mysql/mysqld.sock
a8 1
set-variable = max_connections=1000
@
1.2
log
@Switch to l_{s,m,r,n}{usr,grp}.
@
text
@d2 1
a2 1
[mysqld]
d8 1
a8 1
user = @@l_musr@@
d10 61
@
1.2.2.1
log
@SA-2003.022 backport from mysql-3.23.56, align standard configuration, old config didn't work anyway
@
text
@d2 1
a2 1
[safe_mysqld]
d8 1
a8 1
user = @@l_rusr@@
@
1.2.2.2
log
@add missing fix from 3.23.56
@
text
@d3 1
a3 1
datadir = @@l_prefix@@/var/mysql
@
1.2.2.3
log
@fix socket path
@
text
@d4 1
a4 1
socket = @@l_prefix@@/var/mysql/mysql.sock
@
1.1
log
@Initial revision
@
text
@d8 1
a8 1
user = @@l_fsusr@@
@
1.1.1.1
log
@Import OpenPKG sources into CVS repository
@
text
@@