Merge lp:~arjen-lentz/maria/5.2-zapoldsamplecnfs into lp:maria/5.3

[Arjen Lentz]

Sorting out the old troublesome my-*.cnf files, replacing with single my-example.cnf baseline config.
Also adjusted in-tree build scripts/makefiles and docs.

The baseline example I've used comes from the MariaDB DEB (Debian/Ubuntu) packaging that's already being used currently, and we can adjust it further.

The new MariaDB packaging/build system tree should also be adjusted to use this file, replacing the old separate copy in the debian/ subdir.

[Sergei Golubchik (sergii)]

It's too debian specific, has hard-coded paths that are not universally valid.

why basedir=/usr?
 I'd either use @basedir@ or nothing at all.

is concurrent_insert=2 a reasoable default?
I'd say that 1 is safer as a default value.

datadir=@localstatedir@ may be debian's default, but is it MySQL or MariaDB default?
perhaps it'd be better to remove this line.

language = /usr/share/mysql/english
this won't do. should be something like @datarootdir@/mysql/english

same for pid_file path

no need to specify log_bin_index - you set it to the default value anyway

I'd remove @localstatedir@ from many paths (e.g. from log_bin or
log_slow_path), specifying simply log_bin=mariadb_bin will have exactly the
same effect, but the config file will be simpler and easier to relocate, if
needed.

review: Needs Fixing

Unmerged revisions

2948. By Arjen Lentz on 2011-03-31

Removed troublesome old sample configs, replaced with single baseline config from MariaDB DEB packaging
Adjusted related in-tree build scripts accordingly.

=== modified file 'CMakeLists.txt'
--- CMakeLists.txt	2011-03-10 08:39:14 +0000
+++ CMakeLists.txt	2011-03-31 00:32:38 +0000
@@ -76,16 +76,8 @@
 SET(CMAKE_CXX_FLAGS_DEBUG "${CMAKE_CXX_FLAGS_DEBUG} -DFORCE_INIT_OF_VARS")
 
 SET(localstatedir "C:\\\\mysql\\\\data\\\\")
-CONFIGURE_FILE(${CMAKE_SOURCE_DIR}/support-files/my-huge.cnf.sh
-               ${CMAKE_BINARY_DIR}/support-files/my-huge.ini @ONLY)
-CONFIGURE_FILE(${CMAKE_SOURCE_DIR}/support-files/my-innodb-heavy-4G.cnf.sh
-               ${CMAKE_BINARY_DIR}/support-files/my-innodb-heavy-4G.ini @ONLY)
-CONFIGURE_FILE(${CMAKE_SOURCE_DIR}/support-files/my-large.cnf.sh
-               ${CMAKE_BINARY_DIR}/support-files/my-large.ini @ONLY)
-CONFIGURE_FILE(${CMAKE_SOURCE_DIR}/support-files/my-medium.cnf.sh
-               ${CMAKE_BINARY_DIR}/support-files/my-medium.ini @ONLY)
-CONFIGURE_FILE(${CMAKE_SOURCE_DIR}/support-files/my-small.cnf.sh
-               ${CMAKE_BINARY_DIR}/support-files/my-small.ini @ONLY)
+CONFIGURE_FILE(${CMAKE_SOURCE_DIR}/support-files/my-example.cnf.sh
+               ${CMAKE_BINARY_DIR}/support-files/my-example.ini @ONLY)
 
 
 ADD_DEFINITIONS(-D__NT__)
@@ -385,10 +377,7 @@
   SET(CPACK_GENERATOR "ZIP")
 ENDIF()
 INSTALL(FILES
-  ${CMAKE_BINARY_DIR}/support-files/my-huge.ini
-  ${CMAKE_BINARY_DIR}/support-files/my-large.ini
-  ${CMAKE_BINARY_DIR}/support-files/my-medium.ini
-  ${CMAKE_BINARY_DIR}/support-files/my-small.ini
+  ${CMAKE_BINARY_DIR}/support-files/my-example.ini
   DESTINATION .
   COMPONENT IniFiles
 )

=== modified file 'INSTALL-SOURCE'
--- INSTALL-SOURCE	2010-04-28 13:06:11 +0000
+++ INSTALL-SOURCE	2011-03-31 00:32:38 +0000
@@ -976,7 +976,7 @@
 shell> ./configure --prefix=/usr/local/mysql
 shell> make
 shell> make install
-shell> cp support-files/my-medium.cnf /etc/my.cnf
+shell> cp support-files/my-example.cnf /etc/my.cnf
 shell> cd /usr/local/mysql
 shell> chown -R mysql .
 shell> chgrp -R mysql .
@@ -1058,13 +1058,8 @@
        You might need to run this command as root.
        If you want to set up an option file, use one of those present
        in the support-files directory as a template. For example:
-shell> cp support-files/my-medium.cnf /etc/my.cnf
+shell> cp support-files/my-example.cnf /etc/my.cnf
        You might need to run this command as root.
-       If you want to configure support for InnoDB tables, you should
-       edit the /etc/my.cnf file, remove the # character before the
-       option lines that start with innodb_..., and modify the option
-       values to be what you want. See Section 4.2.3.3, "Using Option
-       Files," and Section 13.6.2, "InnoDB Configuration."
 
     9. Change location into the installation directory:
 shell> cd /usr/local/mysql

=== modified file 'support-files/Makefile.am'
--- support-files/Makefile.am	2011-02-20 16:51:43 +0000
+++ support-files/Makefile.am	2011-03-31 00:32:38 +0000
@@ -18,11 +18,7 @@
 ## Process this file with automake to create Makefile.in
 
 EXTRA_DIST =		mysql.spec.sh \
-			my-small.cnf.sh \
-			my-medium.cnf.sh \
-			my-large.cnf.sh \
-			my-huge.cnf.sh \
-			my-innodb-heavy-4G.cnf.sh \
+			my-example.cnf.sh \
 			mysql-log-rotate.sh \
 			mysql.server.sh \
 			mysqld_multi.server.sh \
@@ -40,14 +36,10 @@
 # Default same as 'pkgdatadir', but we can override it
 pkgsuppdir =		$(datadir)/@PACKAGE@
 
