maria-discuss team mailing list archive

[Walter Heck <walterheck@xxxxxxxxx>]

I personally would be more in favor of a version that has _all_
options in it, with explanatory comments. Many options should not be
set, but they could be commented out. That would make it much easier
for users to get a grasp of available options and recommended
settings. For instance, zabbix' config file looks like this:

# This is a config file for Zabbix Agent (Unix)
# To get more information about Zabbix, visit http://www.zabbix.com

############ GENERAL PARAMETERS #################

### Option: PidFile
#	Name of PID file.
#
# Mandatory: no
# Default:
PidFile=/var/run/zabbix_agentd.pid

### Option: LogFile
#	Name of log file.
#	If not set, syslog is used.
#
# Mandatory: no
# Default:
# LogFile=

LogFile=/var/log/zabbix/zabbix_agentd.log

### Option: LogFileSize
#	Maximum size of log file in MB.
#	0 - disable automatic log rotation.
#
# Mandatory: no
# Range: 0-1024
# Default:
LogFileSize=1

### Option: DebugLevel
#	Specifies debug level
#	0 - no debug
#	1 - critical information
#	2 - error information
#	3 - warnings
#	4 - for debugging (produces lots of information)
#
# Mandatory: no
# Range: 0-4
# Default:
DebugLevel=3

### Option: SourceIP
#	Source IP address for outgoing connections.
#
# Mandatory: no
# Default:
# SourceIP=

On Fri, Mar 18, 2011 at 18:16, Haidong Ji <haidong.ji@xxxxxxxxx> wrote:
> All,
>
> I proposed updating the packaged my.cnf sample files before. After
> some thinking and deliberation, here are my thoughts on the sample
> my.cnf:
>
> 1. There are so many factors that affect settings in my.cnf so it is
> impossible to please everybody. There is a lot of debates on this.
> 2. There are values in having just ONE sample my.cnf to get beginners started
> 3. It should be short
> 4. It should incorporate best practices, to the extent that best
> practices can be agreed
> 5. It should benefit as many people as possible
>
> My proposal is pasted below. Comments welcome. At the same time,
> constant back-and-forth bickering won't benefit much either, in my
> opinion.
>
> Thanks,
> Haidong "Alex" Ji
>
>
> # MariaDB/Percona/Oracle 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
> #
> # For detailed definition of settings, see URL below:
> # http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html
>
> # Please do your own research, consult various resources
> # and experts for optimal settings for your own needs.
> # Some basic ones are provided below to get you started.
>
> # The following options will be passed to all MySQL clients
> [client]
> port            = 3306
> socket          = /var/lib/mysql/mysql.sock
>
>
> # The MySQL server
> [mysqld]
> port            = 3306
> socket          = /var/lib/mysql/mysql.sock
> user=mysql
>
> log-bin         = mysql-bin
> log-slow-queries
> sync_binlog     = 1
> expire_logs_days= 10
> wait_timeout    = 30
>
> #server-id       = last octet of IP address
> #character-set-server           = utf8
>
>
> [mysqldump]
> quick
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Walter Heck

--
follow @walterheck on twitter to see what I'm up to!
--
Check out my new startup: Server Monitoring as a Service @ http://tribily.com
Follow @tribily on Twitter and/or 'Like' our Facebook page at
http://www.facebook.com/tribily