OurSQL Episode 37: It's Still Not Our (De)fault! Part 2

This week, Giuseppe Maxia joins us as a special guest and we complete our 2-part series on what we always put in our configuration files, and why.
Part 1 in the series.

strings man page
MySQL manual page about defaults-group-suffix
Giuseppe's article about the hidden options file trick

Logging:
log_error
log_warnings

Binary logging and replication:
log-bin
server_id
log-slave-updates
expire-logs-days
sync_binlog NOTE: the default is 0, not 1 as we say in the podcast. Thanx to Derek Downey for pointing that out.

innodb_flush_log_at_trx_commit

Slow query logging:
log_output
slow_query_log
long_query_time
slow_query_log_file
log_queries_not_using_indexes
min_examined_row_limit

Other slave parameters:
read_only
report_host and report_user so SHOW SLAVE HOSTS work on the master.

Tuning options:
max_connections

max_connect_errors
Sheeri's article about this issue is FLUSH HOSTS, aborted connections, and max_connect_errors.

query_cache_size
query_cache_type
SQL_CACHE and SQL_NO_CACHE and the query cache

Domas Mituzas' query cache tuning guide

innodb_buffer_pool_size

table_open_cache
The MySQL manual explains Error 24, when there are not enough file descriptors.

table_definition_cache

thread_cache_size

max_allowed_packet

wait_timeout

interactive_timeout

sort_buffer_size
max_heap_table_size
tmp_table_size

mysqltuner 2.0 and a 5-minute video about mysqltuner 2.0 and what to use

Ear candy
clear with \c

Where you can see us
On Thursday, April 7, 2011 at 6:30 PM Giuseppe will speak at the San Francisco MySQL User Group about "Advanced Replication for the Masses". The topic will cover how to do advanced replication tasks not possible with the standard MySQL build, such as allowing a slave to have more than one master and having a multi-threaded process to apply SQL statements to the slave.

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.

Feedback
Facebook group
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1107