5.7的新特性

安全加固：
1.在8.0，caching_sha2_password是默认的认证方法，5.7的客户端也支持caching_sha2_password来连接8.0
2.不允许匿名用户登录，mysql_old_password 的认证方式已经被去掉了
3.mysql允许管理员使用自动的密码过期管理策略
4.管理员可以锁定和解除一个用户
5.增加了OpenSSL认证
6.mysqld –initialize来初始化，初始化一个root’@’localhost’用户和随机密码，创建非匿名用户，没有test库
7.默认开启事务性存储殷勤的严格SQL模式
he changes to the default SQL mode result in a default sql_mode system variable value with
these modes enabled: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,
NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, and
NO_ENGINE_SUBSTITUTION
8.Online DDL支持rename index
9.innodb加强：
alter table 的算法：
ALGORITHM=INPLACE 支持从0改成255，或者255改成比255大，但是不支持从比255小改到比255大，且不支持变小。这个要用ALGORITHM=COPY
10. 临时表的DDL性能变强
11. InnoDB临时表的元数据不再存储在innodb系统表，而是从存储在NNODB_TEMP_TABLE_INFO
12. innodb支持立体空间数据类型
13. innodb临时表有独立的表空间，用 innodb_temp_data_file_path这个参数控制
14. InnoDB buffer pool dump and load operations are enhanced，innodb会把经常使用的热数据导出来，使用innodb_buffer_pool_dump_pct控制
15. InnoDB supports multiple page cleaner threads for flushing dirty pages from buffer pool instances，使用innodb_page_cleaners参数控制
16. 支持Online DDL的操作：OPTIMIZE TABLE，ALTER TABLE … FORCE，ALTER TABLE … ENGINE=INNODB (when run on an InnoDB table)
17. InnoDB supports the Transportable Tablespace feature for partitioned InnoDB tables and
individual InnoDB table partitions. This enhancement eases backup procedures for partitioned
tables and enables copying of partitioned tables and individual table partitions between MySQL
instances. For additional information, see Section 14.7.6, “Copying File-Per-Table Tablespaces to
Another Instance”.
18.The innodb_buffer_pool_size parameter is dynamic, allowing you to resize the buffer
pool without restarting the server. The resizing operation, which involves moving pages to a
new location in memory, is performed in chunks. Chunk size is configurable using the newFeatures Added in MySQL 5.7.12
innodb_buffer_pool_chunk_size configuration option. You can monitor resizing progress using the new Innodb_buffer_pool_resize_status status variable
19.关机和开机的时候支持page cleaner，由参数innodb_page_cleaners控制
20.InnoDB performs a bulk load when creating or rebuilding indexes
21.A new log record type (MLOG_FILE_NAME) is used to identify tablespaces that have been modified since the last checkpoint
22.You can truncate undo logs that reside in undo tablespaces. This feature is enabled using the innodb_undo_log_truncate configuration option
23.InnoDB supports native partitioning. Previously, InnoDB relied on the ha_partition handler,
which creates a handler object for each partition. With native partitioning, a partitioned InnoDB
table uses a single partition-aware handler object. This enhancement reduces the amount of
memory required for partitioned InnoDB tables
24.mysql支持在数据目录空间外创建表空间
25.DYNAMIC replaces COMPACT as the implicit default row format for InnoDB tables.使用参数innodb_default_row_format来控制
26. JSON support
27. 系统参数和状态可以在INFORMATION_SCHEMA这张表里找到
28. 增加了sys schema
29.优化的增强，支持对某个connection做explain，也可以使用提示
30.支持虚拟列，已经使用ctrl+c不再推出mysql
31.mysqlbinlog –rewrite-db=’dboldname->dbnewname’ 可以重命名数据库名
32.Index condition pushdown support for partitioned tables
33.Master dump thread improvements
34.Changing the replication master without STOP SLAVE
35.Multi-source replication is now possible
36.Multi-source replication is now possible

5.7弃用的特性：
1.Using GRANT to create users
2.Using GRANT to modify account properties other than privilege assignments
3.Using GRANT to modify account properties other than privilege assignments
4.The query cache is deprecated
5.The log_warnings system variable and –log-warnings server option are deprecated. Use the log_error_verbosity system variable instead.
6.The global character_set_database and collation_database system variables are deprecated and will be removed in a future version of MySQL
7.The global scope for the sql_log_bin system variable has been deprecated
8.The global scope for the sql_log_bin system variable has been deprecated
9.Treatment of \N as a synonym for NULL in SQL statements is deprecated and is removed in MySQL 8.0; use NULL instead

5.7移除的特性：
1.SHOW ENGINE INNODB MUTEX output is removed
2.The InnoDB Tablespace Monitor and InnoDB Table Monitor are removed.
3.The specially named tables used to enable and disable the standard InnoDB Monitor and InnoDB Lock Monitor (innodb_monitor and innodb_lock_monitor) are removed and replaced by two dynamic system variables: innodb_status_output and innodb_status_output_locks