> 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_laur...@webyog.com> 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 <walterh...@gmail.com> 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...@gmail.com> 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@lists.launchpad.net >> > 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@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp > > _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
