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.
Unix split man page
Example from 2008 of loading a large file into InnoDB
Named pipe, or FIFO description on Wikipedia.
$ 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
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.