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 <[email protected]> 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 : [email protected] > 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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
