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
table_open_cache
The MySQL manual explains Error 24, when there are not enough file descriptors.
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