-pkgsupp_DATA =		my-small.cnf \
-			my-medium.cnf \
-			my-large.cnf \
-			my-huge.cnf \
+pkgsupp_DATA =		my-example.cnf \
                         config.huge.ini \
                         config.medium.ini \
                         config.small.ini \
-			my-innodb-heavy-4G.cnf \
 			mysql-log-rotate \
 			binary-configure \
 			ndb-config-2-node.ini
@@ -63,14 +55,10 @@
 noinst_DATA = mysql-@VERSION@.spec \
 			MySQL-shared-compat.spec
 
-CLEANFILES =		my-small.cnf \
-			my-medium.cnf \
-			my-large.cnf \
-			my-huge.cnf \
+CLEANFILES =		my-example.cnf \
                         config.huge.ini \
                         config.medium.ini \
                         config.small.ini \
-			my-innodb-heavy-4G.cnf \
 			mysql.spec \
 			mysql-@VERSION@.spec \
 			mysql-log-rotate \

=== added file 'support-files/my-example.cnf.sh'
--- support-files/my-example.cnf.sh	1970-01-01 00:00:00 +0000
+++ support-files/my-example.cnf.sh	2011-03-31 00:32:38 +0000
@@ -0,0 +1,192 @@
+# MariaDB database server configuration file.
+#
+# =================================================================
+# Base configuration courtesy of Open Query (http://openquery.com/)
+# For production use, case-specific preparation is still required.
+# 2009-10-07
+#
+# This is *not* an optimised config, merely a more sane baseline:
+# - binary and slow log enabled, with enhancements
+# - InnoDB default (e.g., ACID out-of-the-box, same as on Windows)
+# - strict mode (for proper input checks, same as on Windows)
+# - various other useful settings
+# - make use of MariaDB/Percona/OurDelta enhancements/extensions
+#
+# =================================================================
+#
+# You can copy this file 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		= @MYSQL_TCP_PORT@
+socket		= @MYSQL_UNIX_ADDR@
+# Default is Latin1, if you need UTF-8 set this (also in server section)
+#default-character-set  = utf8 
+
+# 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		= @MYSQL_UNIX_ADDR@
+nice		= 0
+
+[server]
+#
+# * Basic Settings
+#
+user		= mysql
+pid-file	= /var/run/mysqld/mysqld.pid
+socket		= @MYSQL_UNIX_ADDR@
+port		= @MYSQL_TCP_PORT@
+basedir		= /usr
+datadir		= @localstatedir@
+tmpdir		= /tmp
+language	= /usr/share/mysql/english
+skip-external-locking
+#
+# * Character sets
+# 
+# Default is Latin1, if you need UTF-8 set all this (also in client section)
+#
+#default-character-set  = utf8 
+#default-collation      = utf8_general_ci 
+#character_set_server   = utf8 
+#collation_server       = utf8_general_ci 
+#
+# 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
+#
+max_connections		= 100
+connect_timeout		= 5
+wait_timeout		= 600
+max_allowed_packet	= 16M
+thread_cache_size       = 128
+sort_buffer_size	= 4M
+bulk_insert_buffer_size	= 16M
+tmp_table_size		= 32M
+max_heap_table_size	= 32M
+#
+# * MyISAM
+#
+# This replaces the startup script and checks MyISAM tables if needed
+# the first time they are touched. On error, make copy and try a repair.
+myisam_recover          = BACKUP
+key_buffer_size		= 128M
+#open-files-limit	= 2000
+table_cache             = 400
+myisam_sort_buffer_size	= 512M
+concurrent_insert	= 2
+read_buffer_size	= 2M
+read_rnd_buffer_size	= 1M
+#
+# * Query Cache Configuration
+#
+# Cache only tiny result sets, so we can fit more in the query cache.
+query_cache_limit		= 128K
+query_cache_size		= 64M
+# for more write intensive setups, set to DEMAND or OFF
+#query_cache_type		= DEMAND
+#
+# * 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        = @localstatedir@/mysql.log
+#general_log             = 1
+#
+# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
+#
+# we do want to know about network errors and such
+log_warnings		= 2
+#
+# Here you can see queries with especially long duration
+log_slow_file		= @localstatedir@/mariadb-slow.log
+long_query_time = 10
+#log_slow_rate_limit	= 1000
+log_slow_verbosity	= query_plan
+
+#log-queries-not-using-indexes
+log_slow_admin_statements
+#
+# 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
+#report_host		= master1
+#auto_increment_increment = 2
+#auto_increment_offset	= 1
+log_bin			= @localstatedir@/mariadb-bin
+log_bin_index		= @localstatedir@/mariadb-bin.index
+# not fab for performance, but safer
+#sync_binlog		= 1
+expire_logs_days	= 10
+max_binlog_size         = 100M
+# slaves
+#relay_log		= @localstatedir@/relay-bin
+#relay_log_index	= @localstatedir@/relay-bin.index
+#relay_log_info_file	= @localstatedir@/relay-bin.info
+#log_slave_updates
+#read_only
+#
+#
+# * 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!
+default_storage_engine	= InnoDB
+sql_mode		= NO_ENGINE_SUBSTITUTION,TRADITIONAL
+# you can't just change log file size, requires special procedure
+#innodb_log_file_size	= 50M
+innodb_buffer_pool_size	= 256M
+innodb_log_buffer_size	= 8M
+innodb_file_per_table	= 1
+innodb_open_files	= 400
+innodb_io_capacity	= 400
+innodb_flush_method	= O_DIRECT
+#
+# * Security Features
+#
+# Read the manual, too, if you want chroot!
+# chroot = @localstatedir@
+#
+# 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/

