| [ < ] | [ > ] | [ << ] | [ Up ] | [ >> ] | [Top] | [Contents] | [Index] | [ ? ] |
MySQL 4.0 has a query cache that can give a huge speed boost to applications with repetitive queries. See section The MySQL Query Cache.
Version 4.0 further increases the speed of MySQL Server
in a number of areas, such as bulk INSERT statements, searching on
packed indexes, full-text searching (using FULLTEXT indexes), and
COUNT(DISTINCT).
The new Embedded Server library can easily be used to create standalone and embedded applications. The embedded server provides an alternative to using MySQL in a client/server environment. See section The Embedded MySQL Server.
InnoDB storage engine as standardThe InnoDB storage engine is now offered as a standard feature of the
MySQL server. This means full support for ACID transactions, foreign
keys with cascading UPDATE and DELETE, and row-level locking
are now standard features.
See section InnoDB.
The enhanced FULLTEXT search properties of MySQL Server 4.0 enables
FULLTEXT indexing of large text masses with both binary
and natural-language searching logic. You can customize minimal word
length and define your own stop word lists in any human language,
enabling a new set of applications to be built with MySQL Server.
See section Full-Text Search Functions.
Many users will also be happy to learn that MySQL Server now supports the
UNION statement, a long-awaited standard SQL feature.
MySQL now runs natively on the Novell NetWare 6.0 platform. See section Installing MySQL on NetWare.
Features to simplify migration from other database systems to MySQL
Server include TRUNCATE TABLE (as in Oracle).
Our German, Austrian, and Swiss users will note that MySQL now
supports a new character set, latin1_de, which ensures that the
German sorting order sorts words with umlauts in the same order
as do German telephone books.
In the process of implementing features for new users, we have not forgotten requests from our loyal community of existing users.
Most mysqld parameters (startup options) can now be set without taking
down the server. This is a convenient feature for database administrators
(DBAs).
See section SET OPTION.
Multiple-table DELETE and UPDATE statements have been added.
On Windows, symbolic link handling at the database level is enabled by default.
On Unix, the MyISAM storage engine now supports symbolic
linking at the table level (and not just the database level as before).
SQL_CALC_FOUND_ROWS and FOUND_ROWS() are new functions that make it
possible to find out the number of rows a SELECT query that includes a
LIMIT clause would have returned without that clause.
The news section of this manual includes a more in-depth list of features. See section Changes in release 4.0.x (Production).
| [ < ] | [ > ] | [ << ] | [ Up ] | [ >> ] | [Top] | [Contents] | [Index] | [ ? ] |
This document was generated on July, 26 2004 using texi2html 1.70.