notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Why was the website so slow for so long?

The cause of the slowdown was a change to the ZFS dataset. In conjunction with the database server, very little caching was being done. This combination resulted in increased disk I/O as the system churned through the database. Details in the blog post which outlines the various things which changed. Many graphs.

Port details
percona57-client Multithreaded SQL database (client)
5.7.29.32 databases on this many watch lists=0 search for ports that depend on this port An older version of this port was marked as vulnerable. Find issues related to this port Report an issue related to this port 5.7.28.31Version of this port present on the latest quarterly branch. NOTE: Slave port - quarterly revision is most likely wrong.
Maintainer: fluffy@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-01-10 18:54:45
Last Update: 2020-01-02 05:44:14
SVN Revision: 521796
License: GPLv2+
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (148 items)
  1. @ldconfig
  2. /usr/local/share/licenses/percona57-client-5.7.29.32/catalog.mk
  3. /usr/local/share/licenses/percona57-client-5.7.29.32/LICENSE
  4. /usr/local/share/licenses/percona57-client-5.7.29.32/GPLv2+
  5. bin/mysql
  6. bin/mysqladmin
  7. bin/mysqlbinlog
  8. bin/mysqlcheck
  9. bin/mysql_config
  10. bin/mysql_config_editor
  11. bin/mysqldump
  12. bin/mysqlimport
  13. bin/mysqlpump
  14. bin/mysql_secure_installation
  15. bin/mysqlshow
  16. bin/mysqlslap
  17. bin/mysql_ssl_rsa_setup
  18. include/mysql/big_endian.h
  19. include/mysql/binary_log_types.h
  20. include/mysql/byte_order_generic.h
  21. include/mysql/byte_order_generic_x86.h
  22. include/mysql/decimal.h
  23. include/mysql/errmsg.h
  24. include/mysql/hash.h
  25. include/mysql/keycache.h
  26. include/mysql/little_endian.h
  27. include/mysql/m_ctype.h
  28. include/mysql/m_string.h
  29. include/mysql/my_alloc.h
  30. include/mysql/my_byteorder.h
  31. include/mysql/my_command.h
  32. include/mysql/my_compiler.h
  33. include/mysql/my_config.h
  34. include/mysql/my_dbug.h
  35. include/mysql/my_dir.h
  36. include/mysql/my_getopt.h
  37. include/mysql/my_global.h
  38. include/mysql/my_list.h
  39. include/mysql/mysql/client_authentication.h
  40. include/mysql/mysql/client_plugin.h
  41. include/mysql/mysql/client_plugin.h.pp
  42. include/mysql/mysql/com_data.h
  43. include/mysql/mysql_com.h
  44. include/mysql/mysql_com_server.h
  45. include/mysql/mysqld_ername.h
  46. include/mysql/mysqld_error.h
  47. include/mysql/mysql_embed.h
  48. include/mysql/mysql/get_password.h
  49. include/mysql/mysql/group_replication_priv.h
  50. include/mysql/mysql.h
  51. include/mysql/mysql/innodb_priv.h
  52. include/mysql/mysql/mysql_lex_string.h
  53. include/mysql/mysql/plugin_audit.h
  54. include/mysql/mysql/plugin_audit.h.pp
  55. include/mysql/mysql/plugin_auth_common.h
  56. include/mysql/mysql/plugin_auth.h
  57. include/mysql/mysql/plugin_auth.h.pp
  58. include/mysql/mysql/plugin_ftparser.h
  59. include/mysql/mysql/plugin_ftparser.h.pp
  60. include/mysql/mysql/plugin_group_replication.h
  61. include/mysql/mysql/plugin.h
  62. include/mysql/mysql/plugin_keyring.h
  63. include/mysql/mysql/plugin_keyring.h.pp
  64. include/mysql/mysql/plugin_trace.h
  65. include/mysql/mysql/plugin_validate_password.h
  66. include/mysql/mysql/psi/mysql_file.h
  67. include/mysql/mysql/psi/mysql_idle.h
  68. include/mysql/mysql/psi/mysql_mdl.h
  69. include/mysql/mysql/psi/mysql_memory.h
  70. include/mysql/mysql/psi/mysql_ps.h
  71. include/mysql/mysql/psi/mysql_socket.h
  72. include/mysql/mysql/psi/mysql_sp.h
  73. include/mysql/mysql/psi/mysql_stage.h
  74. include/mysql/mysql/psi/mysql_statement.h
  75. include/mysql/mysql/psi/mysql_table.h
  76. include/mysql/mysql/psi/mysql_thread.h
  77. include/mysql/mysql/psi/mysql_transaction.h
  78. include/mysql/mysql/psi/psi_base.h
  79. include/mysql/mysql/psi/psi.h
  80. include/mysql/mysql/psi/psi_memory.h
  81. include/mysql/mysql/service_command.h
  82. include/mysql/mysql/service_locking.h
  83. include/mysql/mysql/service_my_plugin_log.h
  84. include/mysql/mysql/service_my_snprintf.h
  85. include/mysql/mysql/service_mysql_alloc.h
  86. include/mysql/mysql/service_mysql_keyring.h
  87. include/mysql/mysql/service_mysql_password_policy.h
  88. include/mysql/mysql/service_mysql_string.h
  89. include/mysql/mysql/service_parser.h
  90. include/mysql/mysql/service_rpl_transaction_ctx.h
  91. include/mysql/mysql/service_rpl_transaction_write_set.h
  92. include/mysql/mysql/service_rules_table.h
  93. include/mysql/mysql/service_security_context.h
  94. include/mysql/mysql/services.h
  95. include/mysql/mysql/services.h.pp
  96. include/mysql/mysql/service_srv_session.h
  97. include/mysql/mysql/service_srv_session_info.h
  98. include/mysql/mysql/service_ssl_wrapper.h
  99. include/mysql/mysql/service_thd_alloc.h
  100. include/mysql/mysql/service_thd_engine_lock.h
  101. include/mysql/mysql/service_thd_wait.h
  102. include/mysql/mysql/service_thread_scheduler.h
  103. include/mysql/mysql/thread_pool_priv.h
  104. include/mysql/mysql/thread_type.h
  105. include/mysql/mysql_time.h
  106. include/mysql/mysql_version.h
  107. include/mysql/my_sys.h
  108. include/mysql/my_thread.h
  109. include/mysql/my_thread_local.h
  110. include/mysql/my_xml.h
  111. include/mysql/plugin_audit.h
  112. include/mysql/plugin_ftparser.h
  113. include/mysql/plugin_group_replication.h
  114. include/mysql/plugin.h
  115. include/mysql/plugin_keyring.h
  116. include/mysql/plugin_validate_password.h
  117. include/mysql/sql_common.h
  118. include/mysql/sql_state.h
  119. include/mysql/sslopt-case.h
  120. include/mysql/sslopt-longopts.h
  121. include/mysql/sslopt-vars.h
  122. include/mysql/thr_cond.h
  123. include/mysql/thr_mutex.h
  124. include/mysql/thr_rwlock.h
  125. include/mysql/typelib.h
  126. lib/mysql/libmysqlclient_r.a
  127. lib/mysql/libmysqlclient_r.so
  128. lib/mysql/libmysqlclient_r.so.20
  129. lib/mysql/libmysqlclient.so
  130. lib/mysql/libmysqlclient.so.20
  131. lib/mysql/libperconaserverclient.a
  132. lib/mysql/libperconaserverclient.so
  133. lib/mysql/libperconaserverclient.so.20
  134. lib/mysql/plugin/authentication_ldap_sasl_client.so
  135. libdata/pkgconfig/mysqlclient.pc
  136. libdata/pkgconfig/perconaserverclient.pc
  137. man/man1/comp_err.1.gz
  138. man/man1/mysql.1.gz
  139. man/man1/mysqladmin.1.gz
  140. man/man1/mysqlbinlog.1.gz
  141. man/man1/mysqlcheck.1.gz
  142. man/man1/mysql_config.1.gz
  143. man/man1/mysql_config_editor.1.gz
  144. man/man1/mysqldump.1.gz
  145. man/man1/mysqlimport.1.gz
  146. man/man1/mysqlshow.1.gz
  147. man/man1/mysqlslap.1.gz
  148. share/aclocal/mysql.m4
