Cookies op Tweakers

Tweakers maakt gebruik van cookies, onder andere om de website te analyseren, het gebruiksgemak te vergroten en advertenties te tonen. Door gebruik te maken van deze website, of door op 'Ga verder' te klikken, geef je toestemming voor het gebruik van cookies. Wil je meer informatie over cookies en hoe ze worden gebruikt, bekijk dan ons cookiebeleid.

Meer informatie

Door , , 5 reacties
Bron: MySQL, submitter: ViVa

MySQL brengt in rap tempo nieuwe updates van haar populaire database-server uit. MySQL is ontworpen om simpel, snel en betrouwbaar te zijn. Hierdoor hebben echter een aantal ingewikkelde commando's geen plaatsje kunnen vinden in de nog steeds groeiende lijst van door MySQL ondersteunde SQL-instructies's. De nieuwste versie van MySQL is 4.0.9 welke reeds vijf dagen over het web vliegt. Dit is wat er veranderd is in deze release:

Functionality added or changed:
  • OPTIMIZE TABLE will for MyISAM tables treat all NULL values as different when calculating cardinality. This helps in optimising joins between tables where one of the tables has a lot of NULL values in a indexed column: SELECT * from t1,t2 where t1.a=t2.key_with_a_lot_of_null;
  • Added join operator FORCE INDEX (key_list). This acts likes USE INDEX (key_list) but with the addition that a table scan is assumed to be VERY expensive. One bad thing with this is that it makes FORCE a reserved word.
  • Reset internal row buffer in MyISAM after each query. This will reduce memory in the case you have a lot of big blobs in a table.
Bugs fixed:
  • A security patch in 4.0.8 causes the mysqld server to die if the remote hostname can't be resolved. This is now fixed.
  • Fixed crash when replication big LOAD DATA INFILE statement that caused log rotation.
MySQL/InnoDB-4.0.9, January 14, 2003
  • Removed the warning message: 'InnoDB: Out of memory in additional memory pool.'
  • Fixed a bug: if the combined size of InnoDB log files was >= 2 GB in a 32-bit computer, InnoDB would write log in a wrong position. That could make crash recovery and InnoDB Hot Backup to fail.
  • Fixed a bug: index cursor restoration could theoretically fail.
MySQL/InnoDB-4.0.8, January 7, 2003
  • InnoDB now supports also FOREIGN KEY (...) REFERENCES ...(...) [ON UPDATE CASCADE | ON UPDATE SET NULL | ON UPDATE RESTRICT | ON UPDATE NO ACTION].
  • Tables and indexes now reserve 4 % less space in the tablespace. Also existing tables reserve less space. By upgrading to 4.0.8 you will see more free space in "InnoDB free" in SHOW TABLE STATUS.
  • Fixed bugs: updating the PRIMARY KEY of a row would generate a foreign key error on all FOREIGN KEYs which referenced secondary keys of the row to be updated. Also, if a referencing FOREIGN KEY constraint only referenced the first columns in an index, and there were more columns in that index, updating the additional columns generated a foreign key error. These bug fixes will only be backported to 3.23 if users find this a big problem.
  • Fixed a bug: if an index contains some column twice, and that column is updated, the table will become corrupt. From now on InnoDB prevents creation of such indexes.
  • Fixed a bug: removed superfluous error 149 and 150 printouts from the .err log when a locking SELECT caused a deadlock or a lock wait timeout.
  • Fixed a bug: an assertion in btr0sea.c, in function btr_search_info_update_slow could theoretically fail in a race of 3 threads.
  • Fixed a bug: one could not switch a session transaction isolation level back to REPEATABLE READ after setting it to something else.
[break]Kies hier de bij jou passende download.
Versienummer:4.0.9 Gamma
Besturingssystemen:Windows 9x, Windows NT, Windows 2000, Linux, BSD, Windows XP, Linux x86, macOS, Solaris, UNIX
Website:MySQL
Download:http://www.mysql.com/downloads/mysql-max-4.0.html
Licentietype:GPL
Moderatie-faq Wijzig weergave

Reacties (5)

ik zit te wachten op 4.1.0... daar komen subselects in!!!
Is MySQL niet onder GPL uitgebracht?
We have made our product available at zero price under the GNU General Public License (GPL), and we also sell it under a commercial license to those who do not wish to be bound by the terms of the GPL.
Dit is wat op www.mysql.com staat.

edit:
Er staat namelijk Freeware bij licentietype ;)
Hmm, we gaan hard nu. Op naar de lang verwachte 4.1 met de nieuwe oh zo nuttige features :)
eerst wel ff wachten op de 4.0 final (stable)
het blijft maar doorgaan :)

goed natuurlijk. Maar als ik een rpm pak om up te graden, kan ik dan gewoon

rpm -Uvh *.rpm

geven om de dbase up te daten zonder dat ik de databases verneuk?

Op dit item kan niet meer gereageerd worden.



Apple iOS 10 Google Pixel Apple iPhone 7 Sony PlayStation VR AMD Radeon RX 480 4GB Battlefield 1 Google Android Nougat Watch Dogs 2

© 1998 - 2016 de Persgroep Online Services B.V. Tweakers vormt samen met o.a. Autotrack en Carsom.nl de Persgroep Online Services B.V. Hosting door True