Path to this page:
NOTICE: This package has been removed from pkgsrc./
databases/mysql55-server,
MySQL 5, a free SQL database (server)
Branch: CURRENT,
Version: 5.5.62nb3,
Package name: mysql-server-5.5.62nb3,
Maintainer: pkgsrc-usersMySQL is a SQL (Structured Query Language) database server. SQL is the most
popular database language in the world. MySQL is a client-server implementation
that consists of a server daemon `mysqld' and many different client
programs/libraries.
The main goals of MySQL are speed and robustness.
The base upon which MySQL is built is a set of routines that have been used in
a highly demanding production environment for many years. While MySQL is still
in development it already offers a rich and highly useful function set.
The official way to pronounce 'MySQL' is 'My Ess Que Ell' (Not MY-SEQUEL).
This package contains the MySQL server programs and libraries including
embedded server (by PKG_OPTION).
DEINSTALL [+/-]# $NetBSD: DEINSTALL,v 1.1.1.1 2011/04/25 21:12:13 adam Exp $
case ${STAGE} in
POST-DEINSTALL)
if [ -d @MYSQL_DATADIR@ ]; then
${CAT} << EOF
===========================================================================
If you won't be using ${PKGNAME} any longer, and you don't
wish to preserve your existing databases, then you may remove the
following directory:
@MYSQL_DATADIR@
===========================================================================
EOF
fi
esac
MESSAGE.sphinx [+/-]===========================================================================
$NetBSD: MESSAGE.sphinx,v 1.1 2014/10/17 17:07:44 fhajny Exp $
To install the SphinxSE MySQL plugin, log into your MySQL console
and issue the following query:
INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';
You can verify it has been loaded properly by checking whether
it shows up in the list when list your engines:
SHOW ENGINES;
===========================================================================
Required to run:[
lang/perl5] [
security/openssl] [
databases/mysql55-client]
Required to build:[
pkgtools/cwrappers]
Package options: embedded-server
Master sites: (Expand)
SHA1: b3df3c8c50b8655878cfbc288537f44715f6b060
RMD160: 4b6fdfc37dc87fdabb2b944b695d5b9e687e22f2
Filesize: 20617.092 KB
Version history: (Expand)
- (2020-05-24) Package deleted from pkgsrc
- (2020-01-19) Updated to version: mysql-server-5.5.62nb3
- (2019-08-11) Updated to version: mysql-server-5.5.62nb2
- (2019-04-30) Updated to version: mysql-server-5.5.62nb1
- (2018-11-22) Updated to version: mysql-server-5.5.62
- (2018-08-22) Updated to version: mysql-server-5.5.59nb1
CVS history: (Expand)
2020-05-23 09:25:10 by Adam Ciarcinski | Files touched by this commit (117) | |
Log message:
Retired mysql55 and postgresql94 packages
|
2020-01-18 22:51:16 by Jonathan Perkin | Files touched by this commit (1836) |
Log message:
*: Recursive revision bump for openssl 1.1.1.
|
2019-08-11 15:25:21 by Thomas Klausner | Files touched by this commit (3557) |
Log message:
Bump PKGREVISIONs for perl 5.30.0
|
2019-04-30 19:20:23 by David Brownlee | Files touched by this commit (8) |
Log message:
Bump PKGREVISION for addition of USE_GCC_RUNTIME
|
2018-11-22 12:27:12 by Adam Ciarcinski | Files touched by this commit (6) | |
Log message:
mysql55: updated to 5.5.62
Changes in MySQL 5.5.62
Functionality Added or Changed
* Previously, file I/O performed in the I/O cache in the mysys library was not \
instrumented, affecting in particular file I/O statistics reported by the \
Performance Schema about the binary log index file. Now, this I/O is \
instrumented and Performance Schema statistics are accurate. Thanks to Yura \
Sorokin for the contribution.
* The zlib library version bundled with MySQL was raised from version 1.2.3 to \
version 1.2.11. MySQL implements compression with the help of the zlib library.
* The zlib compressBound() function in zlib 1.2.11 returns a slightly higher \
estimate of the buffer size required to compress a given length of bytes than it \
did in zlib version 1.2.3. The compressBound() function is called by InnoDB \
functions that determine the maximum row size permitted when creating compressed \
InnoDB tables or inserting rows into compressed InnoDB tables. As a result, \
CREATE TABLE ... ROW_FORMAT=COMPRESSED or INSERT operations with row sizes very \
close to the maximum row size that were successful in earlier releases could now \
fail.
Bugs Fixed
* MySQL Server and test RPM packages were missing perl-Data-Dumper as a dependency.
* For the mysql client, the -b short option was associated with two long \
options, --no-beep and --binary-as-hex. The -b option now is associated only \
with --no-beep.
* During server startup/shutdown, PID files could be mishandled.
* For MEMORY tables, memory overflow errors could occur.
* When converting from a BLOB (or TEXT) type to a smaller BLOB (or TEXT) type, \
no warning or error was reported informing about the truncation or data loss. \
Now an appropriate error is issued in strict SQL mode and a warning in nonstrict \
SQL mode.
* ALTER TABLE ... REORGANIZE PARTITION ... could result in incorrect behavior if \
any partition other than the last was missing the VALUES LESS THAN part of the \
syntax.
|
2018-08-22 11:48:07 by Thomas Klausner | Files touched by this commit (3558) |
Log message:
Recursive bump for perl5-5.28.0
|
2017-07-19 20:48:22 by Adam Ciarcinski | Files touched by this commit (10) | |
Log message:
Security Notes
* Security Fix: The linked OpenSSL library for the MySQL Commercial Server has \
been updated to version 1.0.2l. Issues fixed in the new OpenSSL version are \
described at http://www.openssl.org/news/vulnerabilities.html.
This change does not affect the Oracle-produced MySQL Community build of MySQL \
Server, which uses the yaSSL library instead.
Platform-Specific Notes
* Linux: The generic Linux build for MySQL 5.6 is now built on Oracle Linux 6 \
using glibc 2.12. Systems that use the build need to have glibc 2.12 or later \
installed on them.
Functionality Added or Changed
* For Windows, MSI installer packages now include a check for the required \
Visual Studio redistributable package, and produce a message asking the user to \
install it if it is missing.
* The mysql client now supports a --binary-as-hex option that causes display of \
binary data using hexadecimal notation (0xvalue). Thanks to Daniël van Eeden \
for the patch.
* mysqlaccess now looks for its configuration file only in the SYSCONFDIR \
directory and /etc.
Bugs Fixed
* InnoDB: The server allocated memory unnecessarily for an operation that \
rebuilt the table.
* InnoDB: When using an index merge optimizer switch, a SELECT COUNT(*) \
operation sometimes returned 0. Partitioning code incorrectly performed a memcpy \
instead of a column copy of columns read by the index, causing the wrong records \
to be copied.
* Replication: A USE statement that followed a SET GTID_NEXT statement sometimes \
had no effect.
* Replication: If the binary log on a master server was rotated and a full disk \
condition occurred on the partition where the binary log file was being stored, \
the server could stop unexpectedly. The fix adds a check for the existence of \
the binary log when the dump thread switches to next binary log file. If the \
binary log is disabled, all binary logs up to the current active log are \
transmitted to slave and an error is returned to the receiver thread.
* Replication: If a relay log index file named relay log files that did not \
exist, RESET SLAVE ALL sometimes did not fully clean up properly.
* Replication: mysqlbinlog, if invoked with the --raw option, does not flush the \
output file until the process terminates. But if also invoked with the \
--stop-never option, the process never terminates, thus nothing is ever written \
to the output file. Now the output is flushed after each event.
* Replication: A memory leak in mysqlbinlog was fixed. The leak happened when \
processing fake rotate events, or when using --raw and the destination log file \
could not be created. The leak only occurred when processing events from a \
remote server. Thanks to Laurynas Biveinis for his contribution to fixing this \
bug.
* Replication: Multi-threaded slaves could not be configured with small queue \
sizes using slave_pending_jobs_size_max if they ever needed to process \
transactions larger than that size. Any packet larger than \
slave_pending_jobs_size_max was rejected with the error \
ER_MTS_EVENT_BIGGER_PENDING_JOBS_SIZE_MAX, even if the packet was smaller than \
the limit set by slave_max_allowed_packet.
* With this fix, slave_pending_jobs_size_max becomes a soft limit rather than a \
hard limit. If the size of a packet exceeds slave_pending_jobs_size_max but is \
less than slave_max_allowed_packet, the transaction is held until all the slave \
workers have empty queues, and then processed. All subsequent transactions are \
held until the large transaction has been completed. The queue size for slave \
workers can therefore be limited while still allowing occasional larger \
transactions.
* mysqldump could write database names in USE statements incorrectly.
* If the mysql_stmt_close() C API function was called, it freed memory that \
later could be accessed if mysql_stmt_error(), mysql_stmt_errno(), or \
mysql_stmt_sqlstate() was called. To obtain error information after a call to \
mysql_stmt_close(), call mysql_error(), mysql_errno(), or mysql_sqlstate() \
instead.
* Queries could be cached incorrectly, leading to incorrect query results, under \
these circumstances: InnoDB table; rows are being inserted but have not yet been \
committed; a query uses the table as a base table in a derived table; the \
optimizer chooses to materialize the derived table.
* Man pages for a few utilities were missing from Debian/Ubuntu packages.
* The field-t unit test failed to run with AddressSanitizer enabled. Thanks to \
Laurynas Biveinis for the patch.
* Debian client packages were missing information about conflicts with native \
packages.
* The Perl path in #! lines at the beginning of Perl scripts has been adjusted \
to /usr/local/bin/perl for FreeBSD 11.
* The server exited abnormally attempting to access invalid memory.
* A race condition could occur for CREATE TABLE statements with DATA DIRECTORY \
or INDEX DIRECTORY clauses.
* MySQL compilation in different directories produced different builds to \
leakage of absolute paths into debug information and __FILE__.
* mysqld_failed to start the server if the --datadir option was specified with a \
relative path name.
* With read_only enabled, creation of non-TEMPORARY tables by non-SUPER users \
was permitted under certain conditions.
*Certain stored functions, if used in a query WHERE clause, could be handled \
using Index Condition Pushdown (which should not happen), resulting in a server \
exit.
* On x86 machines, the uint3korr() macro read 4 bytes of data instead of the \
intended 3 bytes.
* An assertion was raised during a fetch operation by the memcached plugin.
* Queries that contained UNION in a subquery and GROUP BY could return incorrect \
results.
* LOAD XML INFILE performance became noticeably slower when the XML file being \
read contained a great many spaces, such as those introduced by indenting or \
pretty-printing. Now all leading whitespace is trimmed from each such value \
before reading it into memory.
|
2017-06-24 17:18:43 by Amitai Schleier | Files touched by this commit (8) |
Log message:
Disassociate from controlling terminal (using Perl, already a
dependency) and run the logger as ${mysqld_user}, not root.
Bump PKGREVISIONs.
|