OurSQL Episode 133: MySQL on Auto-Tune

This week, we talk about variables with changed default values in MySQL 5.6. Ear Candy is the pt-config-diff tool and At the Movies is Tim Callaghan of Tokutek talking about Fractal Trees.

Changed Defaults in MySQL 5.6

Percona's article about default variable differences in MySQL 5.5 and MySQL 5.6

MySQL 5.6 manual page about changes to server defaults in MySQL 5.6.

back_log

binlog_row_event_max_size

flush_time

innodb_autoextend_increment

innodb_buffer_pool_instances

innodb_thread_concurrency

innodb_concurrency_tickets

innodb_data_file_path

innodb_log_file_size

innodb_old_blocks_time

innodb_open_files

Bug 68777, pointing to incorrect documentation about innodb_open_files auto-sizing

innodb_purge_threads

innodb_stats_on_metadata

join_buffer_size

max_allowed_packet

max_connect_errors

article on reaching max_connect_errors, and doing a FLUSH HOSTS to recover

open_files_limit

sort_buffer_size

table_open_cache

table_open_cache problem

Ear Candy
pt-config-diff
mysqlsandbox

At the Movies
This week we present Tim Callaghan of Tokutek presenting Fractal Tree Indexes. Tim explains what B-tree indexes are, what fractal tree indexes are, and then spends the other half of the talk explaining how Tokutek uses them.

Where you can see us

Sheeri will be at the Boston April MySQL Meetup group on Monday April 8th featuring John Zablocki, developer advocate, giving an "Intro to Couchbase: NoSQL Document Database for Interactive Applications".

Gerry will present a tutorial during the Percona Live: MySQL Conference and Expo from Monday, April 22 through Thursday April 25th. The tutorial is on Using TokuDB: A Guided Walk Through TokuDB Implementation. Many of the concepts apply to custom MySQL / MariaDB installations as well.

Gerry will also be attending LinuxFest Northwest in Bellingham, Washington Saturday April 26th and Sunday April 27th.

Gerry will be at the May Seattle MySQL Meetup on Monday May 6th (http://www.meetup.com/seattlemysql/events/fmcdnyrhbjb/) at the surf incubator where we're going to attend a show and tell session showing some easy to use monitoring tools for MySQL that are adequate for smaller installation or implement some quick and easy instrumentation.

Sheeri will be at the May Boston MySQL User Group meeting on Monday May 13th at MIT, where we will learn about VoltDB.

Feedback

Facebook group

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