This also preserves log numbering because the new log with the next number is generated and only the preceding logs are removed. 000001.) Now mysqldump flushes the logs (which creates a new binary log number with the next sequence number), performs the dump, and then uses PURGE MASTER LOGS to remove the log files older than the new one. This also reset the binary log sequence numbering to. (The method for removing log files used RESET MASTER prior to the dump. *Incompatible Change: When mysqldump was run with the -delete-master-logs option, binary log files were deleted before it was known that the dump had succeeded, not after. In addition, CREATE TABLE LIKE was not isolated from alteration by other connections, which resulted in various errors and incorrect binary log order when trying to execute concurrently a CREATE TABLE LIKE statement and either DDL statements on the source table or DML or DDL statements on the target table. *Security Fix: CREATE TABLE LIKE did not require any privileges on the source table. *Security Fix: If a stored routine was declared using SQL SECURITY INVOKER, a user who invoked the routine could gain privileges. *Security Fix: The requirement of the DROP privilege for RENAME TABLE was not being enforced. *Security Fix: Use of a view could allow a user to gain update privileges for tables in other databases. Thanks for Dormando for reporting this bug and providing details and a proof of concept. *Security Fix: A malformed password packet in the connection protocol could cause the server to crash. *A new status variable, Com_call_procedure, indicates the number of calls to stored procedures. To mimic the old behavior use the CAST() function in the following way: SELECT date_field = CAST(NOW() as DATE). Now a DATE value is coerced to the DATETIME type by adding the time portion as 00:00:00. *Prior to this release, when DATE values were compared with DATETIME values the time portion of the DATETIME value was ignored. *Binaries for the Linux x86 statically linked tar.gz Community package were linked dynamically, not statically. For more information about SCI interconnects and these build scripts, see Section 16.9.1, Configuring MySQL Cluster to use SCI Sockets. *MySQL Cluster: The server source tree now includes scripts to simplify building MySQL with SCI support.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |