The MySQL Database 5.5 improves performance and scalability on multi-processor hardware architectures. The new replication monitoring and manageability features provide developers and DBAs with improved tools for building high performance, scalable applications. In addition, the MySQL Performance Schema provides low-level insight into MySQL database performance metrics.
MySQL Database 5.5 delivers enterprise features, including:
- Improved! Up to 540% faster performance on Windows
- Improved! Up to 370% faster performance on Linux
- Improved! Better scalabilty on modern, multi-core, multi-CPU hardware
- New! Performance Schema for monitoring MySQL server run-time performance
- New! Semi-synchronous replication to ensure data consistency and redundancy
- New! Replication Heartbeat to immediately uncover replication interruptions
- New! Partitioning options for faster lookups
- New! Easier development and debugging of stored procedures, functions, and triggers
- Reliability requiring little or no intervention to achieve continuous uptime
- Ease of use with "15 minutes to success" installation and configuration
- Low administration with very little database maintenance required
- Replication providing flexible topologies for scale-out and high availability
- Partitioning to improve performance and management of very large database environments
- ACID Transactions to build reliable and secure business critical applications
- Stored Procedures to improve developer productivity
- Triggers to enforce complex business rules at the database level
- Views to ensure sensitive information is not compromised
- Information Schema to provide easy access to metadata
- Pluggable Storage Engine Architecture for maximum flexibility
