Up to [cvs.NetBSD.org] / pkgsrc / databases / percona-toolkit
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
databases: Replace RMD160 checksums with BLAKE2s checksums All checksums have been double-checked against existing RMD160 and SHA512 hashes The following distfiles could not be fetched (some may be only fetched conditionally): ./databases/cstore/distinfo D6.data.ros.gz ./databases/cstore/distinfo cstore0.2.tar.gz ./databases/cstore/distinfo data4.tar.gz
databases: Remove SHA1 distfile hashes
databases/percona-toolkit: Update to 3.0.12. v3.0.12 released 2018-09-13 - Fixed bug PT-1611: pt-archiver fails with UTF-8 chars - Fixed bug PT-1574: pt-online-schema-change fails on UK and NULLs - Fixed bug PT-1572: Better usage of ENUM fields in keys in NibbleIterator - Fixed bug PT-1422: pt-mysql-summary may get stuck when Time: NULL in processlist - Improvement PT-1321: Add required MySQL privileges to pt-online-schema-change documentation v3.0.11 released 2018-07-06 - Improvement PT-1571 : Improved hostname recognition in pt-secure-collect - Fixed bug PT-1570 : pt-archiver fails to detect columns with the word GENERATED as part of the comment - Improvement PT-1569 : Disabled --alter-foreign-keys-method=drop_swap in pt-osc - Fixed bug PT-1563 : Fixed pt-show-grants for MySQL 5.6 - Improvement PT-1562 : pt-mysql-summary: Fix mysqld command for Travis - Fixed bug PT-1551 : pt-table-checksum fails on MySQL 8.0.11 - Improvement PT-242 : (pt-stalk) Include SHOW SLAVE STATUS on 5.7 - Fixed bug PT-241 : (pt-stalk) Slave queries doesn't run on 5.7 v3.0.10 released 2018-05-21 - Fixed bug PT-1556 : pt-table-checksum 3.0.9 doesn't change binlog_format to statement anymore - Improvement PT-1546 : Improved support of MySQL 8 roles - Improvement PT-1543 : Encrypted table status query causes high load over multiple minutes - Improvement PT-1536 : Add info about encrypted tablespaces in pt-mysql-summary - Feature PT-131 : Make pt-table checksum to disable QRT plugin - Feature PT-118 : pt-table-checksum report the number of rows of difference between master and slave v3.0.9 released 2018-04-17 - Feature PT-1530 : Add support for encryption status to mysql-summary - Feature PT-1526 : Add ndb status to pt-mysql-summary - Feature PT-1525 : Added support for MySQL 8 roles into pt-mysql-summary - Feature PT-1509 : Only set binlog_format when necessary - Feature PT-1508 : Adding --read-only-interval flag, and read-only check on wake-up - Improvement PT-1507 : pt-summary does not reliably read in the transparent huge pages setting - New tool PT-1501 : pt-secure-collect - New tool to collect and sanitize pt-tools outputs - Feature PT-243 : Adding --max-hostname-length and --max-line-length to pt-query-digest v3.0.8 released 2018-03-13 - Feature PT-1500 : add --secure-slowlog option to pt-query digest v3.0.7 released 2018-03-01 - Fixed Bug PT-244 : pt-online-schema-change --data-dir option broken for partitioned table - Feature PT-633 : Added --mysql-only option to pt-stalk for RDS - Fixed bug PT-1256: pt-table-sync does not use the character set for the table it is synchronizing - Fixed bug PT-1455: pt-osc is stuck when the table that is being altered is filtered out in the slave - Fixed bug PT-1485: pt-mysql-summary has broken Security section in versions bigger then 5.6 - Fixed bug PMM-1905: Explain fails if encounters negative "ntoreturn"
databases/percona-toolkit: Update to 3.0.6. v3.0.6 released 2018-01-04 New Features - Improve pt-table-sync support for MyRocks - pt-stalk now checks the RocksDB status - pt-mysql-summary contains the RocksDB section - pt-osc shows a message if trying to set the engine to rocksdb and binlog_format != row. - pt-table-checksum skips RocksDB tables. Known Issues - The information message implemented for PT-204 has a typo when referring to the --ignore-engines parameter. This problem is planned to be fixed in the next release. - It has been detected that the implementation of PT-205 is not complete and pt-osc may fail when altering tables. This problem is planned to be fixed in the next release. Bug Fixes - The general log parser cannot handle timestamps which include time zones - pt-online-schema-change does not retry on a deadlock error when using Percona Server 5.7 - pt-table-checksum ignores generated columns v3.0.5 released 2017-11-20 New Features - Improve MongoDB Profiler for PMM and PT - The mongodb-query-digest supports MongoDB versions lower than 3.2; incorrect output was fixed. - The pt-summary, pt-mysql-summary, pt-mongodb-summary commands provide output in the the JSON format. - pt-mysql-summary shows the output of the Show Slave Hosts command. - pt-table-sync supports replication channels (requires MySQL version 5.7.6 or higher) Bug fixes - pt-mext fails if the Rsa_public_key variable is empty. - pt-mongodb-query-digest --version produced incorrect values. - pt-online-schema-change incorrectly processed virtual columns. - pt-online-schema-change command reported an error when the name of an index contained ‘unique’ as as the prefix or suffix. - pt-table-checksum did not detect differences on a system with the ROW based replication active. - pt-onine-schema-change --max-load paused if a status variable was passed 0 as the value. - pt-table-checksum reported a misleading error if a column comment contained an apostrophe. For more information, see #1708749. - In some cases, pt-table-checksum did not report that the same table contained different values on the master and slave. - pt-online-schema-change --alter could fail if field names contained upper case characters. For more information, see #1705998. - In some cases pt-mongodb-query-digest could not connect to a db using authentication. - In some cases, pt-kill could ignore the value of the --busy-time parameter. For more information, see #1016272. - When run with the --skip-check-slave-lag, the pt-table-checksum could fail in some cases. v3.0.4 released 2017-08-02 New Features - Added collection of information about prepared statements by pt-stalk when Performance Schema is enabled. For more information, - Added the --preserve-triggers option for pt-online-schema-change to support AFTER triggers. - Added --output-format option for pt-mongodb-summary to choose between JSON format and the default plain text. - Added the --output-format=csv parameter for pt-archiver to archive rows in CSV format. - Added the --only-same-schema-fks option for pt-online-schema-change to check foreigns keys only on tables with the same schema as the original table. This should speed up the tool’s execution, but keep in mind that if you have foreign keys referencing tables in other schemas, they won’t be detected. For more information, see #1690122. - Added the --check-unique-key-change option for pt-online-schema-change to abort if the specified statement for --alter is trying to add a unique index. This is supposed to avoid adding duplicate keys that might lead to silently losing data. - Added the --truncate-replicate-table option for pt-table-checksum to ensure stale data is removed. Bug fixes - Fixed pt-table-checksum to support tables that have columns with different collations or charsets. For more information, see #1674266. - Fixed primary key handling by pt-archiver. For more information, see #1691630. - Limited constraint name in the new table when running pt-online-schema-change. For more information, see #1491674. - Fixed the --no-check-binlog-format option for pt-table-checksum to work as expected. - Fixed the use of uninitialized value in printf() for pt-online-schema-change. For more information, see #1693614. - Fixed pt-table-sync to prevent field type point to be taken as decimal. - Reverted PT-116 to remove the --use-insert-ignore option from pt-online-schema-change. - Fixed the --skip-check-slave-lag feature for pt-table-checksum to safely check for undefined values. - Fixed regression in --check-slave-lag option for pt-online-schema-change. - Fixed regression in --skip-check-slave-lag option for pt-online-schema-change. - Fixed syntax error in pt-online-schema-change.
Update databases/percona-toolkit to 3.0.3 v3.0.3 - Sandbox won't start correctly if autocommit=0 in my.cnf - pt-online-schema-change should imply --no-drop-new-table - Fixed pt-mext not working with not empty Rsa_public_key - pt-stalk ps include memory usage outputs - Recognize comments in ALTER - pt-online-schema change eats data on adding a unique index. Added --[no]use-insert-ignore - Make DSNs params able to be repeatable - Made OptionParser to accept repeatable DSNs - Collect MySQL variables - Add --skip-check-slave-lag to pt-table-checksum - Added --skip-check-slave-lag to pt-osc - Added support for slave status in pt-stalk v3.0.2 - pt-mongodb tools add support for SSL connections - pt-mongodb-summary Cannot get security settings when connected to a mongod instance - pt-mongodb-query-digest Change the default sort order to -count (descending) - pt-mysql-summary password doesn't support '&' and '#' symbols - Update Makefile for mongodb tools - Collect information about locks and transactions using P_S (Thanks Agustin Gallego) - pt-stalk top CPU usage is useless - Fix pt-mongodb-query-digest query ID (Thanks Kamil Dziedzic) - pt-online-schema-change makes duplicate rows in _t_new for UPDATE t set pk=0 where pk=1 - Fixed PT tests - pt-table-checksum ignores slave-user and slave-password - pt-table-checksum fails if a database is dropped while the tool is running v3.0 - Improved fix (protocol parser fix): error when parsing tcpdump capture with pt-query-digest - pt-osc: Fails with duplicate key in table for self-referencing (Thanks Amiel Marqeta) - pt-summary exists with an error (Thanks Marcelo Altmann) - pt-mongodb-summary - pt-mongodb-query-digest v2.2.20 - pt-slave-restart fails on MariaDB 10.0.13 (gtid_mode confusion) - pt-show-grants fails against MariaDB10+ - pt-query-digest numbers in table or column names converted to question marks (--preserve-embedded-numbers) - pt-online-schema-change misses data. Fixed sort order for ENUM fields - pt-online-schema-change doesn't apply underscores to foreign keys individually - pt-upgrade fails with SELECT INTO - pt-slave-restart --config does not recognize = as separator - Added pause to NibbleIterator - --data-dir parameter in order to create the table on a different partition - with pt-table-checksum automatically exclude checking schemas named percona, percona_schema - pt-online-schema-change Added --remove-data-dir feature - Fixed several typos in the doc (Thanks Dario Minnucci) - Add Transparent huge pages info to pt-summary - Add Memory management library to pt-mysql-summary
Update databases/percona-toolkit to 2.2.19. - Recheck the list of slaves while OSC runs - pt-osc should error if server is a slave in row based replication - pt-table-checksum should force replica table charset to utf8 - Added --create-table-engine param to pt-heartbeat - SlowLogParser is able to handle dates in RFC339 format for MySQL 5.7 - pt-kill leaks memory each time it kills a query - Large BLOB/TEXT/BINARY Produces NULL Checksum - Fixed pt-archiver deletes wrong rows #103 - Added --slave-user and --slave-password to pt-online-schema-change & pt-table-sync - Handle GTID ranges where the left-side integer is larger than 9 - Remove extra word 'default' from the --verbose help - add enum column type to is_char check so that values are properly quoted
Update databases/percona-toolkit to 2.2.18. - pt-stalk now sorts the output of transactions by id - Added "Shared" memory info to pt-summary - Added the --no-vertical-format option for pt-query-digest, allowing compatibility with non-standard MySQL clients that don't support the \G directive at the end of a statement - Fixed error when parsing tcpdump capture with pt-query-digest - Improved pt-online-schema-change plugin documentation - Clarified the description of the --attribute-value-limit option for pt-query-digest - Fixed all PERL-based tools to return a zero exit status when run with the --version option - Fixed error that sometimes prevented to choose the primary key as index, when using the -where option for pt-table-checksum - Fixed the inability of pt-query-digest to parse the general log generated by MySQL (and Percona Server) 5.7 instance - Clarified the description of the --verbose option for pt-slave-restart
Update databases/percona-toolkit to 2.2.17. v2.2.17 released 2016-03-07 * General compatibility with MySQL 5.7 tools, docs and test suite * pt-mysql-summary displays incorrect info about Fast Server Restarts for Percona Server 5.6 * pt-online-schema-change cannot set sql_mode using --set-vars * pt-online-schema-change added --null-to-non-null option to allow NULLable columns to be converted to NOT NULL * pt-online-schema-change doesn't apply underscores to foreign keys individually * pt-online-schema Invalid recursion method: t=dsns * pt-online-schema-change fails when using --no-drop-old-table after 10 times * pt-query-digest : Redundant argument in sprintf * pt-query-digest doc bug with --since and too many colons * pt-query-digest: Make documentation of --attribute-value-limit option more clear * pt-show-grants fails against MySQL-5.7.6 * pt-show-grants doesn't sort column-level privileges * pt-slave-restart fails on MariaDB 10.0.13 (gtid_mode confusion) * pt-stalk: new var binlog_error_action causes bug in collect module * pt-table-checksum has high likelyhood to skip a table when row count is around chunk-size * chunk-size-limit * pt-table-checksum redundant argument in printf v2.2.16 released 2015-11-09 * pt-archiver dies with "MySQL server has gone away" when innodb_kill_idle_transaction set to low value and bulk insert/delete process takes too long time * pt-kill option --filter does not work * pt-online-schema-change should reconnect to slaves * pt-online-schema-change, MySQL 5.6, and InnoDB optimizer stats can cause downtime * pt-stalk find -warn option is not portable * Document that pt-table-checksum has high likelihood to skip a table when row count is around chunk-size * chunk-size-limit v2.2.15 released 2015-08-28 * pt-archiver checked lag too frequently * pt-archiver clarified function of --check-interval [DOC] * pt-archiver now accepts checking lag on multiple slaves * pt-archiver now checks for PXC flow control via --max-flow-ctl option * pt-archiver options --no-delete and --purge were not mutually exclusive * pt-archiver mysql timed out when innodb_kill_idle_transaction set to low value and check-slave-lag used * pt-duplicate-key-checker doesn't support triple quote in column name * pt-kill enable support for RDS * pt-mysql-summary lacked an --ask-pass option * pt-online-schema-change added --sleep option * pt-online-schema-change core dump on erroneous alter directive * pt-online-schema-change now checks for PXC flow control via --max-flow-ctl option * pt-online-schema-change unstable signal handling * pt-online-schema-change now controls constraint name length * pt-online-schema-change --chunk-size-limit=0 inhibited checksumming of single nibble tables * pt-sift failed when fetching missing tools * pt-stalk monitors tokudb status * pt-table-checksum doesn't reconnect to slaves when timed out on very long lags * passsword parameter must escape commas - all tools [DOC] * changes needed to build packages from git tree * write-user-docs script stopped working after switching to github * testing bugs related to newer perl versions
Add SHA512 digests for distfiles for databases category Problems found with existing distfiles: distfiles/D6.data.ros.gz distfiles/cstore0.2.tar.gz distfiles/data4.tar.gz distfiles/sphinx-2.2.7-release.tar.gz No changes made to the cstore or mariadb55-client distinfo files. Otherwise, existing SHA1 digests verified and found to be the same on the machine holding the existing distfiles (morden). All existing SHA1 digests retained for now as an audit trail.
Update percona-toolkit to 2.2.14. v2.2.14 released 2015-04-14 * Fixed bug 1402730 pt-duplicate-key-checker seems useless with MySQL 5.6 * Fixed bug 1415646 pt-duplicate-key-checker documentation does not explain how Size Duplicate Indexes is calculated * Fixed bug 1406390 pt-heartbeat crashes with sleep argument error * Fixed bug 1368244 pt-online-schema-change --alter-foreign-keys-method=drop-swap is not atomic * Fixed bug 1417864 pt-online-schema-change documentation, the interpretation of --tries create_triggers:5:0.5,drop_triggers:5:0.5 is wrong * Fixed bug 1404313 pt-query-digest: specifying a file that doesn't exist as log causes the tool to wait for STDIN instead of giving an error * Feature 1418446 pt-slave-find resolve IP addresses option * Fixed bug 1417558 pt-stalk with --collect-strace output doesn't go to an YYYY_MM_DD_HH_mm_ss-strace file * Fixed bug 1425478 pt-stalk removes non-empty files that start with empty line * Fixed bug 925781 pt-table-checksum checksum error when default-character-set = utf8 * Fixed bug 1381280 pt-table-checksum fails on BINARY field in PK * Feature 1439842 pt-table-sync lacks --ignore-tables-regex option * Fixed bug 1401399 pt-table-sync fails to close one db handle * Fixed bug 1442277 pt-table-sync-ignores system databases but doc doesn't clarify this * Fixed bug 1421781 pt-upgrade fails on SELECT ... INTO queries * Fixed bug 1421405 pt-upgrade fails to aggregate queries based on fingerprint * Fixed bug 1439348 pt-upgrade erroneously reports number of diffs * Fixed bug 1421025 rpm missing dependency on perl-TermReadKey for --ask-pass v2.2.13 released 2015-01-26 * Feature 1391240: pt-kill added query fingerprint hash to output * Fixed bug 1402668: pt-mysql-summary fails on cluster in Donor/Desynced status * Fixed bug 1396870: pt-online-schema-change CTRL+C leaves terminal in inconsistent state * Fixed bug 1396868: pt-online-schema-change --ask-pass option error * Fixed bug 1266869: pt-stalk fails to start if $HOME environment variable is not set * Fixed bug 1019479: pt-table-checksum does not work with sql_mode ONLY_FULL_GROUP_BY * Fixed bug 1394934: pt-table-checksum error in debug mode * Fixed bug 1321297: pt-table-checksum reports diffs on timestamp columns in 5.5 vs 5.6 * Fixed bug 1399789: pt-table-checksum fails to find pxc nodes when wsrep_node_incoming_address is set to AUTO * Fixed bug 1388870: pt-table-checksum has some errors with different time zones * Fixed bug 1408375: vulnerable to MITM attack which would allow exfiltration of MySQL configuration information via --version-check * Fixed bug 1404298: missing MySQL5.7 test files for pt-table-checksum * Fixed bug 1403900: added sandbox and fixed sakila test db for 5.7 v2.2.12 released 2014-11-14 * Fixed bug 1376561: pt-archiver is not able to archive all the rows when a table has a hash partition * Fixed bug 1328686: pt-heartbeat check-read-only option does not prevent creates or inserts * Fixed bug 1269695: pt-online-schema-change does not allow ALTER for a table without a non-unique, while manual does not explain this * Fixed bug 1217466: pt-table-checksum refuses to run on PXC if server_id is the same on all nodes * Fixed bug 1373937: pt-table-checksum requires recursion when working with and XtraDB Cluster node * Fixed bug 1377888: pt-query-digest manual for --type binlog is ambiguous * Fixed bug 1349086: pt-stalk should also gather dmesg output * Fixed bug 1361293: Some scripts fail when no-version-check option is put in global config file v2.2.11 released 2014-09-26 * Fixed bug 1262456: pt-query-digest doesn't report host details * Fixed bug 1264580: pt-mysql-summary incorrectly tries to parse key/value pairs in wsrep_provider_options resulting in incomplete my.cnf information * Fixed bug 1318985: pt-stalk should use SQL_NO_CACHE * Fixed bug 1348679: pt-stalk handles mysql user password in awkward way * Fixed bug 1365085: Various issues with tests * Fixed bug 1368379: pt-summary problem parsing dmidecode output on some machines * Fixed bug 1303388: Typo in pt-variable-advisor v2.2.10 released 2014-08-06 * Fixed bug 1287253: pt-table-checksum deadlock * Fixed bug 1299387: 5.6 slow query log Thead_id becomes Id * Fixed bug 1311654: pt-table-checksum + PXC inconsistent results upon --resume * Fixed bug 1340728: pt-online-schema-change doesn't work with HASH indexes * Fixed bug 1253872: pt-table-checksum max load 20% rounds down * Fixed bug 1340364: some shell tools output error when queried for --version
Update percona-toolkit to 2.2.9. Changes: * Fixed bug 1258135: pt-deadlock-logger introduces a noise to MySQL * Fixed bug 1329422: pt-online-schema-change foreign-keys-method=none breaks constraints * Fixed bug 1315130: pt-online-schema-change not properly detecting foreign keys * Fixed bug 1335960: pt-query-digest cannot parse binlogs from 5.6 * Fixed bug 1335322: pt-stalk fails when variable or threshold is non-integer
v2.2.8 released 2014-05-30 * Removed pt-agent * Added pt-slave-restart GTID support * Added pt-table-checksum --plugin * Fixed bug 1304062: --ignore-tables does not work correctly * Fixed bug 1295667: pt-deadlock-logger logs incorrect ts * Fixed bug 1254233: pt-mysql-summary blank InnoDB section for 5.6 * Fixed bug 1286250: pt-online-schema-change requests password twice * Fixed bug 965553: pt-query-digest dosn't fingerprint true/false literals correctly * Fixed bug 290911: pt-show-grant --ask-pass prints "Enter password" to STDOUT v2.2.7 released 2014-02-20 * Fixed bug 1279502: --version-check behaves like spyware (CVE 2014-2029)
Update percona-toolkit to version 2.2.6. Changes since 2.1.7: v2.2.6 released 2013-12-18 * Added pt-query-digest support for Percona Server slow log rate limiting * Added pt-agent --ping * Added pt-mysql-summary --all-databases * Added pt-stalk --sleep-collect * Added pt-table-sync --[no]check-child-tables * Fixed bug 1249150: PTDEBUG prints some info to STDOUT * Fixed bug 1248363: pt-agent requires restart after changing MySQL options * Fixed bug 1248778: pt-agent --install on PXC is not documented * Fixed bug 1250973: pt-agent --install doesn't check for previous install * Fixed bug 1250968: pt-agent --install suggest MySQL user isn't quoted * Fixed bug 1251004: pt-agent --install error about slave is confusing * Fixed bug 1251726: pt-agent --uninstall fails if agent is running * Fixed bug 1248785: pt-agent docs don't list privs required for its MySQL user * Fixed bug 1215016: pt-deadlock-logger docs use pt-fk-error-logger * Fixed bug 1201443: pt-duplicate-key-checker error when EXPLAIN key_len=0 * Fixed bug 1217013: pt-duplicate-key-checker misses exact duplicate unique indexes * Fixed bug 1214685: pt-mysql-summary schema dump prompt can't be disabled * Fixed bug 1195628: pt-online-schema-change gets stuck looking for its own _new table * Fixed bug 1249149: pt-query-digest stats prints to STDOUT instead of STDERR * Fixed bug 1071979: pt-stak error parsing df with NFS * Fixed bug 1223458: pt-table-sync deletes child table rows v2.2.5 released 2013-10-16 * Added Query_time histogram bucket counts to pt-query-digest JSON output * Added pt-online-schema-change --[no]drop-triggers option * Fixed bug 1206677: pt-agent docs reference clodu.percona.com * Fixed bug 1226721: pt-agent on CentOS 5 fails to send data * Fixed bug 1199589: pt-archiver deletes data despite --dry-run * Fixed bug 1206728: pt-deadlock-logger 2.2 requires DSN on command line * Fixed bug 1209436: pt-kill --log-dsn may not work on Perl 5.8 * Fixed bug 1215608: pt-online-schema-change new table suffix is hard-coded * Fixed bug 821692: pt-query-digest doesn't distill LOAD DATA correctly * Fixed bug 984053: pt-query-digest doesn't distill INSERT/REPLACE without INTO correctly * Fixed bug 821690: pt-query-digest doesn't distill IF EXISTS correctly * Fixed bug 1210537: pt-table-checksum --recursion-method=cluster crashes if no nodes are found * Fixed bug 944051: pt-table-checksum has ambiguous exit status * Fixed bug 1229861: pt-table-sync quotes float values, can't sync v2.2.4 released 2013-07-18 * Implemented pt-query-digest anonymous JSON output * Implemented pt-online-schema-change timestamp output * Fixed bug 1182856: Zero values causes "Invalid --set-vars value: var=0" * Fixed bug 1195034: pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//) * Fixed bug 1137556: pt-heartbeat docs don't account for --utc * Fixed bug 1188264: pt-online-schema-change error copying rows: Undefined subroutine &pt_online_schema_change::get * Fixed bug 1171968: pt-query-digest docs don't mention --type=rawlog * Fixed bug 1176010: pt-query-digest doesn't group db and `db` together * Fixed bug 1174956: pt-query-digest and pt-fingerprint don't strip some multi-line comments * Fixed bug 1172317: pt-sift does not work if pt-stalk did not collect due to a full disk * Fixed bug 1136559: pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh" * Fixed bug 1199591: pt-table-checksum doesn't use non-unique index with highest cardinality * Fixed bug 1163735: pt-table-checksum fails if explicit_defaults_for_timestamp is enabled in 5.6 * Fixed bug 1168434: pt-upgrade reports differences on NULL * Fixed bug 1168106: pt-variable-advisor has the wrong default value for innodb_max_dirty_pages_pct in 5.5 and 5.6 * Fixed bug 1168110: pt-variable-advisor shows key_buffer_size in 5.6 as unconfigured (even though it is) v2.2.3 released 2013-06-17 * Added new tool: pt-agent * Fixed bug 1188002: pt-online-schema-change causes "ERROR 1146 (42S02): Table 'db._t_new' doesn't exist" v2.2.2 released 2013-04-24 * Added --show-all to pt-query-digest * Added --recursion-method=cluster to pt-table-checksum * Fixed bug 1127450: pt-archiver --bulk-insert may corrupt data * Fixed bug 1163372: pt-heartbeat --utc --check always returns 0 * Fixed bug 1156901: pt-query-digest --processlist reports duplicate queries for replication thread * Fixed bug 1160338: pt-query-digest 2.2 prints unwanted debug info on tcpdump parsing errors * Fixed bug 1160918: pt-query-digest 2.2 prints too many string values * Fixed bug 1156867: pt-stalk prints the wrong variable name in verbose mode when --function is used * Fixed bug 1081733: pt-stalk plugins can't access the real --prefix * Fixed bug 1099845: pt-table-checksum pxc same_node function incorrectly uses wsrep_sst_receive_address * Fixed bug 821502: Some tools don't have --help or --version * Fixed bug 947893: Some tools use @@hostname without /*!50038*/ * Fixed bug 1082406: An explicitly set wsrep_node_incoming_address may make SHOW STATUS LIKE 'wsrep_incoming_addresses' return a portless address v2.2.1 released 2013-03-14 * Official support for MySQL 5.6 * Official support for Percona XtraDB Cluster * Redesigned pt-query-digest * Redesigned pt-upgrade * Redesigned pt-fk-error-logger * Redesigned pt-deadlock-logger * Changed --set-vars in all tools * Renamed --retries to --tries in pt-online-schema-change * Added --check-read-only to pt-heartbeat * Added MySQL options to pt-mysql-summary * Added MySQL options to pt-stalk * Removed --lock-wait-timeout from pt-online-schema-change (use --set-vars) * Removed --lock-wait-timeout from pt-table-checksum (use --set-vars) * Removed pt-query-advisor * Removed pt-tcp-model * Removed pt-trend * Removed pt-log-player * Enabled --version-check by default in all tools * Fixed bug 1008796: Several tools don't have --database * Fixed bug 1087319: Quoter::serialize_list() doesn't handle multiple NULL values * Fixed bug 1086018: pt-config-diff needs to parse wsrep_provider_options * Fixed bug 1056838: pt-fk-error-logger --run-time works differently than pt-deadlock-logger --run-time * Fixed bug 1093016: pt-online-schema-change doesn't retry RENAME TABLE * Fixed bug 1113301: pt-online-schema-change blocks on metadata locks * Fixed bug 1125665: pt-stalk --no-stalk silently clobbers other options, acts magically * Fixed bug 1019648: pt-stalk truncates InnoDB status if there are too many transactions * Fixed bug 1087804: pt-table-checksum doesn't warn if no slaves are found v2.1.9 released 2013-02-14 * Fixed bug 1103221: pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps * Fixed bug 1099665: pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP * Fixed bug 1099836: pt-online-schema-change fails with "Duplicate entry" on MariaDB * Fixed bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns * Fixed bug 1115333: pt-pmp doesn't list the origin lib for each function * Fixed bug 823411: pt-query-digest shouldn't print "Error: none" for tcpdump * Fixed bug 1103045: pt-query-digest fails to parse non-SQL errors * Fixed bug 1105077: pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave * Fixed bug 918056: pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index instead of the PRIMARY index" * Fixed bug 1099933: pt-stalk is too verbose, fills up log v2.1.8 released 2012-12-21 * Beta support for MySQL 5.6 * Beta support for Percona XtraDB Cluster * pt-online-schema-change: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer * pt-table-checksum: If ran on Percona XtraDB Cluster, requires PXC 5.5.28 or newer * pt-upgrade: Added --[no]disable-query-cache * Fixed bug 927955: Bad pod2rst transformation * Fixed bug 898665: Bad online docs formatting for --[no]vars * Fixed bug 1022622: pt-config-diff is case-sensitive * Fixed bug 1007938: pt-config-diff doesn't handle end-of-line comments * Fixed bug 917770: pt-config-diff Use of uninitialized value in substitution (s///) at line 1996 * Fixed bug 1082104: pt-deadlock-logger doesn't handle usernames with dashes * Fixed bug 886059: pt-heartbeat handles timezones inconsistently * Fixed bug 1086259: pt-kill --log-dsn timestamp is wrong * Fixed bug 1015590: pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5 * Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables * Fixed bug 823431: pt-query-advisor hangs on big queries * Fixed bug 996069: pt-query-advisor RES.001 is incorrect * Fixed bug 933465: pt-query-advisor false positive on RES.001 * Fixed bug 937234: pt-query-advisor issues wrong RES.001 * Fixed bug 1082599: pt-query-digest fails to parse timestamp with no query * Fixed bug 1078838: pt-query-digest doesn't parse general log with "Connect user as user" * Fixed bug 957442: pt-query-digest with custom --group-by throws error * Fixed bug 887638: pt-query-digest prints negative byte offset * Fixed bug 831525: pt-query-digest help output mangled * Fixed bug 932614: pt-slave-restart CHANGE MASTER query causes error * Fixed bug 1046440: pt-stalk purge_samples slows down checks * Fixed bug 986847: pt-stalk does not report NFS iostat * Fixed bug 1074179: pt-table-checksum doesn't ignore tables for --replicate-check-only * Fixed bug 911385: pt-table-checksum v2 fails when --resume + --ignore-database is used * Fixed bug 1041391: pt-table-checksum debug statement for "Chosen hash func" prints undef * Fixed bug 1075638: pt-table-checksum Illegal division by zero at line 7950 * Fixed bug 1052475: pt-table-checksum uninitialized value in numeric lt (<) at line 8611 * Fixed bug 1078887: Tools let --set-vars clobber the required SQL mode
2.0.4 -> 2.1.7 tons of bug fixes new features: * pt-online-schema-change: Columns can now be renamed without data loss * pt-online-schema-change: New --default-engine option * pt-stalk: Plugin hooks available through the --plugin option to extend the tool's functionality * pt-table-checksum: Percona XtraDB Cluster support * pt-table-checksum: Implemented the standard --run-time option * Implemented the version-check feature in several tools, enabled with the --version-check option * pt-kill: Implemented --log-dsn to log info about killed queries to a table * pt-heartbeat: Implemented --recursion-method=none * pt-index-usage: MySQL 5.5 compatibility fixes * pt-log-player: MySQL 5.5 compatibility fixes * pt-online-schema-change: Added --chunk-index-columns * pt-online-schema-change: Added --[no]check-plan * pt-online-schema-change: Added --[no]drop-new-table * pt-online-schema-change: Implemented --recursion-method=none * pt-query-advisor: Added --report-type for JSON output * pt-query-digest: Removed --[no]zero-bool * pt-slave-delay: Added --database * pt-slave-find: Implemented --recursion-method=none * pt-slave-restart: Implemented --recursion-method=none * pt-table-checksum: Added --chunk-index-columns * pt-table-checksum: Added --[no]check-plan * pt-table-checksum: Implemented --recursion-method=none * pt-table-sync: Disabled --lock-and-rename except for MySQL 5.5 and newer * pt-table-sync: Implemented --recursion-method=none * Completely redesigned pt-online-schema-change * Completely redesigned pt-mysql-summary * Completely redesigned pt-summary * Added new tool: pt-table-usage * Added new tool: pt-fingerprint
percona toolkit is the new name for maatkit
Initial revision