MySQL
MySQL is a multithreaded, multi-user SQL database management
system (DBMS) which is reported to have more than 11 million
installations. The basic
program runs as a server providing multiuser access to a number of
databases.
The MySQL database server can handle deeply embedded
applications with a
footprint of only 1MB to running massive data warehouses holding
terabytes of information.
MySQL offers a powerful transactional database engine.
Features include complete ACID (atomic, consistent,
isolated, durable) transaction support, unlimited row-level locking,
distributed transaction capability, and multi-version transaction
support where readers never block writers and vice-versa. Full data
integrity is also assured through server-enforced referential
integrity, specialized transaction isolation levels, and instant
deadlock detection.
MySQL is a popular database backend for web sites as it has
a high-performance query engine, fast data insert
capability, and strong support for specialized web functions like fast
full text searches.
MySQL was awarded Application of the Year by YouTube, Amp'd
Mobile and Adobe.
MySQL 5.0.51
|
|
Price
Free to download
Size
26.3MB
License
GNU Public License or Commercial License
Developer
MySQL AB
Website
www.mysql.org
System Requirements
Support
Sites:
Planet
MySQL,
MySQL Forge,
MySQL
Conference & Expo, MySQL
Manual, MySQL
Gotchas, Introduction
to MySQL, Database
Journal, MySQL
Forums, MySQL
Help
Forums, MySQL
Lists
Selected
Reviews:
Techworld,
PostgreSQL
vs MySQL, MySQL
& Sequences, MySQL
vs. PostgreSQL
|
Key
features include::
- A broad subset of ANSI SQL 99, as well as extensions
- Cross-platform support
- Stored procedures
- Triggers
- Cursors
- Updatable Views
- True VARCHAR support
- INFORMATION_SCHEMA
- Strict mode
- X/Open XA distributed transaction processing (DTP) support;
two phase commit as part of this, using Oracle's InnoDB engine
- Independent storage engines (MyISAM for read speed, InnoDB
for transactions and referential integrity, Archive for storing
historical data in little space)
- Transactions with the InnoDB, BDB and Cluster storage
engines; savepoints with InnoDB
SSL support
- Query caching
- Sub-SELECTs (i.e. nested SELECTs)
- Replication with one master per slave, many slaves per
master, no automatic support for multiple masters per slave.
- Full-text indexing and searching using MyISAM engine
- Embedded database library
- Partial Unicode support (UTF-8 sequences longer than 3
bytes are not supported; UCS-2 encoded strings are also limited to the
BMP)
- ACID compliance using the InnoDB, BDB and Cluster engines
- Shared-nothing clustering through MySQL Cluster
- Multiple storage engines, allowing you to choose the one
which is most effective for each table in the application
- Native storage engines (MyISAM, Falcon, Merge, Memory
(heap), Federated, Archive, CSV, Blackhole, Cluster, BDB, EXAMPLE)
- Partner-developed storage engines (InnoDB, solidDB,
NitroEDB, BrightHouse)
- Community-developed storage engines (memcached, httpd, PBXT)
- Custom storage engines
- Commit grouping, gathering multiple transactions from
multiple connections together to increase the number of commits per
second.
Return
to 'Linux Equivalents' Home Page
Last Updated Monday, March 10 2008 @ 03:00 PM EST
|
