3 ms·

MySQL Product Manager here. For a more general overview of 8.0, see: http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release-is-available/ http://mysqlser

by morgo 10y ago

MySQL Product Manager here. For a more general overview of 8.0, see: http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release-is-available/ http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release... This feature is part of the optimizer labs release, which also includes CTEs: http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-table-expressions-in-mysql-ctes/ http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-t...

rubiquity 10y ago
Wow! That's a lot of cool stuff! MySQL seems to really be alive lately. Did Oracle decide to give it more attention? We're very happy with 5.7 right now and 8.0 looks great. Our app is quite old so invisible indexes will be awesome for finding what we can get rid of. When will the JSON and CTEs make it into "proper" MySQL?
- morgo 10y ago
  The engineering team is 2x the size that it was at the time of the Oracle acquisition. 8.0 is the release where some of the investments are starting to pay off :) Invisible indexes was one of my FRs, so very happy to hear you like it. For others: http://mysqlserverteam.com/mysql-8-0-invisible-indexes/ http://mysqlserverteam.com/mysql-8-0-invisible-indexes/ Labs are merged into regular trunk when they pass QA qualification. A list of what is involved is here: http://anithagopi.blogspot.ca/2013/05/new-feature-qualification.html http://anithagopi.blogspot.ca/2013/05/new-feature-qualificat...
  - dcgudeman 10y ago
    when did the versioning for mysql change? After 5.7?
    - morgo 10y ago
      Yes. We wanted to be able to drop the leading 5. For context: 6.0 was a canceled release. 7.x. is used by Cluster. 8.0 makes it easy to follow as "it just drops the 5".
      - dcgudeman 10y ago
        Thanks for the quick reply, looks like a great release!
babyrainbow 10y ago
Can MySQL queries refer to a temporary tables more than once in the same query, yet?
- morgo 10y ago
  This limitation had to be lifted for CTEs to be reused, which is in the same labs release as the JSON functions mentioned here. I haven't checked yet if it is lifted for CTEs only, or all cases. But CTEs are a replacement for most (all?) uses of temporary tables that I can think of.

by morgo 10y ago

rubiquity 10y ago

Wow! That's a lot of cool stuff! MySQL seems to really be alive lately. Did Oracle decide to give it more attention? We're very happy with 5.7 right now and 8.0 looks great. Our app is quite old so invisible indexes will be awesome for finding what we can get rid of. When will the JSON and CTEs make it into "proper" MySQL?

morgo 10y ago
The engineering team is 2x the size that it was at the time of the Oracle acquisition. 8.0 is the release where some of the investments are starting to pay off :) Invisible indexes was one of my FRs, so very happy to hear you like it. For others: http://mysqlserverteam.com/mysql-8-0-invisible-indexes/ http://mysqlserverteam.com/mysql-8-0-invisible-indexes/ Labs are merged into regular trunk when they pass QA qualification. A list of what is involved is here: http://anithagopi.blogspot.ca/2013/05/new-feature-qualification.html http://anithagopi.blogspot.ca/2013/05/new-feature-qualificat...
- dcgudeman 10y ago
  when did the versioning for mysql change? After 5.7?
  - morgo 10y ago
    Yes. We wanted to be able to drop the leading 5. For context: 6.0 was a canceled release. 7.x. is used by Cluster. 8.0 makes it easy to follow as "it just drops the 5".
    - dcgudeman 10y ago
      Thanks for the quick reply, looks like a great release!

babyrainbow 10y ago

Can MySQL queries refer to a temporary tables more than once in the same query, yet?

morgo 10y ago
This limitation had to be lifted for CTEs to be reused, which is in the same labs release as the JSON functions mentioned here. I haven't checked yet if it is lifted for CTEs only, or all cases. But CTEs are a replacement for most (all?) uses of temporary tables that I can think of.