7 ms·

So there has not been any major improvement in MySQL for 3 years? There hasn‘t been released any minor version? Can someone explain the current state more?

by tpetry 5y ago

PeterZaitsev 5y ago
No. MySQL 8 changed its engineering approach with features released in minor releases. In this regard it is like MacOS X or Windows 10, whatever you prefer where features are shipped without major version change
- tpetry 5y ago
  Sure, and this is great. But The newest release is 8.0.26, so there hasn‘t been any minor release yet - in 3 years. And i can‘t find anything about new MySQL features or planned features except the big 8.0 release.
  - PeterZaitsev 5y ago
    There are new features introduced in 8.0.26 as in .25 .24 etc before that check out release notes.
  - fipar 5y ago
    There have been several minor releases in the past 3 years: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/ https://dev.mysql.com/doc/relnotes/mysql/8.0/en/
    - taywrobel 5y ago
      In semantic versioning parlance those would all be considered "patch" releases, not a "minor" release. The minor version segment in a semantic version is the 2nd number, so most people would consider the next "minor release" for MySQL to be 8.1.0. If following the guidance set out at https://semver.org https://semver.org, a patch release wouldn't add any new functionality, it would just address bugs in a backwards compatible way. A minor version would introduce new functionality in a way that doesn't violate backwards compatibility. Quickly scanning the release notes for some of the MySQL 8 versions, they seem to be generally sticking to this; most of the versions fixed some bugs or unintuitive behavior, but it doesn't look like much new functionality has been introduced since 8.0.4, the last release candidate for the major version bump.
      - PeterZaitsev 5y ago
        MySQL does not follow semantic version and there have been features introduced in minor released including some incompatible changes as you can see for example https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-24.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-24....
        Tostino 5y ago
        Yeah, no thank you. I'll stick with Postgres.
        fastball 5y ago
        That's still a patch release not a minor release.
        bonzini 5y ago
        If it does not follow semantic versions, it is just a third-level version number. It's like Linux's 2.6.x series.
      - evanelias 5y ago
        Many major new features have been introduced in 8.0 point releases. Some examples: * 8.0.12 added INSTANT algorithm for adding new columns to a table * 8.0.13 added DEFAULT expressions (column default values may now be any arbitrary expression, not just a constant) * 8.0.16 added CHECK constraints * 8.0.17 added the CLONE plugin for rapid physical copying of a db * 8.0.23 added INVISIBLE columns (excluded from SELECT *) These are just a handful among many others... basically MySQL 8 does not follow SemVer at all, nor does it claim to. (Although personally as a tool developer in the mysql ecosystem, I selfishly wish they did!)
        dijit 5y ago
        That’s pretty scary, isn’t it?
        5y ago
  - buchanmilne 5y ago
    MySQL GA dates: 5.5 3 December 2010 5.6 5 February 2013 5.7 21 October 2015 8.0 19 April 2018 The average seems to be about 2.5 years between minor releases, so this doesn't seem unusual. Usually new minor versions are only released if there are: * Changes to database behaviour defaults (e.g. default sql mode) * Deprecation or removal of features * Compatibility changes (changes to replication formats) New features are fine, as long as they don't introduce regressions in other areas. Even MySQL 5.7 received some good improvements in the past 18-24 months (not just bug fixes). I feel this is a really pedantic complaint from someone who either doesn't use MySQL, or wants to hate it for a silly reason.

So there has not been any major improvement in MySQL for 3 years? There hasn‘t been released any minor version? Can someone explain the current state more?

by tpetry 5y ago

So there has not been any major improvement in MySQL for 3 years? There hasn‘t been released any minor version? Can someone explain the current state more?

PeterZaitsev 5y ago

No. MySQL 8 changed its engineering approach with features released in minor releases. In this regard it is like MacOS X or Windows 10, whatever you prefer where features are shipped without major version change

tpetry 5y ago
Sure, and this is great. But The newest release is 8.0.26, so there hasn‘t been any minor release yet - in 3 years. And i can‘t find anything about new MySQL features or planned features except the big 8.0 release.
- PeterZaitsev 5y ago
  There are new features introduced in 8.0.26 as in .25 .24 etc before that check out release notes.
- fipar 5y ago
  There have been several minor releases in the past 3 years: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/ https://dev.mysql.com/doc/relnotes/mysql/8.0/en/
  - taywrobel 5y ago
    In semantic versioning parlance those would all be considered "patch" releases, not a "minor" release. The minor version segment in a semantic version is the 2nd number, so most people would consider the next "minor release" for MySQL to be 8.1.0. If following the guidance set out at https://semver.org https://semver.org, a patch release wouldn't add any new functionality, it would just address bugs in a backwards compatible way. A minor version would introduce new functionality in a way that doesn't violate backwards compatibility. Quickly scanning the release notes for some of the MySQL 8 versions, they seem to be generally sticking to this; most of the versions fixed some bugs or unintuitive behavior, but it doesn't look like much new functionality has been introduced since 8.0.4, the last release candidate for the major version bump.
    - PeterZaitsev 5y ago
      MySQL does not follow semantic version and there have been features introduced in minor released including some incompatible changes as you can see for example https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-24.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-24....
      - Tostino 5y ago
        Yeah, no thank you. I'll stick with Postgres.
      - fastball 5y ago
        That's still a patch release not a minor release.
        bonzini 5y ago
        If it does not follow semantic versions, it is just a third-level version number. It's like Linux's 2.6.x series.
    - evanelias 5y ago
      Many major new features have been introduced in 8.0 point releases. Some examples: * 8.0.12 added INSTANT algorithm for adding new columns to a table * 8.0.13 added DEFAULT expressions (column default values may now be any arbitrary expression, not just a constant) * 8.0.16 added CHECK constraints * 8.0.17 added the CLONE plugin for rapid physical copying of a db * 8.0.23 added INVISIBLE columns (excluded from SELECT *) These are just a handful among many others... basically MySQL 8 does not follow SemVer at all, nor does it claim to. (Although personally as a tool developer in the mysql ecosystem, I selfishly wish they did!)
      - dijit 5y ago
        That’s pretty scary, isn’t it?
        5y ago
- buchanmilne 5y ago
  MySQL GA dates: 5.5 3 December 2010 5.6 5 February 2013 5.7 21 October 2015 8.0 19 April 2018 The average seems to be about 2.5 years between minor releases, so this doesn't seem unusual. Usually new minor versions are only released if there are: * Changes to database behaviour defaults (e.g. default sql mode) * Deprecation or removal of features * Compatibility changes (changes to replication formats) New features are fine, as long as they don't introduce regressions in other areas. Even MySQL 5.7 received some good improvements in the past 18-24 months (not just bug fixes). I feel this is a really pedantic complaint from someone who either doesn't use MySQL, or wants to hate it for a silly reason.