maria-discuss team mailing list archive

[Haidong Ji <haidong.ji@xxxxxxxxx>]

> I request setting max_allowed_packet 16M (at least - actually I'd prefer
> 64M) in both [mysqld] and [mysqldump] sections for all templates.  For the
> background for this request see
> http://www.webyog.com/blog/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet/

Excellent! Thanks Peter. Your explanation is clear and I learned
something from it!

Haidong

On Fri, Mar 18, 2011 at 4:28 PM, Peter Laursen <peter_laursen@xxxxxxxxxx> wrote:
> I request setting max_allowed_packet 16M (at least - actually I'd prefer
> 64M) in both [mysqld] and [mysqldump] sections for all templates.  For the
> background for this request see
> http://www.webyog.com/blog/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet/
>
> We have reports every month where we have to explain users this setting
> ("help - I can dump my database but I cannot restore it").  16/64M would
> eliminate the problem for most users.  And even for a single
> (MEDIUM/LONG)BLOB used to store an image from a modern 10Mpixel+ Digicam 1M
> is not enough - not even with JPG-compression (and of course not at all with
> RAW or TIFF formats used by professionals)
> Peter
> Webyog
> On Fri, Mar 18, 2011 at 21:33, 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
>>
>> _______________________________________________
>> 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
>
>