OurSQL Episode 171: Another Round of Toolkit

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127, Episode 133, Episode 155, Episode 158, Episode 167.

pt-align
pt-fifo-split
Unix split man page
Example from 2008 of loading a large file into InnoDB
Named pipe, or FIFO description on Wikipedia.

pt-diskstats
Episode 124, where we talked about Linux I/O schedulers

pt-ioprofile

pt-fk-error-logger

pt-mext

$ mysqladmin ext -c 5 -i 1 | grep Table_locks_immediate
| Table_locks_immediate                         | 19116716198   |
| Table_locks_immediate                         | 19116721648   |
| Table_locks_immediate                         | 19116723257   |
| Table_locks_immediate                         | 19116724868   |
| Table_locks_immediate                         | 19116727314   |

$  pt-mext -r -- "mysqladmin ext -c 5 -i 1"  | grep Table_locks_immediate
Table_locks_immediate               19117348314          4766          3297          2411

pt-mysql-summary

Ear Candy
Domas Mituzas note in the MySQL at Facebook blog
tzfile man page
mysql_tzinfo_tosql documentation page
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

zoneinfo database at the MySQL developer zone
time zone support in MySQL on the manual pace

At the movies
This week in at the movies, we present Jacob Nikom at the November 2013 Boston MySQL User Group presenting on Using GTID-based Replication for MySQL High Availability. This is a great presentation that explains both coordinate and GTID-based replication and how they can be used for high availability.

Where you can see us
Sheeri will be at the February Boston MySQL User Group on Monday, February 10th.

Gerry will be at the February Seattle MySQL Meetup Group on Monday, February 10th featuring Ivan Zoratti talking about MaxScale

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

Trackback URL for this post:

http://technocation.org/trackback/1287