In the news, the OurSQL podcast will change to a monthly format after episode 200. We will still bring the quality episodes you know and love, they will just be spaced further apart.
log_output of FILE, TABLE or both ("FILE,TABLE" or "TABLE,FILE")
slow query log - set it to 1 or 0, do *NOT* set it to ON (it will be off, because "on" is a string, and translates to 0)
long_query_time - microsecond resolution
log_throttle_queries_not_using_indexes server variable
Removing Evil Queries part 1, where we discuss how to use pt-query-digest to find queries that are good candidates for optimization.
Removing Evil Queries part 2, where we start to discuss how to use EXPLAIN to optimize queries.
Removing Evil Queries part 3, where we finish discussing how to use EXPLAIN to optimize queries.
Understanding InnoDB Locking
Innodb_row_lock_current_waits status variable
Innodb_row_lock_waits status variable
Innodb_row_lock_time, Innodb_row_lock_time_avg and Innodb_row_lock_time_max
innodb_lock_wait_timeout system variable
Optimizing Subqueries in the MySQL manual, including rewriting subqueries as joins
Measuring Linux Performance
At the movies
This week in At the Movies, we present Zardosht Kasheff of Tokutek talking about Understanding Indexes.
Zardosht explains how indexing works, including how secondary keys function, and also how covering indexes are a good way to optimize some queries.
On to Where you can see us
Where you can see us
Sheeri will be at MySQL Central at Oracle Open World Monday September 29th through Thursday October 2nd, 2014
Sheeri will be at the Boston MySQL User Group on Monday, October 13th at MIT.
Gerry will be at the Seattle MySQL Meetup on Monday, October 13th.