Home arrow MySQL arrow Page 2 - MySQL: Open-Source Power

MySQL: Open-Source Power

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.

Author Info:
By: Mitchell Harper
Rating: 3 stars3 stars3 stars3 stars3 stars / 8
December 09, 2001
  1. · MySQL: Open-Source Power
  2. · Popular features of MySQL
  3. · Powerful functions of MySQL explained
  4. · Some MySQL language syntax explained
  5. · Conclusion

print this article

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!
blog comments powered by Disqus

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 Ė More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials