The following features were added in MySQL 4.0:
MySQL 4.0 implemented a query cache that can give a major speed boost to applications with repetitive queries. See Section 7.5.3, “The MySQL Query Cache”.
MySQL 4.0 further increased the speed of MySQL Server in a
number of areas, such as bulk
searching on packed indexes, full-text searching (using
FULLTEXT indexes), and
InnoDB storage engine as standard
capabilities of MySQL Server 4.0 enabled
FULLTEXT indexing of large text masses
with both binary and natural-language searching logic. It
became possible to customize minimal word length and
define your own stop word lists in most human languages,
enabling a broader class of applications to be built with
MySQL Server. See Section 11.9, “Full-Text Search Functions”.
Standards compliance, portability, and migration
MySQL Server added support for the
UNION statement, a standard
Starting with version 4.0, MySQL runs natively on Novell NetWare 6.0 and higher. See Section 2.7, “Installing MySQL on NetWare”.
German-speaking users should note that MySQL 4.0 added
support for a new character set,
latin1_de, which ensures that words
with umlauts are sorted in the same order as in German
On Windows, symbolic link handling at the database level
was enabled by default. On Unix, the
MyISAM storage engine added support for
symbolic linking at the table level (and not just the
database level as before).
The Embedded MySQL Server
The embedded server library added in this release can easily be used to create standalone and embedded applications. The embedded server provides an alternative to using MySQL in a client/server environment.
libmysqld embedded server library made
MySQL Server suitable for a wider range of applications. Using
this library, developers can embed MySQL Server into various
applications and electronics devices, where the end user has
no knowledge of there actually being an underlying database.
Embedded MySQL Server is ideal for use in Internet appliances,
public kiosks, turnkey hardware/software combination units,
high performance Internet servers, self-contained databases
distributed on CD-ROM, and so on.
The embedded MySQL library uses the same interface as the normal client library. See Section 17.5, “libmysqld, the Embedded MySQL Server Library”. Embedded MySQL is available under the same dual-licensing model as the MySQL Server; see http://www.mysql.com/company/legal/licensing/ for more information.
On Windows, there are two different libraries, as shown in the following table.
|Library Name||Library Type|
|Dynamic library for threaded applications.|
|Static library for not threaded applications.|
The news section of this manual includes a more in-depth list of MySQL 4.0 features. See Section C.2, “Changes in Release 4.0.x (Lifecycle Support Ended)”.