maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

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
>