=== removed file 'support-files/my-huge.cnf.sh'
--- support-files/my-huge.cnf.sh	2011-02-20 16:51:43 +0000
+++ support-files/my-huge.cnf.sh	1970-01-01 00:00:00 +0000
@@ -1,151 +0,0 @@
-# Example MariaDB config file for very large systems.
-#
-# This is for a large system with memory of 1G-2G where the system runs mainly
-# MariaDB.
-#
-# MariaDB programs look for option files in a set of
-# locations which depend on the deployment platform.
-# You can copy this option file to one of those
-# locations. For information about these locations, do:
-# 'my_print_defaults --help' and see what is printed under
-# Default options are read from the following files in the given order:
-# More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
-#
-# In this file, you can use all long options that a program supports.
-# If you want to know which options a program supports, run the program
-# with the "--help" option.
-
-# The following options will be passed to all MySQL clients
-[client]
-#password	= your_password
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-
-# Here follows entries for some specific programs
-
-# The MySQL server
-[mysqld]
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-skip-external-locking
-key_buffer_size = 384M
-max_allowed_packet = 1M
-table_open_cache = 512
-sort_buffer_size = 2M
-read_buffer_size = 2M
-read_rnd_buffer_size = 8M
-myisam_sort_buffer_size = 64M
-thread_cache_size = 8
-query_cache_size = 32M
-# Try number of CPU's*2 for thread_concurrency
-thread_concurrency = 8
-
-# Point the following paths to a dedicated disk
-#tmpdir		= /tmp/
-
-# Don't listen on a TCP/IP port at all. This can be a security enhancement,
-# if all processes that need to connect to mysqld run on the same host.
-# All interaction with mysqld must be made via Unix sockets or named pipes.
-# Note that using this option without enabling named pipes on Windows
-# (via the "enable-named-pipe" option) will render mysqld useless!
-# 
-#skip-networking
-
-# Replication Master Server (default)
-# binary logging is required for replication
-log-bin=mysql-bin
-
-# required unique id between 1 and 2^32 - 1
-# defaults to 1 if master-host is not set
-# but will not function as a master if omitted
-server-id	= 1
-
-# Replication Slave (comment out master section to use this)
-#
-# To configure this host as a replication slave, you can choose between
-# two methods :
-#
-# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
-#    the syntax is:
-#
-#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
-#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
-#
-#    where you replace <host>, <user>, <password> by quoted strings and
-#    <port> by the master's port number (3306 by default).
-#
-#    Example:
-#
-#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
-#    MASTER_USER='joe', MASTER_PASSWORD='secret';
-#
-# OR
-#
-# 2) Set the variables below. However, in case you choose this method, then
-#    start replication for the first time (even unsuccessfully, for example
-#    if you mistyped the password in master-password and the slave fails to
-#    connect), the slave will create a master.info file, and any later
-#    change in this file to the variables' values below will be ignored and
-#    overridden by the content of the master.info file, unless you shutdown
-#    the slave server, delete master.info and restart the slaver server.
-#    For that reason, you may want to leave the lines below untouched
-#    (commented) and instead use CHANGE MASTER TO (see above)
-#
-# required unique id between 2 and 2^32 - 1
-# (and different from the master)
-# defaults to 2 if master-host is set
-# but will not function as a slave if omitted
-#server-id       = 2
-#
-# The replication master for this slave - required
-#master-host     =   <hostname>
-#
-# The username the slave will use for authentication when connecting
-# to the master - required
-#master-user     =   <username>
-#
-# The password the slave will authenticate with when connecting to
-# the master - required
-#master-password =   <password>
-#
-# The port the master is listening on.
-# optional - defaults to 3306
-#master-port     =  <port>
-#
-# binary logging - not required for slaves, but recommended
-#log-bin=mysql-bin
-#
-# binary logging format - mixed recommended 
-#binlog_format=mixed
-
-# Uncomment the following if you are using InnoDB tables
-#innodb_data_home_dir = @localstatedir@
-#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
-o#innodb_log_group_home_dir = @localstatedir@
-# You can set .._buffer_pool_size up to 50 - 80 %
-# of RAM but beware of setting memory usage too high
-#innodb_buffer_pool_size = 384M
-#innodb_additional_mem_pool_size = 20M
-# Set .._log_file_size to 25 % of buffer pool size
-#innodb_log_file_size = 100M
-#innodb_log_buffer_size = 8M
-#innodb_flush_log_at_trx_commit = 1
-#innodb_lock_wait_timeout = 50
-
-[mysqldump]
-quick
-max_allowed_packet = 16M
-
-[mysql]
-no-auto-rehash
-# Remove the next comment character if you are not familiar with SQL
-#safe-updates
-
-[myisamchk]
-key_buffer_size = 256M
-sort_buffer_size = 256M
-read_buffer = 2M
-write_buffer = 2M
-
-[mysqlhotcopy]
-interactive-timeout

