2018-08-22 11:48:07 by Thomas Klausner | Files touched by this commit (3558) |
Log message:
Recursive bump for perl5-5.28.0
|
2018-02-19 20:22:09 by Filip Hajny | Files touched by this commit (2) |
Log message:
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.
|
2017-08-21 01:54:33 by Johnny C. Lam | Files touched by this commit (1) |
Log message:
databases/percona-toolkit: Remove ${WRKDIR} references in scripts.
Several Perl-generated scripts were installed with the interpreter
being in the tools directory. Use subst.mk to fix the interpreter
path at the head of these scripts. Add "sh" as a run-time tool
dependency since several of the scripts installed require a POSIX
shell.
Bump the PKGREVISION due to changes in the installed scripts.
|
2017-06-12 21:32:59 by Filip Hajny | Files touched by this commit (2) |
Log message:
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
|
2016-08-22 11:54:26 by Filip Hajny | Files touched by this commit (2) |
Log message:
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
|
2016-08-09 11:24:04 by Filip Hajny | Files touched by this commit (2) |
Log message:
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
|
2016-07-09 08:39:18 by Thomas Klausner | Files touched by this commit (1068) |
Log message:
Bump PKGREVISION for perl-5.24.0 for everything mentioning perl.
|
2016-03-10 11:29:53 by Filip Hajny | Files touched by this commit (2) |
Log message:
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
|
2015-11-03 02:56:36 by Alistair G. Crooks | Files touched by this commit (368) |
Log message:
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.
|
2015-07-12 20:56:37 by Thomas Klausner | Files touched by this commit (405) |
Log message:
Comment out dependencies of the style
{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
|