CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Tue Oct  1 10:26:39 UTC 2013

Modified Files:
        pkgsrc/databases/mysql56-client: Makefile Makefile.common distinfo
        pkgsrc/databases/mysql56-client/patches: patch-sql_transaction.cc
        pkgsrc/databases/mysql56-server: PLIST

Log Message:
Changes 5.6.14:
* MySQL 5.7 changed audit log file output to a new format that has better 
compatibility with Oracle Audit Vault. This format has been backported to MySQL 
5.6 and it is possible to select either the old or new format using the new 
audit_log_format system variable, which has permitted values of OLD and NEW 
(default OLD). For details about each format, see The Audit Log File.
* Important Change; Replication: START SLAVE UNTIL SQL_AFTER_GTIDS did not 
cause the slave to stop until the next GTID event was received following 
execution of the transaction having the indicated GTID, which could cause 
issues in the case when the next GTID event is delayed, or does not exist. Now 
the slave stops after completing the transaction with that GTID.
* InnoDB; Partitioning: Following any query on the 
INFORMATION_SCHEMA.PARTITIONS table, InnoDB index statistics as shown in the 
output of statements such as SELECT * FROM INFORMATION_SCHEMA.STATISTICS were 
read from the last partition, instead of from the partition containing the 
greatest number of rows.
* InnoDB: When logging the delete-marking of a record during online ALTER 
TABLE...ADD PRIMARY KEY, InnoDB writes the transaction ID to the log as it was 
before the deletion or delete-marking of the record. When doing this, InnoDB 
would overwrite the DB_TRX_ID field in the original table, which could result 
in locking issues.
* InnoDB: The row_sel_sec_rec_is_for_clust_rec function would incorrectly 
prepare to compare a NULL column prefix in a secondary index with a non-NULL 
column in a clustered index.
* InnoDB: An incorrect purge would occur when rolling back an update to a 
delete-marked record.
* InnoDB: An assertion would be raised in fil_node_open_file due to a missing 
.ibd file. Instead of asserting, InnoDB should return false and the caller of 
fil_node_open_file should handle the return message.
* InnoDB: The assertion ut_ad(oldest_lsn <= cur_lsn) in file buf0flu.cc would 
fail because the current max LSN would be retrieved from the buffer pool before 
the oldest LSN.
* InnoDB: InnoDB memcached add and set operations would perform more slowly 
than SQL INSERT operations.
* InnoDB: The InnoDB memcached plugin could be initialized to insert into an 
InnoDB table with an INTEGER primary key.
More...


To generate a diff of this commit:
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/mysql56-client/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/mysql56-client/Makefile.common \
    pkgsrc/databases/mysql56-client/distinfo
cvs rdiff -u -r1.1 -r1.2 \
    pkgsrc/databases/mysql56-client/patches/patch-sql_transaction.cc
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/mysql56-server/PLIST

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.