=== removed file 'support-files/my-innodb-heavy-4G.cnf.sh'
--- support-files/my-innodb-heavy-4G.cnf.sh	2011-02-20 16:51:43 +0000
+++ support-files/my-innodb-heavy-4G.cnf.sh	1970-01-01 00:00:00 +0000
@@ -1,487 +0,0 @@
-#BEGIN CONFIG INFO
-#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries
-#TYPE: SYSTEM
-#END CONFIG INFO
-
-#
-# This is a MariaDB example config file for systems with 4GB of memory
-# running mostly MariaDB using InnoDB only tables and performing complex
-# queries with few connections.
-# 
-# MariaDB programs look for option files in a set of
-# locations which depend on the deployment platform.
-# You can copy this option file to one of those
-# locations. For information about these locations, do:
-# 'my_print_defaults --help' and see what is printed under
-# Default options are read from the following files in the given order:
-# More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
-#
-# In this file, you can use all long options that a program supports.
-# If you want to know which options a program supports, run the program
-# with the "--help" option.
-#
-# More detailed information about the individual options can also be
-# found in the manual.
-#
-
-#
-# The following options will be read by MariaDB client applications.
-# Note that only client applications shipped by MariaDB are guaranteed
-# to read this section. If you want your own MariaDB client program to
-# honor these values, you need to specify it as an option during the
-# MariaDB client library initialization.
-#
-[client]
-#password	= [your_password]
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-
-# *** Application-specific options follow here ***
-
-#
-# The MariaDB server
-#
-[mysqld]
-
-# generic configuration options
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-
-# back_log is the number of connections the operating system can keep in
-# the listen queue, before the MariaDB connection manager thread has
-# processed them. If you have a very high connection rate and experience
-# "connection refused" errors, you might need to increase this value.
-# Check your OS documentation for the maximum value of this parameter.
-# Attempting to set back_log higher than your operating system limit
-# will have no effect.
-back_log = 50
-
-# Don't listen on a TCP/IP port at all. This can be a security
-# enhancement, if all processes that need to connect to mysqld run
-# on the same host.  All interaction with mysqld must be made via Unix
-# sockets or named pipes.
-# Note that using this option without enabling named pipes on Windows
-# (via the "enable-named-pipe" option) will render mysqld useless!
-#skip-networking
-
-# The maximum amount of concurrent sessions the MariaDB server will
-# allow. One of these connections will be reserved for a user with
-# SUPER privileges to allow the administrator to login even if the
-# connection limit has been reached.
-max_connections = 100
-
-# Maximum amount of errors allowed per host. If this limit is reached,
-# the host will be blocked from connecting to the MariaDB server until
-# "FLUSH HOSTS" has been run or the server was restarted. Invalid
-# passwords and other errors during the connect phase result in
-# increasing this value. See the "Aborted_connects" status variable for
-# global counter.
-max_connect_errors = 10
-
-# The number of open tables for all threads. Increasing this value
-# increases the number of file descriptors that mysqld requires.
-# Therefore you have to make sure to set the amount of open files
-# allowed to at least 4096 in the variable "open-files-limit" in
-# section [mysqld_safe]
-table_open_cache = 2048
-
-# Enable external file level locking. Enabled file locking will have a
-# negative impact on performance, so only use it in case you have
-# multiple database instances running on the same files (note some
-# restrictions still apply!) or if you use other software relying on
-# locking MyISAM tables on file level.
-#external-locking
-
-# The maximum size of a query packet the server can handle as well as
-# maximum query size server can process (Important when working with
-# large BLOBs).  enlarged dynamically, for each connection.
-max_allowed_packet = 16M
-
-# The size of the cache to hold the SQL statements for the binary log
-# during a transaction. If you often use big, multi-statement
-# transactions you can increase this value to get more performance. All
-# statements from transactions are buffered in the binary log cache and
-# are being written to the binary log at once after the COMMIT.  If the
-# transaction is larger than this value, temporary file on disk is used
-# instead.  This buffer is allocated per connection on first update
-# statement in transaction
-binlog_cache_size = 1M
-
-# Maximum allowed size for a single HEAP (in memory) table. This option
-# is a protection against the accidential creation of a very large HEAP
-# table which could otherwise use up all memory resources.
-max_heap_table_size = 64M
-
-# Size of the buffer used for doing full table scans.
-# Allocated per thread, if a full scan is needed.
-read_buffer_size = 2M
-
-# When reading rows in sorted order after a sort, the rows are read
-# through this buffer to avoid disk seeks. You can improve ORDER BY
-# performance a lot, if set this to a high value.
-# Allocated per thread, when needed.
-read_rnd_buffer_size = 16M
-
-# Sort buffer is used to perform sorts for some ORDER BY and GROUP BY
-# queries. If sorted data does not fit into the sort buffer, a disk
-# based merge sort is used instead - See the "Sort_merge_passes"
-# status variable. Allocated per thread if sort is needed.
-sort_buffer_size = 8M
-
-# This buffer is used for the optimization of full JOINs (JOINs without
-# indexes). Such JOINs are very bad for performance in most cases
-# anyway, but setting this variable to a large value reduces the
-# performance impact. See the "Select_full_join" status variable for a
-# count of full JOINs. Allocated per thread if full join is found
-join_buffer_size = 8M
-
-# How many threads we should keep in a cache for reuse. When a client
-# disconnects, the client's threads are put in the cache if there aren't
-# more than thread_cache_size threads from before.  This greatly reduces
-# the amount of thread creations needed if you have a lot of new
-# connections. (Normally this doesn't give a notable performance
-# improvement if you have a good thread implementation.)
-thread_cache_size = 8
-
-# This permits the application to give the threads system a hint for the
-# desired number of threads that should be run at the same time.  This
-# value only makes sense on systems that support the thread_concurrency()
-# function call (Sun Solaris, for example).
-# You should try [number of CPUs]*(2..4) for thread_concurrency
-thread_concurrency = 8
-
-# Query cache is used to cache SELECT results and later return them
-# without actual executing the same query once again. Having the query
-# cache enabled may result in significant speed improvements, if your
-# have a lot of identical queries and rarely changing tables. See the
-# "Qcache_lowmem_prunes" status variable to check if the current value
-# is high enough for your load.
-# Note: In case your tables change very often or if your queries are
-# textually different every time, the query cache may result in a
-# slowdown instead of a performance improvement.
-query_cache_size = 64M
-
-# Only cache result sets that are smaller than this limit. This is to
-# protect the query cache of a very large result set overwriting all
-# other query results.
-query_cache_limit = 2M
-
-# Minimum word length to be indexed by the full text search index.
-# You might wish to decrease it if you need to search for shorter words.
-# Note that you need to rebuild your FULLTEXT index, after you have
-# modified this value.
-ft_min_word_len = 4
-
-# If your system supports the memlock() function call, you might want to
-# enable this option while running MariaDB to keep it locked in memory and
-# to avoid potential swapping out in case of high memory pressure. Good
-# for performance.
-#memlock
-
-# Table type which is used by default when creating new tables, if not
-# specified differently during the CREATE TABLE statement.
-default-storage-engine = MYISAM
-
-# Thread stack size to use. This amount of memory is always reserved at
-# connection time. MariaDB itself usually needs no more than 64K of
-# memory, while if you use your own stack hungry UDF functions or your
-# OS requires more stack for some operations, you might need to set this
-# to a higher value.
-thread_stack = 240K
-
-# Set the default transaction isolation level. Levels available are:
-# READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE
-transaction_isolation = REPEATABLE-READ
-
-# Maximum size for internal (in-memory) temporary tables. If a table
-# grows larger than this value, it is automatically converted to disk
-# based table This limitation is for a single table. There can be many
-# of them.
-tmp_table_size = 64M
-
-# Enable binary logging. This is required for acting as a MASTER in a
-# replication configuration. You also need the binary log if you need
-# the ability to do point in time recovery from your latest backup.
-log-bin=mysql-bin
-
-# binary logging format - mixed recommended
-binlog_format=mixed
-
-# If you're using replication with chained slaves (A->B->C), you need to
-# enable this option on server B. It enables logging of updates done by
-# the slave thread into the slave's binary log.
-#log_slave_updates
-
-# Enable the full query log. Every query (even ones with incorrect
-# syntax) that the server receives will be logged. This is useful for
-# debugging, it is usually disabled in production use.
-#log
-
-# Print warnings to the error log file.  If you have any problem with
-# MariaDB you should enable logging of warnings and examine the error log
-# for possible explanations. 
-#log_warnings
-
-# Log slow queries. Slow queries are queries which take more than the
-# amount of time defined in "long_query_time" or which do not use
-# indexes well, if log_short_format is not enabled. It is normally good idea
-# to have this turned on if you frequently add new queries to the
-# system.
-slow_query_log
-
-# All queries taking more than this amount of time (in seconds) will be
-# trated as slow. Do not use "1" as a value here, as this will result in
-# even very fast queries being logged from time to time (as MariaDB
-# currently measures time with second accuracy only).
-long_query_time = 2
-
-# The directory used by MySQL for storing temporary files. For example,
-# it is used to perform disk based large sorts, as well as for internal
-# and explicit temporary tables. It might be good to put it on a
-# swapfs/tmpfs filesystem, if you do not create very large temporary
-# files. Alternatively you can put it on dedicated disk. You can
-# specify multiple paths here by separating them by ";" - they will then
-# be used in a round-robin fashion.
-#tmpdir = /tmp
-
-# ***  Replication related settings 
-
-# Unique server identification number between 1 and 2^32-1. This value
-# is required for both master and slave hosts. It defaults to 1 if
-# "master-host" is not set, but will MariaDB will not function as a master
-# if it is omitted.
-server-id = 1
-
-# Replication Slave (comment out master section to use this)
-#
-# To configure this host as a replication slave, you can choose between
-# two methods :
-#
-# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
-#    the syntax is:
-#
-#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
-#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
-#
-#    where you replace <host>, <user>, <password> by quoted strings and
-#    <port> by the master's port number (3306 by default).
-#
-#    Example:
-#
-#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
-#    MASTER_USER='joe', MASTER_PASSWORD='secret';
-#
-# OR
-#
-# 2) Set the variables below. However, in case you choose this method, then
-#    start replication for the first time (even unsuccessfully, for example
-#    if you mistyped the password in master-password and the slave fails to
-#    connect), the slave will create a master.info file, and any later
-#    changes in this file to the variable values below will be ignored and
-#    overridden by the content of the master.info file, unless you shutdown
-#    the slave server, delete master.info and restart the slaver server.
-#    For that reason, you may want to leave the lines below untouched
-#    (commented) and instead use CHANGE MASTER TO (see above)
-#
-# required unique id between 2 and 2^32 - 1
-# (and different from the master)
-# defaults to 2 if master-host is set
-# but will not function as a slave if omitted
-#server-id = 2
-#
-# The replication master for this slave - required
-#master-host = <hostname>
-#
-# The username the slave will use for authentication when connecting
-# to the master - required
-#master-user = <username>
-#
-# The password the slave will authenticate with when connecting to
-# the master - required
-#master-password = <password>
-#
-# The port the master is listening on.
-# optional - defaults to 3306
-#master-port = <port>
-
-# Make the slave read-only. Only users with the SUPER privilege and the
-# replication slave thread will be able to modify data on it. You can
-# use this to ensure that no applications will accidently modify data on
-# the slave instead of the master
-#read_only
-
-
-#*** MyISAM Specific options
-
-
-# Size of the Key Buffer, used to cache index blocks for MyISAM tables.
-# Do not set it larger than 30% of your available memory, as some memory
-# is also required by the OS to cache rows. Even if you're not using
-# MyISAM tables, you should still set it to 8-64M as it will also be
-# used for internal temporary disk tables.
-key_buffer_size = 32M
-
-# MyISAM uses special tree-like cache to make bulk inserts (that is,
-# INSERT ... SELECT, INSERT ... VALUES (...), (...), ..., and LOAD DATA
-# INFILE) faster. This variable limits the size of the cache tree in
-# bytes per thread. Setting it to 0 will disable this optimisation.  Do
-# not set it larger than "key_buffer_size" for optimal performance.
-# This buffer is allocated when a bulk insert is detected.
-bulk_insert_buffer_size = 64M
-
-# This buffer is allocated when MariaDB needs to rebuild the index in
-# REPAIR, OPTIMIZE, ALTER table statements as well as in LOAD DATA INFILE
-# into an empty table. It is allocated per thread so be careful with
-# large settings.
-myisam_sort_buffer_size = 128M
-
-# The maximum size of the temporary file MariaDB is allowed to use while
-# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.
-# If the file-size would be bigger than this, the index will be created
-# through the key cache (which is slower).
-myisam_max_sort_file_size = 10G
-
-# If a table has more than one index, MyISAM can use more than one
-# thread to repair them by sorting in parallel. This makes sense if you
-# have multiple CPUs and plenty of memory.
-myisam_repair_threads = 1
-
-# Automatically check and repair not properly closed MyISAM tables.
-myisam_recover
-
-# *** INNODB Specific options ***
-
-# Use this option if you have a MariaDB server with InnoDB support enabled
-# but you do not plan to use it. This will save memory and disk space
-# and speed up some things.
-#skip-innodb
-
-# Additional memory pool that is used by InnoDB to store metadata
-# information.  If InnoDB requires more memory for this purpose it will
-# start to allocate it from the OS.  As this is fast enough on most
-# recent operating systems, you normally do not need to change this
-# value. SHOW INNODB STATUS will display the current amount used.
-innodb_additional_mem_pool_size = 16M
-
-# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
-# row data. The bigger you set this the less disk I/O is needed to
-# access data in tables. On a dedicated database server you may set this
-# parameter up to 80% of the machine physical memory size. Do not set it
-# too large, though, because competition of the physical memory may
-# cause paging in the operating system.  Note that on 32bit systems you
-# might be limited to 2-3.5G of user level memory per process, so do not
-# set it too high.
-innodb_buffer_pool_size = 2G
-
-# InnoDB stores data in one or more data files forming the tablespace.
-# If you have a single logical drive for your data, a single
-# autoextending file would be good enough. In other cases, a single file
-# per device is often a good choice. You can configure InnoDB to use raw
-# disk partitions as well - please refer to the manual for more info
-# about this.
-innodb_data_file_path = ibdata1:10M:autoextend
-
-# Set this option if you would like the InnoDB tablespace files to be
-# stored in another location. By default this is the MariaDB datadir.
-#innodb_data_home_dir = <directory>
-
-# Number of IO threads to use for async IO operations. This value is
-# hardcoded to 4 on Unix, but on Windows disk I/O may benefit from a
-# larger number.
-innodb_file_io_threads = 4
-
-# If you run into InnoDB tablespace corruption, setting this to a nonzero
-# value will likely help you to dump your tables. Start from value 1 and
-# increase it until you're able to dump the table successfully.
-#innodb_force_recovery=1
-
-# Number of threads allowed inside the InnoDB kernel. The optimal value
-# depends highly on the application, hardware as well as the OS
-# scheduler properties. A too high value may lead to thread thrashing.
-innodb_thread_concurrency = 16
-
-# If set to 1, InnoDB will flush (fsync) the transaction logs to the
-# disk at each commit, which offers full ACID behavior. If you are
-# willing to compromise this safety, and you are running small
-# transactions, you may set this to 0 or 2 to reduce disk I/O to the
-# logs. Value 0 means that the log is only written to the log file and
-# the log file flushed to disk approximately once per second. Value 2
-# means the log is written to the log file at each commit, but the log
-# file is only flushed to disk approximately once per second.
-innodb_flush_log_at_trx_commit = 1
-
-# Speed up InnoDB shutdown. This will disable InnoDB to do a full purge
-# and insert buffer merge on shutdown. It may increase shutdown time a
-# lot, but InnoDB will have to do it on the next startup instead.
-#innodb_fast_shutdown
-
-# The size of the buffer InnoDB uses for buffering log data. As soon as
-# it is full, InnoDB will have to flush it to disk. As it is flushed
-# once per second anyway, it does not make sense to have it very large
-# (even with long transactions). 
-innodb_log_buffer_size = 8M
-
-# Size of each log file in a log group. You should set the combined size
-# of log files to about 25%-100% of your buffer pool size to avoid
-# unneeded buffer pool flush activity on log file overwrite. However,
-# note that a larger logfile size will increase the time needed for the
-# recovery process.
-innodb_log_file_size = 256M
-
-# Total number of files in the log group. A value of 2-3 is usually good
-# enough.
-innodb_log_files_in_group = 3
-
-# Location of the InnoDB log files. Default is the MariaDB datadir. You
-# may wish to point it to a dedicated hard drive or a RAID1 volume for
-# improved performance
-#innodb_log_group_home_dir
-
-# Maximum allowed percentage of dirty pages in the InnoDB buffer pool.
-# If it is reached, InnoDB will start flushing them out agressively to
-# not run out of clean pages at all. This is a soft limit, not
-# guaranteed to be held.
-innodb_max_dirty_pages_pct = 90
-
-# The flush method InnoDB will use for Log. The tablespace always uses
-# doublewrite flush logic. The default value is "fdatasync", another
-# option is "O_DSYNC".
-#innodb_flush_method=O_DSYNC
-
-# How long an InnoDB transaction should wait for a lock to be granted
-# before being rolled back. InnoDB automatically detects transaction
-# deadlocks in its own lock table and rolls back the transaction. If you
-# use the LOCK TABLES command, or other transaction-safe storage engines
-# than InnoDB in the same transaction, then a deadlock may arise which
-# InnoDB cannot notice. In cases like this the timeout is useful to
-# resolve the situation.
-innodb_lock_wait_timeout = 120
-
-
-[mysqldump]
-# Do not buffer the whole result set in memory before writing it to
-# file. Required for dumping very large tables
-quick
-
-max_allowed_packet = 16M
-
-[mysql]
-no-auto-rehash
-
-# Only allow UPDATEs and DELETEs that use keys.
-#safe-updates
-
-[myisamchk]
-key_buffer_size = 512M
-sort_buffer_size = 512M
-read_buffer = 8M
-write_buffer = 8M
-
-[mysqlhotcopy]
-interactive-timeout
-
-[mysqld_safe]
-# Increase the amount of open files allowed per process. Warning: Make
-# sure you have set the global system limit high enough! The high value
-# is required for a large number of opened tables
-open-files-limit = 8192

