------------------------------------------------------------------- Thu Oct 17 11:39:27 UTC 2013 - andreas.stieger@gmx.de - update to 2.2.5: * Query_time histogram has been added to the pt-query-digest JSON output, not the actual chart but the values necessary to render the chart later, so the values for each bucket. * As of pt-table-checksum 2.2.5, skipped chunks cause a non-zero exit status. An exit status of zero or 32 is equivalent to a zero exit status with skipped chunks in previous versions of the tool. * New --no-drop-triggers option has been implemented for pt-online-schema-change in case users want to rename the tables manually, when the load is low. * New --new-table-name option has been added to pt-online-schema-change which can be used to specify the temporary table name. - Bugs Fixed: * pt-archiver would delete the data even with the --dry-run option. * pt-query-digest didn’t distill LOAD DATA correctly. * pt-query-digest didn’t distill INSERT/REPLACE without INTO correctly. * pt-agent docs were referencing wrong web address. * pt-table-checksum --recursion-method=cluster option would crash if no nodes were found. ------------------------------------------------------------------- Thu Jul 18 22:34:14 UTC 2013 - andreas.stieger@gmx.de - 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) ------------------------------------------------------------------- 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" ------------------------------------------------------------------- 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 ------------------------------------------------------------------- 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 ------------------------------------------------------------------- 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 ------------------------------------------------------------------- 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 ------------------------------------------------------------------- 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 ------------------------------------------------------------------- Sun Nov 11 13:16:38 UTC 2012 - andreas.stieger@gmx.de - fix SLE 11 build by adding alternative perl macros ------------------------------------------------------------------- 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 ------------------------------------------------------------------- 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 ------------------------------------------------------------------- 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