Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jan 14, 2002

MySQL 4.0.1 Now Available

By Forrest Stroud

MySQL 4.0.1 is now officially available for RedHat Linux and is available in alpha (beta) release for all other major operating systems (including Windows, Solaris, FreeBSD, MacOS X, HP-UX, AIX, and SGI Irix). MySQL is a fast, reliable, easy to use database server that consists of a multi-threaded SQL server that supports different backends, several different client programs and libraries, administrative tools, and several programming interfaces. Additionally, MySQL Server is now offered as a multi-threaded library which can be linked into your application to get a smaller, faster, easier to manage product.

The latest release offers new features geared towards existing business and community users, enhancing MySQL as the solution for mission-critical, heavy load database systems. The new embedded MySQL server library targets users of embedded databases. Using libmysqld, one can embed MySQL into various applications and electronics devices, where the end user has no knowledge of there actually being an underlying database. Embedded MySQL is ideal for use behind the scenes in internet appliances, public kiosks, turn-key hardware/ software combination units, high performance internet servers, self-contained databases distributed on CD-ROM, etc.

MySQL's performance has been enhanced in a number or areas as well, inluding bulk INSERTs, searching on packed indices, and the creation of FULLTEXT indices. Additional new features in v4.0.x include the table handler InnoDB with full support for transactions and row-level locking, support for secure traffic between the client and the server (i.e. SSL support for the mysqld server daemon process), support for multi-table DELETE statements, support for symbolic linking to MyISAM on the table level, support for the UNION SQL statement, and migration features like support for TRUNCATE TABLE (as in Oracle) and IDENTITY as a synonym for automatically incremented keys (as in Sybase).

MySQL 4.0.1 can be downloaded at:


» See All Articles by Editor Forrest Stroud

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM