OpenPKG CVS Repository
http://cvs.openpkg.org/
____________________________________________________________________________
Server: cvs.openpkg.org Name: Christoph Schug
Root: /e/openpkg/cvs Email: [EMAIL PROTECTED]
Module: openpkg-src Date: 05-Jun-2004 14:30:06
Branch: HEAD Handle: 2004060513300400
Modified files:
openpkg-src/mysql my.cnf mysql.spec
Log:
default config changes; provide directory for temporary tables
Summary:
Revision Changes Path
1.11 +45 -12 openpkg-src/mysql/my.cnf
1.94 +6 -2 openpkg-src/mysql/mysql.spec
____________________________________________________________________________
patch -p0 <<'@@ .'
Index: openpkg-src/mysql/my.cnf
============================================================================
$ cvs diff -u -r1.10 -r1.11 my.cnf
--- openpkg-src/mysql/my.cnf 5 Jan 2004 14:10:43 -0000 1.10
+++ openpkg-src/mysql/my.cnf 5 Jun 2004 12:30:04 -0000 1.11
@@ -7,25 +7,35 @@
port = 3306
[mysqld]
+#
+# Network settings
+#
+
bind-address = 127.0.0.1
port = 3306
-# logfile destinations (overwrite values of rc.mysql in rc.conf accordingly)
+
+# Unix domain socket only, disables TCP/IP
+#skip-networking
+
+#
+# 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)
+# 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
-[mysqld_safe]
-datadir = @l_prefix@/var/mysql
-socket = @l_prefix@/var/mysql/mysql.sock
-set-variable = [EMAIL PROTECTED]@/var/mysql/mysqld.pid
-user = @l_rusr@
-basedir = @l_prefix@
+#
+# Performance settings
+#
# most important tuning parameters for mysqld
-set-variable = key_buffer_size=16M
-set-variable = table_cache=64
+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
@@ -36,11 +46,20 @@
set-variable = max_sort_length=1024
set-variable = max_user_connections=1000
set-variable = record_buffer=131072
-set-variable = record_rnd_buffer=131072
-set-variable = sort_buffer=2M
+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 = [EMAIL PROTECTED]@
set-variable = [EMAIL PROTECTED]@
@@ -54,3 +73,17 @@
#set-variable = innodb_log_buffer_size=8M
#set-variable = innodb_lock_wait_timeout=50
+#
+# Miscellaneous
+#
+
+# directory for temporary tables
[EMAIL PROTECTED]@/var/mysql/tmp
+
+[mysqld_safe]
+datadir = @l_prefix@/var/mysql
+socket = @l_prefix@/var/mysql/mysql.sock
+set-variable = [EMAIL PROTECTED]@/var/mysql/mysqld.pid
+user = @l_rusr@
+basedir = @l_prefix@
+
@@ .
patch -p0 <<'@@ .'
Index: openpkg-src/mysql/mysql.spec
============================================================================
$ cvs diff -u -r1.93 -r1.94 mysql.spec
--- openpkg-src/mysql/mysql.spec 18 May 2004 07:21:08 -0000 1.93
+++ openpkg-src/mysql/mysql.spec 5 Jun 2004 12:30:04 -0000 1.94
@@ -40,7 +40,7 @@
Group: Database
License: GPL
Version: %{V_opkg}
-Release: 20040518
+Release: 20040605
# package options
%option with_bdb yes
@@ -191,12 +191,16 @@
# make sure the database directory exists
%{l_shtool} mkdir -f -p -m 755 $RPM_BUILD_ROOT%{l_prefix}/var/mysql
+ # directory for temporary tables
+ %{l_shtool} mkdir -f -p -m 700 $RPM_BUILD_ROOT%{l_prefix}/var/mysql/tmp
+
# determine the package files
%{l_rpmtool} files -v -ofiles -r$RPM_BUILD_ROOT \
%{l_files_std} \
'%config %{l_prefix}/etc/mysql/my.cnf' \
'%config %{l_prefix}/etc/mysql/my.pwd' \
- '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/mysql'
+ '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/mysql' \
+ '%attr(-,%{l_rusr},%{l_rgrp}) %{l_prefix}/var/mysql/tmp'
%files -f files
@@ .
______________________________________________________________________
The OpenPKG Project www.openpkg.org
CVS Repository Commit List [EMAIL PROTECTED]