=== removed file 'support-files/my-large.cnf.sh'
--- support-files/my-large.cnf.sh	2011-02-20 16:51:43 +0000
+++ support-files/my-large.cnf.sh	1970-01-01 00:00:00 +0000
@@ -1,151 +0,0 @@
-# Example MariaDB config file for large systems.
-#
-# This is for a large system with memory = 512M where the system runs mainly
-# MariaDB.
-#
-# MariaDB programs look for option files in a set of
-# locations which depend on the deployment platform.
-# You can copy this option file to one of those
-# locations. For information about these locations, do:
-# 'my_print_defaults --help' and see what is printed under
-# Default options are read from the following files in the given order:
-# More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
-#
-# In this file, you can use all long options that a program supports.
-# If you want to know which options a program supports, run the program
-# with the "--help" option.
-
-# The following options will be passed to all MariaDB clients
-[client]
-#password	= your_password
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-
-# Here follows entries for some specific programs
-
-# The MariaDB server
-[mysqld]
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-skip-external-locking
-key_buffer_size = 256M
-max_allowed_packet = 1M
-table_open_cache = 256
-sort_buffer_size = 1M
-read_buffer_size = 1M
-read_rnd_buffer_size = 4M
-myisam_sort_buffer_size = 64M
-thread_cache_size = 8
-query_cache_size= 16M
-# Try number of CPU's*2 for thread_concurrency
-thread_concurrency = 8
-
-# Point the following paths to different dedicated disks
-#tmpdir		= /tmp/
-
-# Don't listen on a TCP/IP port at all. This can be a security enhancement,
-# if all processes that need to connect to mysqld run on the same host.
-# All interaction with mysqld must be made via Unix sockets or named pipes.
-# Note that using this option without enabling named pipes on Windows
-# (via the "enable-named-pipe" option) will render mysqld useless!
-# 
-#skip-networking
-
-# Replication Master Server (default)
-# binary logging is required for replication
-log-bin=mysql-bin
-
-# binary logging format - mixed recommended
-binlog_format=mixed
-
-# required unique id between 1 and 2^32 - 1
-# defaults to 1 if master-host is not set
-# but will not function as a master if omitted
-server-id	= 1
-
-# Replication Slave (comment out master section to use this)
-#
-# To configure this host as a replication slave, you can choose between
-# two methods :
-#
-# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
-#    the syntax is:
-#
-#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
-#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
-#
-#    where you replace <host>, <user>, <password> by quoted strings and
-#    <port> by the master's port number (3306 by default).
-#
-#    Example:
-#
-#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
-#    MASTER_USER='joe', MASTER_PASSWORD='secret';
-#
-# OR
-#
-# 2) Set the variables below. However, in case you choose this method, then
-#    start replication for the first time (even unsuccessfully, for example
-#    if you mistyped the password in master-password and the slave fails to
-#    connect), the slave will create a master.info file, and any later
-#    change in this file to the variables' values below will be ignored and
-#    overridden by the content of the master.info file, unless you shutdown
-#    the slave server, delete master.info and restart the slaver server.
-#    For that reason, you may want to leave the lines below untouched
-#    (commented) and instead use CHANGE MASTER TO (see above)
-#
-# required unique id between 2 and 2^32 - 1
-# (and different from the master)
-# defaults to 2 if master-host is set
-# but will not function as a slave if omitted
-#server-id       = 2
-#
-# The replication master for this slave - required
-#master-host     =   <hostname>
-#
-# The username the slave will use for authentication when connecting
-# to the master - required
-#master-user     =   <username>
-#
-# The password the slave will authenticate with when connecting to
-# the master - required
-#master-password =   <password>
-#
-# The port the master is listening on.
-# optional - defaults to 3306
-#master-port     =  <port>
-#
-# binary logging - not required for slaves, but recommended
-#log-bin=mysql-bin
-
-# Uncomment the following if you are using InnoDB tables
-#innodb_data_home_dir = @localstatedir@
-#innodb_data_file_path = ibdata1:10M:autoextend
-#innodb_log_group_home_dir = @localstatedir@
-# You can set .._buffer_pool_size up to 50 - 80 %
-# of RAM but beware of setting memory usage too high
-#innodb_buffer_pool_size = 256M
-#innodb_additional_mem_pool_size = 20M
-# Set .._log_file_size to 25 % of buffer pool size
-#innodb_log_file_size = 64M
-#innodb_log_buffer_size = 8M
-#innodb_flush_log_at_trx_commit = 1
-#innodb_lock_wait_timeout = 50
-
-[mysqldump]
-quick
-max_allowed_packet = 16M
-
-[mysql]
-no-auto-rehash
-# Remove the next comment character if you are not familiar with SQL
-#safe-updates
-
-[myisamchk]
-key_buffer_size = 128M
-sort_buffer_size = 128M
-read_buffer = 2M
-write_buffer = 2M
-
-[mysqlhotcopy]
-interactive-timeout

