Nick Pisarro, aka @highenergybeams, suggested we do a podcast about the MySQL defaults we recommend always having, as MySQL's pre-configured option files are not particularly helpful. So we have put together a 2-part podcast on the options that we change.
About the Configuration File
Location and precedence of configuration files for Windows, Unix and Mac OS X:
Note: We use the term "directive" to refer to the groups of options that begin with [groupname]. Upon reading the manual page again, we realized that the term is actually "option group". (Sheeri takes complete blame for this -- "directive" is actually the term for what !includedir and !include are...)
Overall Server Settings
We mentioned default-character-set but it has been deprecated in MySQL 5.1 and removed in MySQL 5.5, in favor of using character-set-server. As we mentioned in the beginning, check your error logs when you restart mysqld and fix any warnings -- deprecated features will definitely show up there.
log_slow_slave_statements - log slow queries that come through replication
Where you can see us
On Monday March 7th at 7pm PT, the Seattle MySQL meetup will happen with Brian Aker talking about Drizzle 7 and the upcoming GA version! http://www.meetup.com/seattlemysql/events/16489408/
Sheeri will be at Collaborate in Orlando, Florida from Sunday April 10th through Thursday April 14th. She is organizing the Community dinner, eastern US edition on Sunday April 10th at 5 pm at Maggiano's Little Italy near the Convention Center.
Sarah will be at the O'Reilly MySQL Conference in Santa Clara, California from Monday, April 11th through Thursday April 14th, including the community dinner, western US edition on Monday April 11th at 7 pm at Pedro's.
Sheeri will be speaking about monitoring MySQL efficiently with Nagios at the Professional IT Community Conference, otherwise known as PICC, in New Brunswick, New Jersey. The conference is Friday, April 29 – Saturday April 30, 2011.
Sheeri will be at OpenDBCamp, Fri May 6th - Sun May 8th in Sardinia, Italy.