2013-07-03 20:25:49 +02:00
|
|
|
-------------------------------------------------------------------
|
2013-07-19 00:35:18 +02:00
|
|
|
Thu Jul 18 22:34:14 UTC 2013 - andreas.stieger@gmx.de
|
2013-07-18 21:08:24 +02:00
|
|
|
|
|
|
|
|
- update to 2.2.4:
|
|
|
|
|
* Implemented pt-query-digest anonymous JSON output
|
|
|
|
|
* Implemented pt-online-schema-change timestamp output
|
|
|
|
|
- fixing the following bugs:
|
|
|
|
|
* Zero values causes "Invalid --set-vars value: var=0"
|
|
|
|
|
* pt-deadlock-logger error: Use of uninitialized value $ts in pattern match (m//)
|
|
|
|
|
* pt-heartbeat docs don't account for --utc
|
|
|
|
|
* pt-online-schema-change error copying rows: Undefined subroutine &pt_online_schema_change::get
|
|
|
|
|
* pt-query-digest docs don't mention --type=rawlog
|
|
|
|
|
* pt-query-digest doesn't group db and `db` together
|
|
|
|
|
* pt-query-digest and pt-fingerprint don't strip some multi-line comments
|
|
|
|
|
* pt-sift does not work if pt-stalk did not collect due to a full disk
|
|
|
|
|
* pt-table-checksum: Deep recursion on subroutine "SchemaIterator::_iterate_dbh"
|
|
|
|
|
* pt-table-checksum doesn't use non-unique index with highest cardinality
|
|
|
|
|
* pt-table-checksum fails if explicit_defaults_for_timestamp is enabled in 5.6
|
|
|
|
|
* pt-upgrade reports differences on NULL
|
|
|
|
|
* pt-variable-advisor has the wrong default value for innodb_max_dirty_pages_pct in 5.5 and 5.6
|
|
|
|
|
* pt-variable-advisor shows key_buffer_size in 5.6 as unconfigured (even though it is)
|
|
|
|
|
|
|
|
|
|
-------------------------------------------------------------------
|
2013-07-03 20:25:49 +02:00
|
|
|
Wed Jul 3 18:04:10 UTC 2013 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- update to 2.2.3
|
|
|
|
|
* Added new tool: pt-agent
|
|
|
|
|
* Fixed bug: pt-online-schema-change causes "ERROR 1146 (42S02):
|
|
|
|
|
Table 'db._t_new' doesn't exist"
|
|
|
|
|
|
2013-04-29 20:39:34 +02:00
|
|
|
-------------------------------------------------------------------
|
|
|
|
|
Mon Apr 29 18:25:28 UTC 2013 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- update to 2.2.2
|
|
|
|
|
* Added --show-all to pt-query-digest
|
|
|
|
|
* Added --recursion-method=cluster to pt-table-checksum
|
|
|
|
|
- fixing the following bugs:
|
|
|
|
|
* pt-archiver --bulk-insert may corrupt data
|
|
|
|
|
* pt-heartbeat --utc --check always returns 0
|
|
|
|
|
* pt-query-digest --processlist reports duplicate queries for
|
|
|
|
|
replication thread
|
|
|
|
|
* pt-query-digest 2.2 prints unwanted debug info on tcpdump
|
|
|
|
|
parsing errors
|
|
|
|
|
* pt-query-digest 2.2 prints too many string values
|
|
|
|
|
* pt-stalk prints the wrong variable name in verbose mode when
|
|
|
|
|
--function is used
|
|
|
|
|
* pt-stalk plugins can't access the real --prefix
|
|
|
|
|
* pt-table-checksum pxc same_node function incorrectly uses
|
|
|
|
|
wsrep_sst_receive_address
|
|
|
|
|
* Some tools don't have --help or --version
|
|
|
|
|
* Some tools use @@hostname without /*!50038*/
|
|
|
|
|
* An explicitly set wsrep_node_incoming_address may make SHOW
|
|
|
|
|
STATUS LIKE 'wsrep_incoming_addresses' return a portless address
|
|
|
|
|
|
2013-02-15 22:36:13 +01:00
|
|
|
-------------------------------------------------------------------
|
2013-04-08 23:48:47 +02:00
|
|
|
Mon Apr 8 21:26:02 UTC 2013 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- update to 2.2.1
|
|
|
|
|
This is the first release in the 2.2 series. Users are advised to
|
|
|
|
|
re-read documentation for tools.
|
|
|
|
|
- new features:
|
|
|
|
|
* Support for MySQL 5.6
|
|
|
|
|
* Support for Percona XtraDB Cluster
|
|
|
|
|
- major updates:
|
|
|
|
|
* Redesigned pt-query-digest
|
|
|
|
|
* Redesigned pt-upgrade
|
|
|
|
|
* Redesigned pt-fk-error-logger
|
|
|
|
|
* Redesigned pt-deadlock-logger
|
|
|
|
|
- changed options:
|
|
|
|
|
* 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 switches:
|
|
|
|
|
* Removed --lock-wait-timeout from pt-online-schema-change (use --set-vars)
|
|
|
|
|
* Removed --lock-wait-timeout from pt-table-checksum (use --set-vars)
|
|
|
|
|
- removed tools:
|
|
|
|
|
* Removed pt-query-advisor
|
|
|
|
|
* Removed pt-tcp-model
|
|
|
|
|
* Removed pt-trend
|
|
|
|
|
* Removed pt-log-player
|
|
|
|
|
- new defaults:
|
|
|
|
|
* Enabled --version-check by default in all tools
|
|
|
|
|
- fixing the following bugs:
|
|
|
|
|
* Fixed bug: Several tools don't have --database
|
|
|
|
|
* Fixed bug: Quoter::serialize_list() doesn't handle multiple NULL values
|
|
|
|
|
* Fixed bug: pt-config-diff needs to parse wsrep_provider_options
|
|
|
|
|
* Fixed bug: pt-fk-error-logger --run-time works differently than pt-deadlock-logger --run-time
|
|
|
|
|
* Fixed bug: pt-online-schema-change doesn't retry RENAME TABLE
|
|
|
|
|
* Fixed bug: pt-online-schema-change blocks on metadata locks
|
|
|
|
|
* Fixed bug: pt-stalk --no-stalk silently clobbers other options, acts magically
|
|
|
|
|
* Fixed bug: pt-stalk truncates InnoDB status if there are too many transactions
|
|
|
|
|
* Fixed bug: pt-table-checksum doesn't warn if no slaves are found
|
|
|
|
|
|
|
|
|
|
-------------------------------------------------------------------
|
2013-02-15 22:36:13 +01:00
|
|
|
Fri Feb 15 21:29:01 UTC 2013 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- update to 2.1.9 [bnc#804102], fixing the following bugs:
|
|
|
|
|
* pt-heartbeat 2.1.8 doesn't use precision/sub-second timestamps
|
|
|
|
|
* pt-heartbeat 2.1.8 reports big time drift with UTC_TIMESTAMP
|
|
|
|
|
* pt-online-schema-change fails with "Duplicate entry" on MariaDB
|
|
|
|
|
* pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns
|
|
|
|
|
* pt-pmp doesn't list the origin lib for each function
|
|
|
|
|
* pt-query-digest shouldn't print "Error: none" for tcpdump
|
|
|
|
|
* pt-query-digest fails to parse non-SQL errors
|
|
|
|
|
* pt-table-checksum: Confusing error message with binlog_format ROW or MIXED on slave
|
|
|
|
|
* pt-table-sync false-positive error "Cannot nibble table because MySQL chose no index
|
|
|
|
|
instead of the PRIMARY index"
|
|
|
|
|
* pt-stalk is too verbose, fills up log
|
|
|
|
|
|
2012-11-19 14:53:24 +01:00
|
|
|
-------------------------------------------------------------------
|
2013-01-11 14:26:53 +01:00
|
|
|
Fri Jan 11 13:25:36 UTC 2013 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- update to 2.1.8
|
|
|
|
|
* 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
|
|
|
|
|
- fixing the following bugs:
|
|
|
|
|
* Bad pod2rst transformation
|
|
|
|
|
* Bad online docs formatting for --[no]vars
|
|
|
|
|
* pt-config-diff is case-sensitive
|
|
|
|
|
* pt-config-diff doesn't handle end-of-line comments
|
|
|
|
|
* pt-config-diff Use of uninitialized value in substitution (s///) at line 1996
|
|
|
|
|
* pt-deadlock-logger doesn't handle usernames with dashes
|
|
|
|
|
* pt-heartbeat handles timezones inconsistently
|
|
|
|
|
* pt-kill --log-dsn timestamp is wrong
|
|
|
|
|
* pt-mysql-summary doesn't handle renamed variables in Percona Server 5.5
|
|
|
|
|
* pt-online-schema-change checks for foreign keys on MyISAM tables
|
|
|
|
|
* pt-query-advisor hangs on big queries
|
|
|
|
|
* pt-query-advisor RES.001 is incorrect
|
|
|
|
|
* pt-query-advisor false positive on RES.001
|
|
|
|
|
* pt-query-advisor issues wrong RES.001
|
|
|
|
|
* pt-query-digest fails to parse timestamp with no query
|
|
|
|
|
* pt-query-digest doesn't parse general log with "Connect user as user"
|
|
|
|
|
* pt-query-digest with custom --group-by throws error
|
|
|
|
|
* pt-query-digest prints negative byte offset
|
|
|
|
|
* pt-query-digest help output mangled
|
|
|
|
|
* pt-slave-restart CHANGE MASTER query causes error
|
|
|
|
|
* pt-stalk purge_samples slows down checks
|
|
|
|
|
* pt-stalk does not report NFS iostat
|
|
|
|
|
* pt-table-checksum doesn't ignore tables for --replicate-check-only
|
|
|
|
|
* pt-table-checksum v2 fails when --resume + --ignore-database is used
|
|
|
|
|
* pt-table-checksum debug statement for "Chosen hash func" prints undef
|
|
|
|
|
* pt-table-checksum Illegal division by zero at line 7950
|
|
|
|
|
* pt-table-checksum uninitialized value in numeric lt (<) at line 8611
|
|
|
|
|
* Tools let --set-vars clobber the required SQL mode
|
|
|
|
|
- also contains fixes from 2.1.7:
|
|
|
|
|
* pt-table-checksum 2.1.6 crashes using PTDEBUG
|
|
|
|
|
* pt-table-checksum 2.1.6 --check-binlog-format doesn't ignore PXC nodes
|
|
|
|
|
|
|
|
|
|
-------------------------------------------------------------------
|
2012-11-19 14:53:24 +01:00
|
|
|
Mon Nov 19 12:41:54 UTC 2012 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- update to 2.1.6
|
|
|
|
|
* 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
|
|
|
|
|
- fixing the following bugs
|
|
|
|
|
* --version-check default should be explicitly "off"
|
|
|
|
|
* LOAD DATA LOCAL INFILE broken in some platforms
|
|
|
|
|
* Useless use of cat in Daemon.pm
|
|
|
|
|
* Tools exit 0 on error parsing options, should exit non-zero
|
|
|
|
|
* pt-table-checksum doesn't warn if binlog_format=row or mixed on slaves
|
|
|
|
|
* pt-table-checksum breaks replication if a slave table is missing or different
|
|
|
|
|
* pt-table-checksum doesn't honor --run-time while checking replication lag
|
|
|
|
|
* pt-table-checksum error: Use of uninitialized value in int at line 2778
|
|
|
|
|
* pt-table-checksum can crash with --columns if none match
|
|
|
|
|
* pt-table-checksum dies if creating the --replicate table fails
|
|
|
|
|
* pt-table-checksum doesn't test all hash functions
|
|
|
|
|
* pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB Cluster nodes
|
|
|
|
|
* pt-deadlock-logger can't parse db/tbl/index on partitioned tables
|
|
|
|
|
* pt-online-schema-change DELETE trigger fails when altering primary key
|
|
|
|
|
* pt-online-schema-change fails if sql_mode explicitly or implicitly uses ANSI_QUOTES
|
|
|
|
|
* pt-online-schema-change fails with "I need a max_rows argument"
|
|
|
|
|
* pt-online-schema-change --quiet doesn't disable --progress
|
|
|
|
|
* pt-online-schema-change doesn't report how many warnings it suppressed
|
|
|
|
|
* pt-upgrade fails if select column > 64 chars
|
|
|
|
|
* pt-mysql-summary may report the wrong cnf file
|
|
|
|
|
* pt-mysql-summary incorrectly categorizes databases
|
|
|
|
|
* pt-show-grant doesn't support column-level grants
|
|
|
|
|
* pt-query-digest review table privilege checks don't work
|
|
|
|
|
* pt-query-digest docs for event attributes link to defunct Maatkit wiki
|
|
|
|
|
* pt-duplicate-key-checker fails when it encounters a crashed table
|
|
|
|
|
* pt-stalk deletes non-empty files
|
|
|
|
|
* pt-stalk --no-stalk and --iterations 1 don't wait for the collect
|
|
|
|
|
* pt-fifo-split is processing n-1 rows initially
|
|
|
|
|
* pt-find documentation error with mtime and InnoDB
|
|
|
|
|
* pt-trend output has no header
|
|
|
|
|
* pt-visual-explain docs link to missing pdf
|
|
|
|
|
* pt-fk-error-logger crashes if there's no foreign key error
|
|
|
|
|
* pt-fk-error-logger --dest table example doesn't work
|
|
|
|
|
|
2012-11-11 14:27:26 +01:00
|
|
|
-------------------------------------------------------------------
|
|
|
|
|
Sun Nov 11 13:16:38 UTC 2012 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- fix SLE 11 build by adding alternative perl macros
|
|
|
|
|
|
2012-10-04 10:00:58 +02:00
|
|
|
-------------------------------------------------------------------
|
2012-10-16 22:55:05 +02:00
|
|
|
Tue Oct 16 20:34:53 UTC 2012 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- update to 2.1.5
|
|
|
|
|
* pt-table-checksum 2.1.4 doesn't detect diffs on Percona XtraDB
|
|
|
|
|
Cluster nodes
|
|
|
|
|
* pt-table-checksum 2.1.4 miscategorizes Percona XtraDB Cluster-based
|
|
|
|
|
slaves as cluster nodes
|
|
|
|
|
* pt-table-sync 2.1.4 --version-check may not work with HTTPS/SSL
|
|
|
|
|
* Missing version-check page
|
|
|
|
|
|
|
|
|
|
-------------------------------------------------------------------
|
2012-10-04 10:00:58 +02:00
|
|
|
Tue Oct 2 17:25:30 UTC 2012 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- update to 2.1.4
|
|
|
|
|
* 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
|
|
|
|
|
* Document gdb dependency
|
|
|
|
|
* Unquoted arguments to tr break the bash tools
|
|
|
|
|
- fixing the following Percona bugs:
|
|
|
|
|
* pt-diskstats shows wrong device names
|
|
|
|
|
* pt-duplicate-key-checker error parsing InnoDB table with no PK or unique keys
|
|
|
|
|
* pt-online-schema-change dropping FK limitation isn't documented
|
|
|
|
|
* pt-online-schema-changes fails if db+tbl name exceeds 64 characters
|
|
|
|
|
* pt-query-digest --type tcpdump memory usage keeps increasing
|
|
|
|
|
* pt-query-digest won't distill LOCK TABLES in lowercase
|
|
|
|
|
* pt-stalk warns about bad "find" usage
|
|
|
|
|
* pt-stalk df -h throws away needed details
|
|
|
|
|
* pt-stalk --notify-by-email fails
|
|
|
|
|
* pt-stalk does not get all InnoDB lock data
|
|
|
|
|
* pt-summary should show information about Fusion-io cards
|
|
|
|
|
* pt-table-checksum doesn't work if slaves use RBR
|
|
|
|
|
* pt-table-checksum --check-slave-lag docs aren't clear
|
|
|
|
|
* pt-table-checksum --defaults-file isn't used for slaves
|
|
|
|
|
* pt-table-sync and text columns with just whitespace
|
|
|
|
|
* pt-table-sync base_count fails on n = 1000, base = 10
|
|
|
|
|
* pt-table-sync division by zero error with varchar primary key
|
|
|
|
|
* pt-table-sync priv checks need to be removed
|
|
|
|
|
* pt-upgrade error "I need a right_sth argument"
|
|
|
|
|
* sh warnings in pt-summary and pt-mysql-summary
|
|
|
|
|
* ChangeHandler doesn't quote varchar columns with hex-looking values
|
|
|
|
|
* CentOS 5 yum dependency resolution for perl module is wrong
|
|
|
|
|
* Percona Toolkit RPM should contain a dependency on perl-Time-HiRes
|
|
|
|
|
|
2012-09-27 01:43:34 +02:00
|
|
|
-------------------------------------------------------------------
|
|
|
|
|
Wed Sep 5 19:24:31 UTC 2012 - andreas.stieger@gmx.de
|
|
|
|
|
|
|
|
|
|
- initial package for Percona Toolkit 2.1.3,
|
|
|
|
|
based on upstream spec file some OBS occurrences
|
|
|
|
|
- based on and replacing Maatkit, obsoleting their last release 7410
|
2012-10-04 10:00:58 +02:00
|
|
|
|
