MySQL Technical Specifications

MySQL Technical Specifications

Flexible Architecture

  • Open Source
  • Multi-threaded
  • Pluggable Storage-Engine Architecture
  • InnoDB, NDB Cluster
  • MyISAM, Merge, Memory, Archive

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
  • Multi-source Replication
  • Time-delayed Replication
  • MySQL Cluster HA
  • Global Transaction IDs
  • Slave Failover, Recovery
  • Multi-threaded slaves
  • Router
  • Sharding

MySQL Cluster

  • 99.999% Availability
  • Distributed architecture
  • Synchronous replication
  • Real-time transactional performance
  • Foreign Keys
  • 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
  • SSL Key Generation
  • Password management
  • Fine Grained Object Privileges
  • View Support
  • Triggers for auditing
  • Query Logs for auditing

High-Performance

  • Performance Schema
  • SYS Schema
  • Optimized for high concurrency
  • Optimized for Read Only
  • Optimized for use with SSD
  • Multiple Index Type (B-tree, R-tree, Hash, Full Text, etc.)
  • Cost-based Optimizer
  • Diagnostics, and SQL Tracing
  • Optimizer Tracing
  • JSON EXPLAIN

OLTP and Transactions

  • ACID Transactions
  • Commit, Rollback
  • Foreign Keys
  • Referential Integrity
  • Row-level Locking
  • Customizable Lock Isolation Levels
  • Distributed Transactions (XA)
  • Snapshot Isolation
  • Repeatable Reads (readers don't block writers and vice-versa)
  • Automatic 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
  • Multi-Terabyte Scalability

JSON Support

  • Native JSON Datatype
  • JSON Functions

Data Warehouse Optimized features

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

Partitioning (Table/Index)

  • Range, Hash, List, Key
  • Composite
  • 8k partitions per table
  • Portable partitions between tables
  • Explicit querying by partition
  • Transparent Pruning

Geo Spatial Support

  • InnoDB R-tree Spatial Indexes
  • GeoHash
  • GeoJSON

Full Text Search

  • Native InnoDB Full Text Search
  • Chinese, Japanese, & Korean

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 Backup1

  • 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 Availability1

  • Windows Failover Clustering for MySQL
  • Oracle Solaris Clustering

MySQL Enterprise Scalability1

  • MySQL Thread Pool

MySQL Enterprise Security1

  • MySQL Enterprise Authentication1
  • MySQL Enterprise Encryption1
  • MySQL Enterprise Firewall1
  • MySQL Enterprise Audit1

MySQL Enterprise Monitor1

  • Visual Dashboard
  • Query Analyzer
  • Rules & Advisors
  • Trends & Analysis
  • Health monitoring
  • Performance monitoring
  • InnoDB monitoring
  • Replication monitoring
  • Backup Monitoring
  • I/O Monitoring
  • Blocking/Locking Reports
  • Security administration

Oracle Enterprise Manager for MySQL1

Graphical Tools

  • MySQL Workbench
  • Data Modeling
  • Database Administration
  • SQL Editor
  • Database Migration
  • MySQL for Visual Studio
  • MySQL for Excel

Drivers

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

Operating Systems

  • Linux, Solaris, FreeBSD, Mac OS, Windows

1 Features only available in Commercial Editions.