This release of MySQL Toolkit fixes some minor bugs and adds new functionality to four of the tools. Some of the changes I made were in response to feedback I got at the recent MySQL Camp. I’m still working on some of the feature requests, such as daemon-izing certain tools.
For those who requested features for MySQL Query Profiler, the tab-separated format should give you the desired output: no zero rows, and variables are not renamed.
Here’s a changelog:
Changelog for mysql-duplicate-key-checker: 2007-09-01: version 1.1.0 * Column printout was misaligned one space. * Refactored into a runnable module and added tests. * Redundant indexes were only detected if the shorter index was first. * Redundant foreign keys sometimes weren't detected. * All indexes on MEMORY tables were reported as HASH. * Added --clustered option to report appended PK columns as dupes for InnoDB and solidDB. Changelog for mysql-query-profiler: 2007-09-01: version 1.1.4 * SHOW STATUS inconsistencies after a FLUSH were skewing status. Changelog for mysql-table-checksum: 2007-09-01: version 1.1.14 * Added documentation about the storage engine for the checksum table. * The --replcheck option now checks the server and its slaves. Changelog for mysql-visual-explain: 2007-09-01: version 1.0.2 * FULLTEXT indexes were not recognized (type=fulltext in EXPLAIN). * Temporary/filesort were not added to the right node in the tree. * Added a new node type for "Range checked for each record."