3 ms·

1. We're working on something in this area: http://mysqlserverteam.com/generated-columns-in-mysql-5-7-5/ http://mysqlserverteam.com/generated-columns-in-mysql-5

by morgo 12y ago

1. We're working on something in this area: http://mysqlserverteam.com/generated-columns-in-mysql-5-7-5/ http://mysqlserverteam.com/generated-columns-in-mysql-5-7-5/ 2. InnoDB has fulltext from MySQL 5.6+ 3. I agree utf8mb4 should be renamed "utf8". When this was introduced it was given a new name to support downgrades, but the feature does exist :) 4. RAND() is actually deterministic (via other meta data written to the binlog). In any case, MySQL also supports Row-based replication and it is the proposed default for 5.7. 5. I would like to have this feature too :) It is important to note that few databases have this though. 6. MyISAM is no longer the default. PITR works fine with InnoDB. 7. The logging verbosity can be changed. In MySQL 5.7 there is a new server logging API which makes sure the output format is consistent. For some of the meta data you are suggesting, the better place to retrieve this is performance_schema. 8. You are probably talking about gap locks etc. These are required for statement-based replication, with Row-based they are not required. 10. I would suggest that ARCHIVE engine is of limited use-cases. 11. Please see http://mysqlserverteam.com/the-mysql-5-7-6-milestone-release-is-available/ http://mysqlserverteam.com/the-mysql-5-7-6-milestone-release... (search "innodb native partitioning"). Allowing more arbitrary functions would most likely require global secondary indexes. 5.7.6 contains an important change to move in that direction. 12. GIS support is improved dramatically in 5.7, including InnoDB support. Please take another look :) 14. I agree on this one. Async drives is becoming very important :) RE: Point #4 in your second list, MySQL 5.6 contains much better configuration out of the box: http://www.tocker.ca/2013/09/10/improving-mysqls-default-configuration.html http://www.tocker.ca/2013/09/10/improving-mysqls-default-con...

IgorPartola 12y ago
Thanks. I'll add one more and maybe this is already in the works: last I checked you couldn't rebuilt an index of an InnoDB table without re-inserting all the rows into a table. This meant that adding an index to a huge table was very slow. I didn't know about a lot of these improvements, and am happy that they are happening. I moved away from MySQL around 2012-2013 because of the above reasons, so glad that things are improving.
- morgo 12y ago
  MySQL 5.6 supports Online DDL. Most operations are online, you can see a list at: http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-overview.html http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-o... (The table 14.5 column "Allows Concurrent DML?" is the interesting one.)
  - IgorPartola 12y ago
    Awesome, thanks. I am actually really happy about this.

by morgo 12y ago

IgorPartola 12y ago

Thanks. I'll add one more and maybe this is already in the works: last I checked you couldn't rebuilt an index of an InnoDB table without re-inserting all the rows into a table. This meant that adding an index to a huge table was very slow. I didn't know about a lot of these improvements, and am happy that they are happening. I moved away from MySQL around 2012-2013 because of the above reasons, so glad that things are improving.

morgo 12y ago
MySQL 5.6 supports Online DDL. Most operations are online, you can see a list at: http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-overview.html http://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-o... (The table 14.5 column "Allows Concurrent DML?" is the interesting one.)
- IgorPartola 12y ago
  Awesome, thanks. I am actually really happy about this.