MySQL Technical Specifications

Flexible Architecture

• Open Source
• Multi-threaded
• Pluggable Storage-Engine Achitecture
• InnoDB
• MyISAM
• Merge
• Memory
• Archive
• Cluster

ANSI SQL Standards

• ANSI SQL
• SubQueries, Joins, Cursors
• Prepared Statements
• Views
• Triggers
• Stored Procedures
• User-Defined Functions
• Information Schema
• Unicode
• Referential Integrity
• Server-enforced Data Integrity

Replication & High-Availability

• Built-in Replication Engine
• Master/Slave
• Dual Master
• Replication Ring
• Replication Tree
• Row-based Replication
• Semi-synchronous Replication
• MySQL Cluster HA

MySQL Cluster

• 99.999% Availability
• Distributed architecture
• Synchronous replication
• Real-time transactional performance
• SQL & Non-SQL data access
• Java, C++, memcached, HTTP

Storage Management

• Storage Administration
• Automatic Space Expansion
• Built-in Space Reclamation
• Auto Undo/Rollback Management
• Customizable Storage Assignments
• Compressed and Archive Tables
• Packed Index Storage
• Works with NAS or SAN storage

Security

• SSL Support
• Built-in Data Encryption/Decryption
• Fine Grained Object Privileges
• View Support
• Triggers for auditing
• Query Logs for auditing

High-Performance

• Dynamic Memory Caches
• Unique Query Cache
• Multiple Index Type (B-tree, R-tree, Hash, etc.)
• Cost-based Optimizer
• High-speed Query Optimizer
• Diagnostics and SQL Tracing
• Performance Schema

OLTP and Transactions

• ACID Transactions
• Commit, Rollback
• Foreign Keys
• Referential Integrity
• Row-level Locking
• Customizable Lock Isolation Levels
• Distributed Transactions (XA)
• Snapshot
• Repeatable Reads (readers don’t block writers and vice-versa)
• Timed Deadlock Detection

Web Application Optimized features

• Server-side Thread Pool
• Connection Thread Caching
• Query Results Caching
• Load Balancing
• Prepared Statements
• Full Text Search
• Multiple Character Sets
• Geospatial Support
• Multi-Terabyte Scalability

Data Warehouse Optimized features

• Fast Data Load Utility
• High-Speed Multi-Insert Function
• GROUP BY WITH ROLLUP
• Aggregate UDF
• Analytic SQL Functions
• Geospatial Support
• Multi-Terabyte Scalability

Partitioning (Table/Index)

• Range
• Hash
• List
• Key
• Composite

Manageability and Ease of Use

• Easy Install and Setup 

• "15 minutes to Success"

• Information Schema 

• Event Scheduler

MySQL Enterprise Backup¹

• Hot Backup for InnoDB

• Logical, Physical Backup
• Compressed Backup

• Full, Incremental, Partial Backups

• Full, Partial Restore
• Point in Time Recovery

• Auto-Restart/Recovery

MySQL Enterprise High Availability¹

• Oracle VM Template for MySQL
• Windows Failover Clustering for MySQL

MySQL Enterprise Scalability¹

• MySQL Thread Pool

MySQL Enterprise Security¹

• MySQL External Authentication
• PAM (Pluggable Authentication Module)
• Windows Native Authentication

MySQL Enterprise Monitor¹

• MySQL Enterprise Dashboard
• MySQL Query Analyzer

• MySQL Enterprise Advisors

• MySQL Replication Monitor

MySQL Enterprise Advisors¹

• Administration Advisor
• Security Advisor
• Replication Advisor
• Performance Advisor
• Memory Usage Advisor
• Schema Advisor
• Updgrade Advisor
• Custom Advisor

Graphical Tools

• MySQL Workbench
• Data Modeling

• Database Administration
• SQL Editor

Drivers

• MySQL Native C Library
• MySQL Drivers for ODBC, JDBC, .Net, C, C++
• Community Drivers for PHP, Perl, Python, Ruby

Operating Systems

• Linux, Solaris, FreeBSD, Mac OS, Windows