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 @@