Port details on branch 2022Q2 |
- mysql80-server Multithreaded SQL database (server)
- 8.0.29 databases
=0 8.0.29Version of this port present on the latest quarterly branch. - Maintainer: joneum@FreeBSD.org
 - Port Added: 2022-05-03 17:15:05
- Last Update: 2022-05-03 17:25:24
- Commit Hash: 034b401
- License: GPLv2
- WWW:
- https://www.mysql.com/
- Description:
- MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server.
The new features in MySQL 8.0. In addition to Data Dictionnary and CTEs are:
Move to utf8(mb4) as MySQL's default character set
Language specific case insensitive collation for 21 languages (utf8)
Invisible index
Descending indexes
Improve usability of UUID and IPV6 manipulations
SQL roles - SET PERSIST for global variable values
Performance Schema, instrumenting data locks
Performance Schema, instrumenting error messages
Improved cost model with histograms
WWW: https://www.mysql.com/
¦ ¦ ¦ ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - USE_RC_SUBR (Service Scripts)
- no SUBR information found for this port
- Dependency lines:
-
- mysql80-server>0:databases/mysql80-server
- Conflicts:
- CONFLICTS_INSTALL:
- mysql*-server
- mysqlwsrep*-server
- mariadb*-server
- percona*-server
- To install the port:
- cd /usr/ports/databases/mysql80-server/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/mysql80-server
- pkg install mysql80-server
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: mysql80-server
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1651315615
SHA256 (mysql-boost-8.0.29.tar.gz) = fd34a84c65fc7b15609d55b1f5d128c4d5543a6b95fa638569c3277c5c7bb048
SIZE (mysql-boost-8.0.29.tar.gz) = 327770349
No package information for this port in our database- Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link:

- Slave ports:
-
- databases/mysql80-client
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- liblz4>0 : archivers/liblz4
- libunwind>0 : devel/libunwind
- bison : devel/bison
- cmake : devel/cmake
- pkgconf>=1.3.0_1 : devel/pkgconf
- Runtime dependencies:
-
- groff : textproc/groff
- perl5>=5.32.r0<5.33 : lang/perl5.32
- Library dependencies:
-
- libcurl.so : ftp/curl
- libevent.so : devel/libevent
- libicutu.so : devel/icu
- liblz4.so : archivers/liblz4
- libzstd.so : archivers/zstd
- libprotobuf.so : devel/protobuf
- libfido2.so : security/libfido2
- libhidapi.so : comms/hidapi
- libunwind.so : devel/libunwind
- libedit.so.0 : devel/libedit
- libmysqlclient.so.21 : databases/mysql80-client
- There are no ports dependent upon this port
Configuration Options:
- ===> The following configuration options are available for mysql80-server-8.0.29:
====> Permissible Storage Engines (to compile statically into the server)
ARCHIVE=off: Compile "Archive Storage" statically in server
BLACKHOLE=off: Compile "Blackhole Storage" statically in server
EXAMPLE=off: Compile "Example Storage" statically in server
FEDERATED=off: Compile "Federated Storage" statically in server
INNOBASE=off: Compile "InnoDB Storage" statically in server
PARTITION=off: Compile "Partitioning support Storage" statically in server
PERFSCHEMA=off: Compile "Performance Schema Storage" statically in server
====> Default features knobs
PERFSCHM=on: Enable "Performance Schema" by default (High RAM usage)
===> Use 'make config' to modify these settings
- Options name:
- databases_mysql80-server
- USES:
- bison:build cmake:noninja compiler:c++17-lang cpe groff:run libedit localbase ncurses perl5 pkgconfig shebangfix ssl mysql:80
- pkg-message:
- For install:
- There is no initial password for first time use of MySQL.
Keep in mind to reset it to a secure password.
MySQL80 has a default /usr/local/etc/mysql/my.cnf,
remember to replace it with your own
or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
- If upgrading
- As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously
handled by mysql_upgrade. Consequently, mysql_upgrade is unneeded and is
deprecated as of that version, and will be removed in a future MySQL version.
Because mysql_upgrade no longer performs upgrade tasks,
it exits with status 0 unconditionally.
- Master Sites:
|
Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
Commit | Credits | Log message |
8.0.29 03 May 2022 17:25:24
    |
Jochen Neumeister (joneum)  |
databases/mysql80-server: Mark als BROKEN on i386 after
10d211b655d85e31bf9b8e27d234f526cfd1e49b
cd
/wrkdirs/usr/ports/databases/mysql80-server/work/.build/plugin/x/protocol/plugin
&& /usr/local/bin/protoc
--plugin=protoc-gen-yplg=/wrkdirs/usr/ports/databases/mysql80-server/work/.build/runtime_output_directory/xprotocol_plugin
--yplg_out
/wrkdirs/usr/ports/databases/mysql80-server/work/.build/plugin/x/generated -I
/usr/local/include -I
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_connection.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_crud.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_cursor.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_datatypes.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_expect.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_expr.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_notice.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_prepare.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_resultset.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_session.proto
/wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.29/plugin/x/protocol/protobuf/mysqlx_sql.proto
--yplg_out: protoc-gen-yplg: Plugin killed by signal 11.
*** Error code 1
A solution is being worked on
Sponsored by: Netzkommune GmbH
(cherry picked from commit 4829ae8a5315088c812ce216ed7f14d56dcc9706) |
8.0.29 03 May 2022 17:13:38
    |
Jochen Neumeister (joneum)  |
databases/mysql80-{client, server}: Update to latest release 8.0.29
Bugs Fixed
InnoDB: A failure occurred when attempting to purge undo records for a table
with an instantly added column. (Bug #33924532)
InnoDB: High-priority transactions were not permitted to stop waiting when
interrupted or to timeout while waiting for a lock, preventing deadlocks from
being resolved. In cases where the blocking transaction is also high-priority,
high-priority transactions are now permitted to stop waiting when interrupted or
timeout when exceeding the lock wait timeout period. If a blocking transaction
is not high-priority, high-priority transactions wait for the blocking
transaction to release its locks. (Bug #33856332)
InnoDB: The AIO synchronization queue used on Windows was removed. The
synchronous file I/O read-write function (SyncFileIO::execute) was revised to
handle files opened for both normal and overlapped I/O, as it does on Linux.
(Bug #33840645)
InnoDB: Table version metadata was not reset after truncating all partitions
of a table with an instantly added column. (Bug #33822729)
InnoDB: The srv_error_monitor_thread() function, which prints warnings about
semaphore waits, failed to handle a long semaphore wait as expected. To address
this issue, a blocking call was moved to a more appropriate location. Related
monitor thread code was simplified and improved, and missing shutdown signals
were added for several server threads.
Enabling and disabling of the standard monitor by InnoDB is now performed
independently of the user-settable innodb_status_output variable. This change
addresses an issue in which the monitor was enabled by InnoDB in a particular
scenario but not set back to its previous value. Thanks to Yuhui Wang for the
contribution. (Bug #33789526, Bug #93878) (Only the first 15 lines of the commit message are shown above ) |