Morgan Tocker ([info]mtocker) wrote,
2009-06-05 13:43:00
  • Previous
  • Memorize
  • Share
  • Next

Hidden gems in 5.1

I think 5.1 gets some bad press for not being a compelling upgrade. It's not the big features that make the difference, but the subtle ones. I wanted to highlight some of the these that may make your life easier when it's time to upgrade:

* Prepared statements can now use the query cache. BUG #735
* InnoDB auto_increment insertion is more scalable. Manual Page
* The long_query_time can be set to values less than 1 second. BUG #6238
* SHOW PROFILES is available for everyone, not just community users!
* Creating Triggers no longer requires the SUPER privilege.

Let's hope for 1000 more of these in MySQL 5.4.
Tags: mysql

  • Post a new comment

    Error

    switch

    Your IP address will be recorded 

     
    Help
  • 1 comments

[info]awfief

June 9 2009, 21:08:53 UTC 2 years ago

For me, the biggest things are the (few) online ALTER TABLE statements and the PROCESSLIST table in the INFORMATION_SCHEMA (finally I don't have to use "grep" and "cut" to get a list of id's of only sleeping queries!).

That and the fact that 5.0 is EOL'd in December 2009.

http://www.pythian.com/news/1168/why-you-want-to-switch-to-mysql-51

I also have a guide on the most important things to know at

http://www.pythian.com/news/1414/new-in-mysql-51-sheeris-presentation
Create an Account
Forgot your login or password?
Facebook Twitter More login options
English • Español • Deutsch • Русский…