Alterações na distribuição 3.23.15 (May 2000: Beta)
To start mysqld as root, you must now use the --user=root option.
- Added interface to Berkeley DB. (This is not yet functional; play with it at your own risk!)
- Replication between master and slaves.
- Fixed bug that other threads could steal a lock when a thread had a lock on a table and did a
FLUSH TABLEScommand. - Added the
slow_launch_timevariable and theSlow_launch_threadsstatus variable tomysqld. These can be examined withmysqladmin variablesandmysqladmin extended-status. - Added functions
INET_NTOA()andINET_ATON(). - The default type of
IF()now depends on the second and third arguments and not only on the second argument. - Fixed case when
myisamchkcould go into a loop when trying to repair a crashed table. - Don't write
INSERT DELAYEDto update log ifSQL_LOG_UPDATE=0. - Fixed problem with
REPLACEonHEAPtables. - Added possible character sets and time zone to
SHOW VARIABLESoutput. - Fixed bug in locking code that could result in locking problems with concurrent inserts under high load.
- Fixed a problem with
DELETEof many rows on a table with compressed keys where MariaDB scanned the index to find the rows. - Fixed problem with
CHECKon table with deleted keyblocks. - Fixed a bug in reconnect (at the client side) where it didn't free memory properly in some contexts.
- Fixed problems in update log when using
LAST_INSERT_ID()to update a table with anAUTO_INCREMENTkey. - Added
NULLIF()function. - Fixed bug when using
LOAD DATA INFILEon a table withBLOB/TEXTcolumns. - Optimized
MyISAMto be faster when inserting keys in sorted order. EXPLAIN SELECT ...now also prints out whether MariaDB needs to create a temporary table or use file sorting when resolving theSELECT.- Added optimization to skip
ORDER BYparts where the part is a constant expression in theWHEREpart. Indexes can now be used even if theORDER BYdoesn't match the index exactly, as long as all the unused index parts and all the extraORDER BYcolumns are constants in theWHEREclause. Leia "Como o MariaDB Utiliza Índices". UPDATEandDELETEon a whole unique key in theWHEREpart are now faster than before.- Changed
RAID_CHUNKSIZEto be in 1024-byte increments. - Fixed core dump in
LOAD_FILE(NULL).