Collapse this list.
Dependency lines:
  • percona57-client>0:databases/percona57-client
Conflicts:
CONFLICTS_INSTALL:
  • mysql*-client-*
  • mariadb*-client-*
  • percona5[0-68-9]-client-*
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
To install the port: cd /usr/ports/databases/percona57-client/ && make install clean
To add the package: pkg install percona57-client
PKGNAME: percona57-client
Flavors: there is no flavor information for this port.
distinfo:
Packages:
percona57-client
ABIlatestquarterly
FreeBSD:11:aarch645.7.21.205.7.29.32
FreeBSD:11:amd645.7.29.325.7.29.32
FreeBSD:11:i3865.7.29.325.7.29.32
FreeBSD:12:aarch645.7.21.205.7.29.32
FreeBSD:12:amd645.7.29.325.7.29.32
FreeBSD:12:i3865.7.29.325.7.29.32
FreeBSD:13:aarch645.7.29.32-
FreeBSD:13:amd645.7.29.32-
FreeBSD:13:i3865.7.29.32-
 

Master port: databases/percona57-server

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. lber.h : net/openldap24-sasl-client
  2. bison : devel/bison
  3. cmake : devel/cmake
  4. perl5>=5.30.r1<5.31 : lang/perl5.30
Runtime dependencies:
  1. perl5>=5.30.r1<5.31 : lang/perl5.30
Library dependencies:
  1. libevent.so : devel/libevent
  2. liblz4.so : archivers/liblz4
  3. libzstd.so : archivers/zstd
  4. libsasl2.so : security/cyrus-sasl2
  5. libedit.so.0 : devel/libedit
This port is required by:
for Libraries
  1. databases/percona57-server

Configuration Options

USES:

Master Sites:
  1. There is no master site for this port.

Number of commits found: 17

NOTE: This slave port may no longer be vulnerable to issues shown below because the master port has been updated.

Commit History - (may be incomplete: see SVNWeb link above for full details)
This is a slave port. You may also want to view the commits to the master port: databases/percona57-server
DateByDescription
02 Jan 2020 05:44:14
Original commit files touched by this commit  5.7.28.31
Revision:521796 This port version is marked as vulnerable.
fluffy search for other commits by this committer
databases/percona57-*: Fix build for i386

Make build-script assume that FreeBSD's Clang doesn't
have "atomic_*" functions builtin implemented on i386

While here, allow to build on DragonFly BSD and
drop "-fabi-version=2" from C/CXX flags

Reported by:	pkg-fallout
MFH:		2020Q1
31 Dec 2019 04:42:42
Original commit files touched by this commit  5.7.28.31
Revision:521589 This port version is marked as vulnerable.
fluffy search for other commits by this committer
- Update Percona Server/Client to 5.7.28-31 release [1]

*    When using skip-innodb_doublewrite in my.cnf, a parallel doublewrite buffer
is still created. Bugs fixed #3411.
*    During a binlogging replication event, if the master crashes after
the multi-threaded slave has begun copying to the slave's relay log
and before the process has completed, a STOP SLAVE on the slave takes
longer than expected. Bug fixed #5824.
*    If pam_krb5 is configured to allow the user to change their password,
and the password expired, the server crashed after receiving the new password.
Bug fixed #6023.

- Provide LibreSSL support [2]
- Take maintainership. feld@ didn't pet the ports for almost two years,
all updates was committed with maintainer timeout

PR:		242649
Submitted by:	Igor Zabelin [1]. fluffy@ [2]
Approved by:	maintainer (feld@, timeout >2 weeks)
06 Dec 2019 16:00:36
Original commit files touched by this commit  5.7.27.30
Revision:519153 This port version is marked as vulnerable.
fluffy search for other commits by this committer
databases/percona57-{server,client} update to 5.7.27-30 release

percona57-client:
- Install compat pkgconfig symlink as well as it done for libs
(many packages still search for mysqlclient.pc only)

percona57-server:
- Proper use system lz4/zstd libs for rocksdb engine
- Declare system libevent to use instead of bundled one
- Stop pollute libdata/pkgconfig dir with unneeded .pc file
- Unbreak build with DEFAULT_VERSIONS+=ssl=libressl

PR:		239347
Submitted by:	fluffy [cleanups], Igor Zabelin [update]
Approved by:	maintainer (timeout, >3 months)
28 Sep 2019 06:45:26
Original commit files touched by this commit  5.7.26.29
Revision:513105 This port version is marked as vulnerable.
antoine search for other commits by this committer
Make the build dependency more accurate
28 Sep 2019 06:08:55
Original commit files touched by this commit  5.7.26.29
Revision:513102 This port version is marked as vulnerable.
antoine search for other commits by this committer
Revert r513041, it breaks the ports

Reported by:	pkg-fallout
Pointy hat:	bapt
27 Sep 2019 15:08:46
Original commit files touched by this commit  5.7.26.29
Revision:513041 This port version is marked as vulnerable.
bapt search for other commits by this committer
sasl.h header does not belong at all to openldap package
but to the cyrus-sasl2 package already listed in the dependency in the above
line.
Just remove the wrong dependency line
11 Jul 2019 18:14:35
Original commit files touched by this commit  5.7.26.29
Revision:506424 This port version is marked as vulnerable.
pi search for other commits by this committer
databases/percona57-{server,client}: upgrade 5.7.21-20 -> 5.7.26-29

- Fixes several CVEs, see
  https://vuxml.FreeBSD.org/freebsd/d3d02d3a-2242-11e9-b95c-b499baebfeaf.html
  for the list

