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, Ring, Tree
• Row-based Replication
• Semi-synchronous Replication
• Time-delayed Replication
• MySQL Cluster HA
• Global Transaction IDs
• Slave Failover, Recovery
• Multi-threaded slaves

MySQL Cluster

• 99.999% Availability
• Distributed architecture
• Synchronous replication
• Real-time transactional performance
• SQL & Non-SQL data access
• Auto sharding of data
• 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
• Password management
• Fine Grained Object Privileges
• View Support
• Triggers for auditing
• Query Logs for auditing

High-Performance

• Performance Schema
• Optimized for high concurrency
• Optimized for Read Only
• Optimized for use with SSD
• Multiple Index Type (B-tree, R-tree, Hash, etc.)
• Cost-based Optimizer
• High-speed Query Optimizer
• Subquery optimizations
• Diagnostics, and SQL Tracing
• Optimizer Tracing
• EXPLAIN for SELECT, INSERT, UPDATE, DELETE
• Structured EXPLAIN output

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
• 8k partitions per table
• Portable partitions between tables
• Explicit querying by partition

Manageability and Ease of Use

• Easy Install and Setup
• "3 minutes to Success" with all-in-one Windows Installer
• Information Schema 

• Event Scheduler

MySQL Enterprise Backup¹

• Hot Backup for InnoDB

• Parallel backup, recovery operations
• Compressed Backup

• Full, Incremental, Partial Backups

• Full, Partial Restore
• Point in Time Recovery

• Auto-Restart/Recovery
• Scriptable, command line interface
• Integrated with Oracle Secure Backup, NetBackup, Tivoli

MySQL Enterprise High Availability¹

• Oracle VM Template for MySQL
• Windows Failover Clustering for MySQL
• Oracle Linux and DRBD
• Oracle Solaris Clustering

MySQL Enterprise Scalability¹

• MySQL Thread Pool

MySQL Enterprise Security¹

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

MySQL Enterprise Audit¹

• Policy-based auditing compliance

MySQL Enterprise Monitor¹

• MySQL Enterprise Dashboard
• MySQL Query Analyzer

• MySQL Enterprise Advisors

• MySQL Replication Monitor

MySQL Enterprise Advisors¹

• MySQL Backup Advisor
• MySQL Cluster Advisor
• 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
• Database Migration

Drivers

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

Operating Systems

• Linux, Solaris, FreeBSD, Mac OS, Windows