Abyss Web Server 1.16.4 and MySQL 5.7.39

Any comments, issues or suggestions regarding our website should be posted here.
Post Reply
huntor
PrimeTech Administrator
PrimeTech Administrator
Posts: 1293
Joined: Mon Sep 27, 2010 12:00 am

Abyss Web Server 1.16.4 and MySQL 5.7.39

Post by huntor »

Abyss Web Server 1.16.4 Updates

Updated the SSL/TLS engine;
Added fine tuning parameters to reverse proxy rules (Preserve "Host" header and connection timeout);
Added network interface listing in Bind IP parameters in the console;
Fixed a bug related to REQUEST_FILENAME CGI variable handling;
Updated the user's guide with documentation of the newly added features.

MySQL 5.7.39 Updates.

Changes in MySQL 5.7.39 (2022-07-26, General Availability)
Keyring Notes

Performance Schema Notes

Functionality Added or Changed

Bugs Fixed

Keyring Notes
The keyring_aws plugin has been updated to use the latest AWS Encryption SDK for C (version 1.9.186).

The keyring_aws_region variable supports the additional AWS regions supported by the new SDK. Refer to the variable description for a list of supported AWS regions.

Performance Schema Notes
The SHOW PROCESSLIST statement provides process information by collecting thread data from all active threads. However, because the implementation iterates across active threads from within the thread manager while holding a global mutex, it has negative performance consequences, particularly on busy systems.

An alternative SHOW PROCESSLIST implementation is now available based on the new Performance Schema process list table. This implementation queries active thread data from the Performance Schema rather than the thread manager and does not require a mutex:

To enable the alternative implementation, enable the performance_schema_show_processlist system variable.

Note
The processlist table is automatically created in the Performance Schema for new installations of MySQL 5.7.39, or higher. It is not created automatically by an upgrade. If you are upgrading from an earlier version of MySQL 5.7, and want to use the Performance Schema implementation of processlist, you must create the table manually.

See Creating the processlist table for more information.

The alternative implementation of SHOW PROCESSLIST also applies to the mysqladmin processlist command.

The alternative implementation does not apply to the INFORMATION_SCHEMA PROCESSLIST table or the COM_PROCESS_INFO command of the MySQL client/server protocol.

To ensure that the default and alternative implementations yield the same information, certain configuration requirements must be met; see The processlist Table.

Functionality Added or Changed
Important Change: The linked curl library for MySQL Server (Enterprise Edition) has been updated to version 7.83.1. (Bug #34138733)

Important Change: The linked OpenSSL library for MySQL Server has been updated to version 1.1.1o. Issues fixed in OpenSSL version 1.1.1o are described at https://www.openssl.org/news/cl111.txt and https://www.openssl.org/news/vulnerabilities.html. (Bug #34133985)

The myisam_repair_threads system variable and myisamchk --parallel-recover option were removed. (Bug #31052408)

Bugs Fixed
InnoDB: A 4GB tablespace file size limit on Widows 32-bit systems has been removed. The limit was due to an incorrect calculation performed while extending the tablespace. (Bug #28934351)

Replication: The write sets extracted by MySQL Replication from transactions when the transaction_write_set_extraction system variable is enabled (which is the default) are extracted from primary keys, unique keys, and foreign keys. They are used to detect dependencies and conflicts between transactions. Previously, write sets involving multi-column foreign keys were incorrectly identifying each column as a separate foreign key. The issue has now been fixed and foreign key write sets include all referenced key columns. (Bug #34095747, Bug #34144531)

Replication: When the --replicate-same-server-id option was used to make the replica not skip events that have its own server ID, if the log file was rotated, replication stopped with an error. The log rotation event now checks and applies the current value of the option. (Bug #89375, Bug #27492990)

Under certain circumstances TRUNCATE performance_schema.accounts caused duplicated counts in global_status.

This occurred only if the following was true:

If show_compatibility_56 is set to 0, aggregating status variables by accounts, users and hosts.

If some hosts were not instrumented. For example, if performance_schema_hosts_size was set to a low value.

Our thanks to Yuxiang Jiang and the Tencent team for the contribution. (Bug #34057013, Bug #106939)

Upgraded the bundled zlib library to zlib 1.2.12. Also made zlib 1.2.12 the minimum zlib version supported, and removed WITH_ZLIB from the WITH_SYSTEM_LIBS CMake option. (Bug #34015600)

If an incorrect value was set for the binlog_checksum system variable during a session, a COM_BINLOG_DUMP command made in the same session to request a binary log stream from a source failed. The server now validates the specified checksum value before starting the checksum algorithm setup process. (Bug #32442749)
Image
User avatar
Bubbachuk-PG-
Site Admin
Site Admin
Posts: 4915
Joined: Sun May 16, 2010 1:59 pm
Location: Marshville, North Carolina
Contact:

Re: Abyss Web Server 1.16.4 and MySQL 5.7.39

Post by Bubbachuk-PG- »

TYVM! :D
Image
Image

The democracy will cease to exist when you take away from those who
are willing to work and give to those who would not.
~ Thomas Jefferson

Website: http://pgsquad.com
Facebook: https://www.facebook.com/oliver.holmes.357
Post Reply