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 TABLES
command. - Added the
slow_launch_time
variable and theSlow_launch_threads
status variable tomysqld
. These can be examined withmysqladmin variables
andmysqladmin 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
myisamchk
could go into a loop when trying to repair a crashed table. - Don't write
INSERT DELAYED
to update log ifSQL_LOG_UPDATE=0
. - Fixed problem with
REPLACE
onHEAP
tables. - Added possible character sets and time zone to
SHOW VARIABLES
output. - Fixed bug in locking code that could result in locking problems with concurrent inserts under high load.
- Fixed a problem with
DELETE
of many rows on a table with compressed keys where MariaDB scanned the index to find the rows. - Fixed problem with
CHECK
on 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_INCREMENT
key. - Added
NULLIF()
function. - Fixed bug when using
LOAD DATA INFILE
on a table withBLOB/TEXT
columns. - Optimized
MyISAM
to 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 BY
parts where the part is a constant expression in theWHERE
part. Indexes can now be used even if theORDER BY
doesn't match the index exactly, as long as all the unused index parts and all the extraORDER BY
columns are constants in theWHERE
clause. Leia "Como o MariaDB Utiliza Índices". UPDATE
andDELETE
on a whole unique key in theWHERE
part are now faster than before.- Changed
RAID_CHUNKSIZE
to be in 1024-byte increments. - Fixed core dump in
LOAD_FILE(NULL)
.