What's Different in MySQL 4.0 and 4.1? MySQL 3.23 was the production version for a long time. MySQL 4.0.13 was released as the production version of 4.0 in March 2003. The alpha of 4.1 was released in April. If you have used 3.23, these are the major changes you'll note in 4.0: -
The InnoDB storage engine is included in the standard binary. This was included in some later versions of 3.23. The InnoDB engine is ACID compliant, supporting transactions, foreign keys, and row-level locking. -
MySQL now uses a query cache, storing the results returned by queries for later reuse and, hence, greatly improving performance for common queries. -
Full-text indexing and searching, which were added in 3.23.23, have been improved with the addition of Boolean mode. -
MERGE tables now support INSERT and AUTO_INCREMENT . -
The result sets from SELECT queries can now be merged with UNION . -
You can now delete rows from multiple tables with a single DELETE statement. -
User privilege management has been refined. More privileges have been added to give you a finer grain of control, and you can also now limit a user 's resource use. -
You can now make changes to server configuration without having to restart the server. -
A new C language library, libmysqld, is now available to allow you to embed MySQL servers in your programs. -
Replication, which has been available since 3.23.15, has been improved in various ways, mostly bug fixes. For example, you can now set up a slave using LOAD DATA FROM MASTER , rather than having to use mysqldump or a tool like mysqlsnapshot. A lot of other small changes and improvements have been made. In 4.1, there are some additional improvements. The most important change is the addition of subqueries and derived tables. You also get Unicode support, support for OpenGIS geographical data storage, and a host of other minor improvements.  |
