here we will see the important characteristics and feature of the MySQL Database Software. MySQL is written in C and C++ and Tested with a broad range of different compilers to Works on many different platforms.

• The MySQL Server design is multi-layered with independent modules.
• Fully multi-threaded using kernel threads. It can easily use multiple CPUs if they are available.
• Provides transactional and non-transactional storage engines
• Uses very fast B-tree disk tables (MyISAM) with index compression.
• Relatively easy to add other storage engines. This is useful if you want to provide an SQL interface for an in-house database.
• A very fast thread-based memory allocation system.
• Very fast joins using an optimized one-sweep multi-join.
• In-memory hash tables, which are used as temporary tables.
• SQL functions are implemented using a highly optimized class library. Usually there is no memory allocation at all after query initialization.
• Support verity of datatypes including signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types.
• Full support for SQL GROUP BY, ORDER BY clauses and JOIN
• Handles large databases.
• APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl are available.
• MySQL Connector/NET enables developers to easily create .NET applications that require secure, high-performance data connectivity with MySQL
• Full support for several different character sets, including latin1 (cp1252), german, big5, ujis, and more.

The most requested features and the versions in which they were implemented or are scheduled for implementation are summarized in the following table:

discuss this topic to forum