« No Longer a MySQL Cluster Hobbyist? | Main | Day Spent with MySQL 5.1 »
March 28, 2006
What's New with MySQL 5.1.x
There's a lot to be said about what's happening in MySQL 5.1 Quite a bit has already been written about 5.1, but as I'm starting to do some testing I thought I'd hit the release notes and see how things have progressed over the past few months. Some great things coming down the line. A few that I found worthy of note:
- 5.1.8 (not released)
- mysqldump can dump events using --events
- CREATE PROCEDURE and CREATE FUNCTION now allow DEFINER syntax
- 5.1.7
- Now must use ENGINE= instead of TYPE= for specifying the storage engine to use with CREATE TABLE
- mysql_upgrade program which is smart about upgrading between versions
- new RENAME DATABASE statement
- creating, changing or dropping events is not allowed in triggers
- 5.1.6
- Packaging changes - the mysql and mysql-debug now both come in a distro, and there is no -max
- safe_mysqld is gone - for a long time it was a symlink to mysqld_safe, finally got rid of it
- TRIGGER privilege is introduced - users no longer need SUPER privilege to CREATE or DROP triggers
- FULL TEXT INDEX now will match against words with apostrophe (')
- Event Scheduler (with EVENT privilege)
- Replication available between clusters and from cluster to other engines
- Logging can now go into tables (general_log and slow_log) in the mysql database
- several new INFORMATION_SCHEMA tables
- quite a few partitioning changes/enhancements
- and more
- 5.1.4
- added mysqlslap program for simulating multi-client load
- 5.1.3
- partitioning - gives you ability to put data from a single table in multiple locations
- plugin API - can load/unload plugins at runtime
- VARCHAR are now variable sized in the cluster (previsously allocated the entire defined length + 2 bytes)
These highlights represent a small fraction of all the entries in the release notes for 5.1. Things seem to be moving along quickly with the 5.1 release, first public release in November 2005, into beta already by February 2006. Rumor is that 5.2 won't be far behind 5.1 and will include numerous exciting enhancements.
Posted by mike at March 28, 2006 12:10 AM
Hard Drive Recovery Group offers hard disk data recovery services for RAID, laptops and servers. Complete clean room and hard drive repair service.Trackback Pings
TrackBack URL for this entry:
http://mike.kruckenberg.com/mt/mt-tb.cgi/796