Morgan Tocker ([info]mtocker) wrote,
@ 2009-06-05 13:43:00
Previous Entry  Add to memories!  Tell a Friend  Next Entry
Entry tags:mysql

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.


(1 comment) - (Post a new comment)


[info]awfief
2009-06-09 09:08 pm UTC (link)
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

(Reply to this)

(1 comment) - (Post a new comment)

Create an Account
Forgot your login or password?
Login w/ OpenID
English • Español • Deutsch • Русский…