summaryrefslogtreecommitdiff
path: root/databases/percona-toolkit/Makefile
AgeCommit message (Collapse)AuthorFilesLines
2016-08-22Update databases/percona-toolkit to 2.2.19.fhajny1-2/+2
- 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
2016-08-09Update databases/percona-toolkit to 2.2.18.fhajny1-3/+2
- 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
2016-07-09Bump PKGREVISION for perl-5.24.0 for everything mentioning perl.wiz1-1/+2
2016-03-10Update databases/percona-toolkit to 2.2.17.fhajny1-3/+2
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
2015-07-12Comment out dependencies of the stylewiz1-2/+2
{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
2015-06-12Recursive PKGREVISION bump for all packages mentioning 'perl',wiz1-1/+2
having a PKGNAME of p5-*, or depending such a package, for perl-5.22.0.
2015-04-14Update percona-toolkit to 2.2.14.fhajny1-3/+3
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
2014-08-01Update percona-toolkit to 2.2.9.fhajny1-2/+2
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
2014-06-27v2.2.8 released 2014-05-30rodent1-3/+2
* 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)
2014-05-29Bump for perl-5.20.0.wiz1-1/+2
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.
2014-01-24Update percona-toolkit to version 2.2.6. Changes since 2.1.7:jperkin1-3/+4
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
2013-12-09Fix/Update DEPENDS paterns for perl CORE modules, with some trivial fixes.obache1-5/+4
Bump PKGREVISION for runtime dependency pattern changed packages.
2013-05-31Bump all packages for perl-5.18, thatwiz1-2/+2
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.
2013-01-27fix MASTER_SITES:obache1-3/+2
* 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.
2012-12-012.0.4 -> 2.1.7mspo1-3/+3
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
2012-10-03Bump all packages that use perl, or depend on a p5-* package, orwiz1-1/+2
are called p5-*. I hope that's all of them.
2012-10-02Drop superfluous PKG_DESTDIR_SUPPORT, "user-destdir" is default these days.asau1-2/+1
2012-03-21percona toolkit is the new name for maatkitmspo1-0/+30