maria-discuss team mailing list archive

[Haidong Ji <haidong.ji@xxxxxxxxx>]

Hi Walter,

I think a sample file with ALL options will drown out the important
ones and causes confusion. Like I mentioned in the reply to Monty,
personally I think the target of sample my.cnf is for lower end users
(no disrespect intended whatsoever).

My 0.02c

Haidong

On Fri, Mar 18, 2011 at 3:33 PM, Walter Heck <walterheck@xxxxxxxxx> wrote:
> 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
>