./databases/mysql55-server, MySQL 5, a free SQL database (server)

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]

Branch: CURRENT, Version: 5.5.40, Package name: mysql-server-5.5.40, Maintainer: pkgsrc-users

MySQL 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

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).


Required to run:
[lang/perl5] [databases/mysql55-client]

Package options: embedded-server, ssl

Master sites: (Expand)

SHA1: b93a1b14ab2de390014e99b4293e7835da133196
RMD160: a0b6b9a390ba8a3abc889155d756656b28b98f70
Filesize: 21218.43 KB

Version history: (Expand)

CVS history: (Expand)

   2014-10-01 11:17:19 by Adam Ciarcinski | Files touched by this commit (4)
Log message:
Changes 5.5.40:
InnoDB: An ALTER TABLE ... ADD FOREIGN KEY operation could cause a serious error.
InnoDB: With a transaction isolation level less than or equal to READ COMMITTED, \ 
gap locks were not taken when scanning a unique secondary index to check for \ 
duplicates. As a result, duplicate check logic failed allowing duplicate key \ 
values in the unique secondary index.
InnoDB: During recovery, a segmentation fault would occur when marking a table \ 
as corrupt.
yaSSL client code did not validate the encryption size or session ID length, \ 
which could cause the client to exit.
MySQL installation from RPM packages could fail if Postfix had been installed \ 
using yum.
yaSSL could fail preauthorization if the client supplied inaccurate buffer lengths.
Competition between threads could lead to timeout failure trying to rotate the \ 
audit log file.
On Linux (OEL6), if Sun DTrace was installed, the MySQL build failed.
LPAD() and RPAD() could cause a server exit if the pad string argument was not \ 
well formed.
The optimizer could create a zero-length column for a temporary table, causing a \ 
server exit.
   2014-08-10 16:27:40 by Adam Ciarcinski | Files touched by this commit (4) | Package updated
Log message:
Changes 5.5.39:

CMake support was updated to handle CMake version 3.

The timed_mutexes system variable has no effect and is deprecated.

Bugs Fixed

InnoDB: Opening a parent table that has thousands of child tables could result \ 
in a long semaphore wait condition.

Partitioning: Selecting from a table having multiple columns in its primary key \ 
and partitioned by LIST COLUMNS(R), where R was the last (rightmost) column \ 
listed in the primary key definition, returned an incorrect result.

Replication: When using row-based replication, updating or deleting a row on the \ 
master that did not exist on the slave led to failure of the slave when it tried \ 
to process the change. This problem occurred with InnoDB tables lacking a \ 
primary key.

Replication: Quotation marks were not always handled correctly by LOAD DATA \ 
INFILE when written into the binary log.

Replication: A group of threads involved in acquiring locks could deadlock when \ 
the following events occurred:

Dump thread reconnects from slave; on master, a new dump thread tries to kill \ 
zombie dump threads; having acquired the thread's LOCK_thd_data, it is about to \ 
acquire LOCK_log.

Application thread executing show binary logs, having acquired LOCK_log and \ 
about to acquire LOCK_index.

Application thread executing PURGE BINARY LOGS; having acquired LOCK_index, it \ 
is about to acquire LOCK_thread_count.

Application thread executing SHOW PROCESSLIST (or SELECT * FROM \ 
INFORMATION_SCHEMA.PROCESSLIST), having acquired LOCK_thread_count and about to \ 
acquire the zombie dump thread's LOCK_thd_data.
   2014-07-16 10:56:59 by Filip Hajny | Files touched by this commit (2)
Log message:
The postinstall-solaris script is still being installed on SunOS.
   2014-06-14 12:21:52 by Sebastian Wiedenroth | Files touched by this commit (1)
Log message:
fix SMF Manifest installation by not overwriting INSTALLATION_DIRS
   2014-06-02 09:17:31 by Adam Ciarcinski | Files touched by this commit (4)
Log message:
Changes 5.5.38:

Bugs Fixed

InnoDB: For each insert, memset would be called three times to allocate memory \ 
for system fields. To reduce CPU usage, the three memset calls are now combined \ 
into a single call.

Replication: When used on a table employing a transactional storage engine, a \ 
failed TRUNCATE TABLE was still written to the binary log and thus replayed on \ 
the slave. This could lead to inconsistency when the master retained data that \ 
was removed on the slave.

Now in such cases TRUNCATE TABLE is logged only when it executes successfully.

Certain INFORMATION_SCHEMA queries could cause a server exit.

For indexes on prefixes or character string columns, index corruption could \ 
occur for assignment of binary data to the column due to improper character \ 

Solaris-specific scripts were included in and installed by non-Solaris packages.

EXPLAIN on a query with an EXISTS subquery containing a UNION could cause a \ 
server exit. Multiple executions of a prepared EXPLAIN on a UNION of subqueries \ 
could cause a server exit.

Executing a correlated subquery on an ARCHIVE table which has an AUTO_INCREMENT \ 
column caused the server to hang.

The client library could cause clients to exit due to incorrectly mapping the \ 
client error number to the corresponding message, if reallocation of packet \ 
buffer memory occurred.

Calling mysql_get_server_version() with an invalid connection handler argument \ 
caused the client to exit. Now it returns 0 and reports a \ 

On Windows, calling mysql_thread_init() call without mysql_init() caused the \ 
client to exit. windows. Now it returns a nonzero result because it is an error \ 
to call mysql_thread_init() before the client library is initialized with \ 

CMake produced not-useful warnings about INTERFACE_LINK_LIBRARIES policy.

LOAD DATA LOCAL INFILE could use all CPU if import errors occurred when there \ 
were no line delimiters.

A statement of the following form broke row-based replication because it created \ 
a table having a field of data type BIGINT with a display width of 3000, which \ 
is beyond the maximum acceptable value of 255:

   2014-04-14 02:02:50 by Blue Rats | Files touched by this commit (9)
Log message:
Don't hardcode PID file. Instead, give the user the option to set it. The
rc.d script overrides my.cnf directives. Hardcoding the PID can cause a
problem on systems transitioning to MySQL packages from pkgsrc.
   2014-03-31 10:03:23 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
Changes 5.5.37:

Functionality Added or Changed

On Solaris, mysql_config --libs now includes -R/path/to/library so that \ 
libraries can be found at runtime.

Bugs Fixed

InnoDB: A regression introduced by Bug 14329288 would result in a performance \ 
degradation when a compressed table does not fit into memory.

InnoDB: The maximum value for innodb_thread_sleep_delay is now 1000000 \ 
microseconds. The previous maximum value (4294967295 microseconds on 32-bit and \ 
18446744073709551615 microseconds on 64-bit) was unnecessarily large. Because \ 
the maximum value of innodb_thread_sleep_delay is limited by the value set for \ 
innodb_adaptive_max_sleep_delay (when set to a non-zero value), the maximum \ 
value for innodb_thread_sleep_delay is now the same as the maximum value for \ 

InnoDB: In debug builds, creating a unique index on a binary column, with input \ 
data containing duplicate keys, would cause an assertion.

InnoDB: InnoDB would fail to start when innodb_data_file_path specified the data \ 
file size in kilobytes by appending K to the size value.

InnoDB: An insert buffer merge would cause an assertion error due to incorrectly \ 
handled ownership information for externally stored BLOBs.

InnoDB: Assertion failure in thread thread_num in file ibuf0ibuf.cc line 4080
InnoDB: Failing assertion: rec_get_deleted_flag(rec, page_is_comp(page))

InnoDB: Decreasing the auto_increment_increment value would have no affect on \ 
the next auto-increment value.

Replication: The server did not handle correctly the insertion of a row larger \ 
than 4 GB when using row-based replication.

Replication: When using row-based replication, an additional auto-increment \ 
column on the slave version of a table was not updated correctly; a zero was \ 
inserted instead.

Replication: Statements involving the Performance Schema tables should not be \ 
written to the binary log, because the content of these tables is applicable \ 
only to a given MySQL Server instance, and may differ greatly between different \ 
servers in a replication topology. The database administrator should be able to \ 
configure (INSERT, UPDATE, or DELETE) or flush (TRUNCATE TABLE) performance \ 
schema tables on a single server without affecting others. However, when \ 
replicating from a MySQL 5.5 master to a MySQL 5.5 or later slave, warnings \ 
about unsafe statements updating Performance Schema tables were elevated to \ 
errors. For MySQL 5.6 and later slaves, this prevented the simultaneous use of \ 
performance_schema and GTIDs (see Replication with Global Transaction \ 
Identifiers, in the MySQL 5.6 Manual).

This fix causes all updates on tables in the performance_schema database to be \ 
filtered on the master and not replicated, regardless of the type of logging \ 
that is in effect. Prior to this fix, statements using were handled by being \ 
marked as unsafe for replication, which caused warnings during execution; the \ 
statements were nonetheless written to the binary log, regardless of the logging \ 
format in effect.

Existing replication behavior for tables in the INFORMATION_SCHEMA database is \ 
not changed by this fix.

For more information, see MySQL Performance Schema.

Compilation failed if MySQL was configured with CFLAGS set to include a -Werror \ 
option with an argument.

A shared libmysqld embedded server library was not built on Linux.

While printing the server version, the mysql client did not check for buffer \ 
overflow in a string variable.

Contraction information in a collation could be mishandled, resulting in \ 
incorrect decisions about whether a character is part of a contraction, and \ 
miscalculation of contraction weights.

DROP TRIGGER succeeded even with the read_only system variable enabled.

Updating the Performance Schema setup_instruments table on a replication master \ 
caused a slave to exit.

Due to a race condition, it was possible for two threads to end up with the same \ 
query ID for different queries.

When run by root, mysqld --help --verbose exited with a nonzero error code after \ 
displaying the help message.

MySQL client programs from a Community Edition distribution could not connect \ 
using SSL to a MySQL server from an Enterprise Edition. This was due to a \ 
difference in certificate handling by yaSSL and OpenSSL (used for Community and \ 
Enterprise, respectively). OpenSSL expected a blank certificate to be sent when \ 
not all of the --ssl-ca, --ssl-cert, and --ssl-key options were specified, and \ 
yaSSL did not do so. To resolve this, yaSSL has been modified to send a blank \ 
certificate when an option is missing.

A deadlock error occurring during subquery execution could cause an assertion to \ 
be raised.

The Performance Schema stage/sql/Waiting to get readlock instrument is no longer \ 
used and has been removed.

For system variables that take a string value, SET statements permitted an \ 
unquoted value, but values that contained dots were parsed incorrectly and only \ 
part of the value was assigned. For example, SET GLOBAL slow_query_log_file = \ 
my_slow.log assigned the value my_slow. Now such values must be quoted or an \ 
error occurs.

On Windows, mysql_install_db.pl could be run only from within the bin directory \ 
under the installation directory.
   2014-03-25 13:05:57 by Jonathan Perkin | Files touched by this commit (3)
Log message:
Fix SMF_METHOD_FILE expansion.