PR:		236570
Submitted by:	Igor Zabelin <igorz@yandex.ru>
Approved by:	feld (maintainer timeout)
MFH:		2019Q3
04 Oct 2018 15:07:30
Original commit files touched by this commit  5.7.21.20
Revision:481225 This port version is marked as vulnerable.
feld search for other commits by this committer
databases/percona57-client: Fix build with ppc64

PR:		231758
MFH:		2018Q4
31 Mar 2018 18:26:51
Original commit files touched by this commit  5.7.21.20
Revision:466073 This port version is marked as vulnerable.
flo search for other commits by this committer
- update to 5.7.21-20
- fix build with clang 6.0

PR:		226504
Approved by:	maintainer timeout (3 weeks)
09 Mar 2018 22:46:22
Original commit files touched by this commit  5.7.20.18_1
Revision:464036 This port version is marked as vulnerable.
linimon search for other commits by this committer
Add more information to stub error messages.

Remove BROKEN lines where IGNORE has already been set.

While here, pet portlint.

Approved by:	portmgr (tier-2 blanket)
12 Jan 2018 17:53:30
Original commit files touched by this commit  5.7.20.18_1
Revision:458861 This port version is marked as vulnerable.
feld search for other commits by this committer
databases/percona57: Fix build with SASL

If SASL is detected at build time it assumes you want SASL and also
errors due to assuming we're Linux. This was already patched in our tree
for MySQL.

Also enable SASL support by default for the databases/percona57-client.
This is expected to be the default by upstream now.

Special thanks to mmokhi for figuring this out for us.

PR:		220865
MFH:		2018Q1
31 Dec 2017 15:28:55
Original commit files touched by this commit  5.7.20.18
Revision:457697 This port version is marked as vulnerable.
feld search for other commits by this committer
databases/percona57-{client,pam-for-mysql,server}: Update to 5.7.20-18

Release notes:
https://www.percona.com/doc/percona-server/5.7/release-notes/Percona-Server-5.7.20-18.html

MFH:		2017Q4
01 Apr 2017 15:11:15
Original commit files touched by this commit  5.7.16.10_3
Revision:437438 This port version is marked as vulnerable.
bapt search for other commits by this committer
Update libedit to 20170329
20 Feb 2017 02:57:04
Original commit files touched by this commit  5.7.16.10_2
Revision:434427 This port version is marked as vulnerable.
jbeich search for other commits by this committer
devel/libevent2: drop historical suffix after r362796

PR:		216777
Approved by:	mm (maintainer)
04 Feb 2017 07:56:59
Original commit files touched by this commit  5.7.16.10_1
Revision:433286 This port version is marked as vulnerable.
jbeich search for other commits by this committer
devel/libevent2: update to 2.1.8 and cleanup

- DEFAULT_VERSIONS += ssl=openssl-devel is now supported
- devel/py-event and devel/p5-Event-Lib are marked BROKEN

Changes:	https://github.com/libevent/libevent/raw/release-2.1.8-stable/whatsnew-2.1.txt
Changes:	https://github.com/libevent/libevent/raw/release-2.1.8-stable/ChangeLog
PR:		216527
Exp-run by:	antoine
Approved by:	mm (maintainer)
10 Jan 2017 23:46:51
Original commit files touched by this commit  5.7.16.10
Revision:431143 This port version is marked as vulnerable.
feld search for other commits by this committer
databases/percona57: Add PORTREVISION to slave ports
10 Jan 2017 18:54:33
Original commit files touched by this commit  5.7.16.10
Revision:431126 This port version is marked as vulnerable.
feld search for other commits by this committer
Welcome Percona 5.7 ports to the tree

- client and server version 5.7.16-10
- pam-for-mysql: compatible with newer MySQL API (MySQL 5.7+)

Thanks to all who have worked on Percona, MariaDB, and MySQL ports. Your
tireless efforts have been instrumental in making this port happen.

Differential Revision:	https://reviews.freebsd.org/D8785

Number of commits found: 17

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
chromiumMay 24
piwigoMay 23
drupal7May 22
tomcat-develMay 22
tomcat7May 22
tomcat85May 22
tomcat9May 22
unboundMay 22
zabbix3-proxyMay 20
zabbix3-serverMay 20
rubygem-actionpack52May 19
rubygem-actionpack60May 19
rubygem-actionview52May 19
rubygem-actionview60May 19
rubygem-activestorage52May 19

14 vulnerabilities affecting 165 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-05-25 19:05:09


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 39419
Broken 80
Deprecated 621
Ignore 370
Forbidden 5
Restricted 147
No CDROM 76
Vulnerable 24
Expired 15
Set to expire 576
Interactive 0
new 24 hours 4
new 48 hours9
new 7 days40
new fortnight86
new month249

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.