MySQL is the most popular, free, open-source database management system for the Unix/Linux platform. The MySQL database management system contains an enormous amount of functionality and power. In this article, Mitchell will describe some of its most popular features and most powerful functions.
MySQL: Open-Source Power - Popular features of MySQL (Page 2 of 5 )
If youíve been considering setting up a website, or porting your existing database to another platform, then there are several reasons why you should consider MySQL. Here are some of them:
MySQL can be accessed and manipulated from a huge number of popular programming languages. A complete set of APIís is provided for MySQL in C, C++, Eiffel, Java, Perl, PHP, Python, and Tcl.
MySQL was written in C and C++, and is completely optimized for both the Unix and Win32 platforms. It uses in-memory hash tables, thread-based memory allocation, kernel threads that are capable of utilizing multiple processors, and highly optimized individual pre-compiled class libraries.
MySQL contains built-in support for every common field type, including FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, SET and ENUM.
MySQL supports a subset of advanced querying and grouping functions, including GROUP BY and ORDER BY, COUNT(), AVG(), STD(), SUM() MAX() and MIN().
MySQL allows per-server password allocation. Also, any passwords that are passed to the MySQL engine for authentication are fully encrypted.
MySQL supports a variety of connection methods including TCP/IP sockets, Unix Sockets, and named pipes for Windows NT/2000.
MySQL is a free download, and comes complete with all of the tools you need to get started. The Win32 version includes a GUI based management and configuration tool named winmysql.exe.
MySQL is also one of the most stable database management systems on the market. The MySQL ISAM table format uses proven code, which was originally created back in the late eighties. When MySQL was released to the general public in mid-1996, any outstanding bugs were quickly found and eradicated. Now, some six years later, MySQL is so stable, that corporate identities all over the world are using it as part of their deployment strategy for mission-critical business apps.
Mission-critical business apps require huge amounts of storage space. This isnít a problem for MySQL, with tables capable of holding up to 4 gigabytes of data. More recently though, MySQL 3.23 contains a new table type called MyISAM, which can hold up to 8 million terabytes of data!