=== removed file 'support-files/my-medium.cnf.sh'
--- support-files/my-medium.cnf.sh	2011-02-20 16:51:43 +0000
+++ support-files/my-medium.cnf.sh	1970-01-01 00:00:00 +0000
@@ -1,149 +0,0 @@
-# Example MariaDB config file for medium systems.
-#
-# This is for a system with little memory (32M - 64M) where MariaDB plays
-# an important part, or systems up to 128M where MariaDB is used together with
-# other programs (such as a web server)
-#
-# MariaDB programs look for option files in a set of
-# locations which depend on the deployment platform.
-# You can copy this option file to one of those
-# locations. For information about these locations, do:
-# 'my_print_defaults --help' and see what is printed under
-# Default options are read from the following files in the given order:
-# More information at: http://dev.mysql.com/doc/mysql/en/option-files.html
-#
-# In this file, you can use all long options that a program supports.
-# If you want to know which options a program supports, run the program
-# with the "--help" option.
-
-# The following options will be passed to all MariaDB clients
-[client]
-#password	= your_password
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-
-# Here follows entries for some specific programs
-
-# The MariaDB server
-[mysqld]
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-skip-external-locking
-key_buffer_size = 16M
-max_allowed_packet = 1M
-table_open_cache = 64
-sort_buffer_size = 512K
-net_buffer_length = 8K
-read_buffer_size = 256K
-read_rnd_buffer_size = 512K
-myisam_sort_buffer_size = 8M
-
-# Point the following paths to different dedicated disks
-#tmpdir		= /tmp/
-
-# Don't listen on a TCP/IP port at all. This can be a security enhancement,
-# if all processes that need to connect to mysqld run on the same host.
-# All interaction with mysqld must be made via Unix sockets or named pipes.
-# Note that using this option without enabling named pipes on Windows
-# (via the "enable-named-pipe" option) will render mysqld useless!
-# 
-#skip-networking
-
-# Replication Master Server (default)
-# binary logging is required for replication
-log-bin=mysql-bin
-
-# binary logging format - mixed recommended
-binlog_format=mixed
-
-# required unique id between 1 and 2^32 - 1
-# defaults to 1 if master-host is not set
-# but will not function as a master if omitted
-server-id	= 1
-
-# Replication Slave (comment out master section to use this)
-#
-# To configure this host as a replication slave, you can choose between
-# two methods :
-#
-# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
-#    the syntax is:
-#
-#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
-#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
-#
-#    where you replace <host>, <user>, <password> by quoted strings and
-#    <port> by the master's port number (3306 by default).
-#
-#    Example:
-#
-#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
-#    MASTER_USER='joe', MASTER_PASSWORD='secret';
-#
-# OR
-#
-# 2) Set the variables below. However, in case you choose this method, then
-#    start replication for the first time (even unsuccessfully, for example
-#    if you mistyped the password in master-password and the slave fails to
-#    connect), the slave will create a master.info file, and any later
-#    change in this file to the variables' values below will be ignored and
-#    overridden by the content of the master.info file, unless you shutdown
-#    the slave server, delete master.info and restart the slaver server.
-#    For that reason, you may want to leave the lines below untouched
-#    (commented) and instead use CHANGE MASTER TO (see above)
-#
-# required unique id between 2 and 2^32 - 1
-# (and different from the master)
-# defaults to 2 if master-host is set
-# but will not function as a slave if omitted
-#server-id       = 2
-#
-# The replication master for this slave - required
-#master-host     =   <hostname>
-#
-# The username the slave will use for authentication when connecting
-# to the master - required
-#master-user     =   <username>
-#
-# The password the slave will authenticate with when connecting to
-# the master - required
-#master-password =   <password>
-#
-# The port the master is listening on.
-# optional - defaults to 3306
-#master-port     =  <port>
-#
-# binary logging - not required for slaves, but recommended
-#log-bin=mysql-bin
-
-# Uncomment the following if you are using InnoDB tables
-#innodb_data_home_dir = @localstatedir@
-#innodb_data_file_path = ibdata1:10M:autoextend
-#innodb_log_group_home_dir = @localstatedir@
-# You can set .._buffer_pool_size up to 50 - 80 %
-# of RAM but beware of setting memory usage too high
-#innodb_buffer_pool_size = 16M
-#innodb_additional_mem_pool_size = 2M
-# Set .._log_file_size to 25 % of buffer pool size
-#innodb_log_file_size = 5M
-#innodb_log_buffer_size = 8M
-#innodb_flush_log_at_trx_commit = 1
-#innodb_lock_wait_timeout = 50
-
-[mysqldump]
-quick
-max_allowed_packet = 16M
-
-[mysql]
-no-auto-rehash
-# Remove the next comment character if you are not familiar with SQL
-#safe-updates
-
-[myisamchk]
-key_buffer_size = 20M
-sort_buffer_size = 20M
-read_buffer = 2M
-write_buffer = 2M
-
-[mysqlhotcopy]
-interactive-timeout

=== removed file 'support-files/my-small.cnf.sh'
--- support-files/my-small.cnf.sh	2011-02-20 16:51:43 +0000
+++ support-files/my-small.cnf.sh	1970-01-01 00:00:00 +0000
@@ -1,82 +0,0 @@
-# Example MySQL config file for small systems.
-#
-# This is for a system with little memory (<= 64M) where MySQL is only used
-# from time to time and it's important that the mysqld daemon
-# doesn't use much resources.
-#
-# MySQL programs look for option files in a set of
-# locations which depend on the deployment platform.
-# You can copy this option file to one of those
-# locations. For information about these locations, see:
-# http://dev.mysql.com/doc/mysql/en/option-files.html
-#
-# In this file, you can use all long options that a program supports.
-# If you want to know which options a program supports, run the program
-# with the "--help" option.
-
-# The following options will be passed to all MySQL clients
-[client]
-#password	= your_password
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-
-# Here follows entries for some specific programs
-
-# The MySQL server
-[mysqld]
-port		= @MYSQL_TCP_PORT@
-socket		= @MYSQL_UNIX_ADDR@
-skip-external-locking
-key_buffer_size = 16K
-max_allowed_packet = 1M
-table_open_cache = 4
-sort_buffer_size = 64K
-read_buffer_size = 256K
-read_rnd_buffer_size = 256K
-net_buffer_length = 2K
-thread_stack = 240K
-
-# Don't listen on a TCP/IP port at all. This can be a security enhancement,
-# if all processes that need to connect to mysqld run on the same host.
-# All interaction with mysqld must be made via Unix sockets or named pipes.
-# Note that using this option without enabling named pipes on Windows
-# (using the "enable-named-pipe" option) will render mysqld useless!
-# 
-#skip-networking
-server-id	= 1
-
-# Uncomment the following if you want to log updates
-#log-bin=mysql-bin
-
-# binary logging format - mixed recommended
-#binlog_format=mixed
-
-# Uncomment the following if you are using InnoDB tables
-#innodb_data_home_dir = @localstatedir@
-#innodb_data_file_path = ibdata1:10M:autoextend
-#innodb_log_group_home_dir = @localstatedir@
-# You can set .._buffer_pool_size up to 50 - 80 %
-# of RAM but beware of setting memory usage too high
-#innodb_buffer_pool_size = 16M
-#innodb_additional_mem_pool_size = 2M
-# Set .._log_file_size to 25 % of buffer pool size
-#innodb_log_file_size = 5M
-#innodb_log_buffer_size = 8M
-#innodb_flush_log_at_trx_commit = 1
-#innodb_lock_wait_timeout = 50
-
-[mysqldump]
-quick
-max_allowed_packet = 16M
-
-[mysql]
-no-auto-rehash
-# Remove the next comment character if you are not familiar with SQL
-#safe-updates
-
-[myisamchk]
-key_buffer_size = 8M
-sort_buffer_size = 8M
-
-[mysqlhotcopy]
-interactive-timeout

=== modified file 'support-files/mysql.spec.sh'
--- support-files/mysql.spec.sh	2011-02-20 16:51:43 +0000
+++ support-files/mysql.spec.sh	2011-03-31 00:32:38 +0000
@@ -921,7 +921,7 @@
 %defattr(-,root,root,0755)
 
 %doc mysql-release-%{mysql_version}/COPYING mysql-release-%{mysql_version}/README
-%doc mysql-release-%{mysql_version}/support-files/my-*.cnf
+%doc mysql-release-%{mysql_version}/support-files/my-example.cnf
 %if %{CLUSTER_BUILD}
 %doc mysql-release-%{mysql_version}/support-files/ndb-*.ini
 %endif