Tools Overview
cPanel Control Panel
WHM Control Panel
Fantastico Script Installer
RVSkin Control Panel
Anit-Virus / Spam Protection
Web-Based Email
Website Logs & Stats
MySQL Database Technology
How we speed up your site!
Free Website Builder
Secure Server Access
Easy-to-use Interface
70+ Free Templates
Create, Manage & Publish Your website.
 
What do our
customers
have to say?

AOL IM: PlanetHTTP
Phone: 877.4MY.HTTP
Support Desk
Community Forums
Frequently Asked
Questions

 
Home » Tools » MySQL Database
The MySQL database server is the world's most popular open source database. Its architecture makes it extremely fast and easy to customize. Extensive reuse of code within the software and a minimalistic approach to producing functionally-rich features has resulted in a database management system unmatched in speed, compactness, stability and ease of deployment. The unique separation of the core server from the storage engine makes it possible to run with strict transaction control or with ultra-fast transactionless disk access, whichever is most appropriate for the situation.

MySQL includes the MySQL storage engines and the InnoDB storage engine. InnoDB is a transaction-safe, ACID-compliant storage engine with commit, rollback, crash recovery and row-level locking capabilities. This version is for users who want the high-performance MySQL database with full transaction support.


ANSI SQL syntax support
  The MySQL database server supports a broad subset of the ANSI SQL 99 syntax, along with extra extensions such as the REPLACE statement and the LIMIT clause for SELECT and DELETE. Alternative syntaxes from other database systems are also supported, to make porting applications easier. MySQL coverage of the complete ANSI SQL 99 syntax is expanding, with version 4.0 introducing support for the UNION statement.
Independent storage engines
  MySQL database server's unique independent storage engines let you choose the type of database storage that is most appropriate for your particular needs. If you need row-level locking and transaction support, you can use the InnoDB storage engine. If your application doesn't require transactions, you can use the MyISAM storage engine for maximum performance.
Transactions
  Using the InnoDB or Berkeley DB (BDB) storage engines, the MySQL database server supports transactions. The InnoDB storage engine also supports foreign key constraints.
Flexible security system, including SSL support
  The MySQL database server has an advanced permissions and security system, including support for SSL transport-layer encryption. As of version 4.0, the security system also allows you to limit server resources on a per-user basis.
Query caching
  MySQL includes a new query cache, which can significantly increase the performance of commonly-issued queries, without requiring any special programming. Performance can be increased by over 200% in typical usage.
Full-text indexing and searching
  Full-text indexes allow you to search fields containing arbitrary text for specific words and phrases, including relevance rankings. With version 4.0, we've expanded the fulltext search to include exact phrase matching and Boolean search operators, which allows for even more fine-grained control over your search results.
MySQL Awards (Click Here)
MySQL FAQ (ClickHere)
 
Copyright © 2005 All Rights Reserved PlanetHTTP
Terms of Service | Privacy