Age | Commit message (Collapse) | Author | Files | Lines |
|
- 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
|
|
- 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
|
|
|
|
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
|
|
{perl>=5.16.6,p5-ExtUtils-ParseXS>=3.15}:../../devel/p5-ExtUtils-ParseXS
since pkgsrc enforces the newest perl version anyway, so they
should always pick perl, but sometimes (pkg_add) don't due to the
design of the {,} syntax.
No effective change for the above reason.
Ok joerg
|
|
having a PKGNAME of p5-*, or depending such a package,
for perl-5.22.0.
|
|
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
|
|
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
|
|
* 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)
|
|
Do it for all packages that
* mention perl, or
* have a directory name starting with p5-*, or
* depend on a package starting with p5-
like last time, for 5.18, where this didn't lead to complaints.
Let me know if you have any this time.
|
|
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
|
|
Bump PKGREVISION for runtime dependency pattern changed packages.
|
|
a) refer 'perl' in their Makefile, or
b) have a directory name of p5-*, or
c) have any dependency on any p5-* package
Like last time, where this caused no complaints.
|
|
* use ${PKGVERSION_NOREV} instead of LATEST as subdir, or it will be invalid
after new release.
* this site's redirect response is invalid, use canonical one and curl will not
be required anymore.
|
|
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
|
|
are called p5-*.
I hope that's all of them.
|
|
|
|
|