Tuesday, April 6, 2010

MySQL Enterprise Server 5.1

What is new in MySQL 5.1

* Partitioning to improve performance and management of very large database environments
* Row-based/Hybrid Replication for improved replication security
* Event Scheduler to create and schedule jobs that perform various database tasks
* XPath Support
* Dynamic General/Slow Query Log
* Performance/Load Testing Utility (mysqlslap)

What are the enhancements and updates

* Full Text Search (faster, new dev templates)
* Archive engine (better compression, more features)
* User session and problem SQL identification
* MySQL embedded library (libmysqld)

Other interesting stuff

* Additional INFORMATION_SCHEMA objects
* Faster data import operations (parallel file load)
* 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
* Plugable Storage Engine Architecture for maximum flexibility
* Archive Storage Engine for historical and audit data

No comments:

Post a Comment