Software-update: MySQL 5.0.84

MySQL is een krachtig opensource relational database management system, dat met name populair is als website- en forumdatabase. Ook Tweakers.net maakt gebruik van MySQL om onder andere gebruikersgegevens, statistieken en de diverse review-, meuk- en nieuwsartikelen op te slaan. De ontwikkelaars hebben alweer even geleden een nieuwe versie in de 5.0-tak uitgebracht, namelijk 5.0.84 in zowel een MySQL Community Server als een MySQL Enterprise smaak. Voor een overzicht van de verschillen tussen deze twee verwijzen we jullie door naar dit overzicht. De bijbehorende aankondiging van deze uitgaves ziet er als volgt uit:

Changes in MySQL 5.0.84:

This section documents all changes and bugfixes that have been applied since the last MySQL Enterprise Server and MySQL Community Server release (5.0.83). If you would like to receive more fine-grained and personalized update alerts about fixes that are relevant to the version and features you use, please consider subscribing to MySQL Enterprise (a commercial MySQL offering). For more details please see http://www.mysql.com/products/enterprise/advisors.html.

Bugs fixed:

• Performance: The InnoDB adaptive hash latch is released (if held) for serveral potentially long-running operations. This improves throughput for other queries if the current query is removing a temporary table, changing a temporary table from memory to disk, using CREATE TABLE ... SELECT, or performing a MyISAM repair on a table used within a transaction. (Bug#32149)
• Important Change: Replication: BEGIN, COMMIT, and ROLLBACK statements are no longer affected by --replicate-do-db or --replicate-ignore-db rules. (Bug#43263)
• Replication: When reading a binary log that was in use by a master or that had not been properly closed (possibly due to a crash), the following message was printed: Warning: this binlog was not closed properly. Most probably mysqld crashed writing it. This message did not take into account the possibility that the file was merely in use by the master, which caused some users concern who were not aware that this could happen. To make this clear, the original message has been replaced with Warning: this binlog is either is use or was not closed properly. (Bug#34687)
• The server crashed for attempts to use REPLACE or INSERT ... ON DUPLICATE KEY UPDATE with a view defined using a join. (Bug#45806)
• The combination of MIN() or MAX() in the select list with WHERE and GROUP BY clauses could lead to incorrect results. (Bug#45386)
• The mysql client could misinterpret some character sequences as commands under some circumstances. (Bug#45236)
• Use of ROUND() on a LONGTEXT or LONGBLOB column of a derived table could cause a server crash. (Bug#45152)
• Index Merge followed by a filesort could result in a server crash if sort_buffer_size was not large enough for all sort keys. (Bug#44810) See also Bug#40974.
• The PASSWORD() and OLD_PASSWORD() functions could read memory outside of an internal buffer when used with BLOB arguments. (Bug#44767)
• A workaround for a Sun Studio bug was instituted. (Bug#41710)
• Shared-memory connections did not work in Vista if mysqld was started from the command line. (Bug#41190)
• Valgrind warnings that occurred for SHOW TABLE STATUS with InnoDB tables were silenced. (Bug#38479)
• In the mysql client, using a default character set of binary caused internal commands such as DELIMITER to become case sensitive. (Bug#37268)
• When invoked to start multiple server instances, mysqld_multi sometimes would fail to start them all due to not changing location into the base directory for each instance. (Bug#36654)
• On Windows, the _PC macro in my_global.h was causing problems for modern compilers. It has been removed because it is no longer used. (Bug#34309)
• Setting the session value of the max_allowed_packet or net_buffer_length system variable was allowed but had no effect. The session value of these variables is now read only. (Bug#32223) See also Bug#22891.

Versienummer	5.0.84
Releasestatus	Final
Besturingssystemen	Linux, BSD, Windows XP, macOS, Solaris, UNIX, Windows Server 2003, Windows XP x64, Windows Server 2003 x64, Windows Vista, Windows Vista x64, Windows Server 2008
Website	MySQL
Download	http://dev.mysql.com/downloads/mysql/5.0.html
Licentietype	Voorwaarden (GNU/BSD/etc.)

Reacties (3)

[HoeZoWie]

Oracle heeft Sun (op)gekocht (binnenkort).
Oracle heeft al een DB-Express versie van de Relationele Oracle Database.
Zou dit dan de laatste officiële Release/Versie zijn van MySQL ???

[Reactie gewijzigd door HoeZoWie op 25 juli 2024 07:58]

[Jory]

Vanuit zowel Oracle als Sun is gezegd dat MySQL doorontwikkeld zal blijven worden. Wat de rol van MySQL precies zal worden is nog niet bekend, maar de ontwikkeling zal in ieder geval doorgaan.

En mocht Oracle de ontwikkeling toch stopzetten dan is dat nog niet zo'n probleem; iedereen mag MySQL forken en zelf doorgaan. Een deel van de originele ontwikkelaars van MySQL is zelfs met zoiets bezig, zie http://askmonty.org/wiki/index.php/Main_Page

Een vergelijkbaar project is Drizzle (http://en.wikipedia.org/wiki/Drizzle_%28database_server%29), hoewel de doelstellingen daar wel anders zijn.

[hbokh]

Ik vind eigenlijk de aankondiging een beetje aan de late kant.
Die van mij draait alweer "4 days, 9 hrs, 34 mins & 44 secs" en dan komt 'ie zelfs uit de ports-tree van FreeBSD... En met de portupgrade had ik meer dan 24 uur gewacht.

[Reactie gewijzigd door hbokh op 25 juli 2024 07:58]