开发者社区> 芷沁> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

New in MySQL 8.0 - the Vanishing Parameters, Features...

简介: This article summarizes the parameters and features removed in the first version of MySQL 8.0. Note: Some parameters and features are currently set to deprecated in MySQL 8.
+关注继续查看

Galera_to_be_phased_out_MySQL_Group_Replication_officially_launched

This article summarizes the parameters and features removed in the first version of MySQL 8.0. Some parameters and features are currently set to deprecated in MySQL 8.0. Some others have been set to deprecated in MySQL 5.7 or earlier versions, but are removed from the code in MySQL 8.0.

MySQL 8.0.0

WL#7704:InnoDB: Remove deprecated file format parameters in 8.0

The purpose of supporting file-format configuration is to stay compatible with earlier versions. In versions earlier than MySQL 8.0, two primary file formats are supported:

1. Antelope: The corresponding row format is: COMPACT and REDUNDANT.


2. Barracuda: the new file format. The corresponding row format is: COMPRESSED and DYNAMIC.

Since earlier versions have passed the deadline for long-time maintenance, the old file formats are not maintained in MySQL 8.0 any more.

So removing the old code is helpful to clarify the code structure.


Several parameters related to file_format are removed:

innodb_file_format
innodb_file_format_check
innodb_file_format_max
innodb_large_prefix

Columns related to file-format in INFORMATION_SCHEMA are removed:

   innodb_sys_tables

After the code is committed, a large amount of code is erased and the structure looks much clearer.

WL#8157: Remove deprecated GIS functions

Old functions related to GIS are removed. New functions are replaced with ST_xxx. A total of 67 functions are removed, including their test cases.

WL#8843: Deprecate and remove the parameter innodb_support_xa

Parameter innodb_support_xa is removed. The reason is that this parameter has been invalid. On the one hand, when XA is set to OFF, PREPARE transactions can only be rolled back and cannot be committed; on the other hand, the data consistency of Binlog/Engine failure recovery should be ensured.

After this parameter is removed, the XA is enabled by default.

WL#8894: InnoDB: Remove deprecated parameter innodb_locks_unsafe_for_binlog

The same as above, the parameter innodb_locks_unsafe_for_binlog has been marked as deprecated in MySQL 5.6 and is removed from the code in MySQL 8.0. (The instruction document of the parameter. But again, I guess no one will set it in normal cases.)

WL#9071: Remove mysql_install_db and server --bootstrap option

The mysql_install_db is removed and the bootstrap parameter of mysqld is also deleted. In future, to install instances, you need to usemysqld --initialize


WL#9014: Deprecate and remove mysql_shutdown()


The C API mysql_shutdown is deleted and the Command type COM_SHUTDOWN is deleted.COM_SHUTDOWN


WL#9091: Remove --ssl, --ssl-verify-server-cert client-side options

The --ssl, --ssl-verify-server-cert client-side options are removed. In future, you can use --ssl-mode options implemented by WL#8785.

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
第08篇:Mybatis事务处理
Java JDK中提供了标准接口`Connection`,不同的数据库驱动负责具体的实现。后面无论是`Spring`还是`Mybatis`对事务的处理,无论怎么的封装,最终究其到底都是由`Connection`来提供的能力。
77 0
超详细整合SSM框架--(Spring + Spring MVC + MyBatis)
超详细整合SSM框架--(Spring + Spring MVC + MyBatis)
93 0
mybatis系列之mapper接口
hello~各位读者好,我是鸭血粉丝(大家可以称呼我为「阿粉」)。今天,阿粉带着大家来了解一下 mybatis 接口的创建。
66 0
mybatis系列之初识mybatis
今天开始,阿粉准备把 mybatis 的知识梳理一遍,为什么梳理 mybatis 呢?因为 mybatis 的源码最简单啊(说什么大实话)。no~no~no~,是因为现在的这些框架都和 springboot 整合在一起了,用起来是方便了,但是其中的原理就越不了解了。所以阿粉整理几篇 mybatis 的文章分享给大家,配合代码案例,希望大家有所收获。另外因为这是第一篇,所以代码量相对来说比较多,希望大家耐心看下去,毕竟阿粉也是下了一番功夫的,绝对是原创,如有雷同,肯定是他们抄袭阿粉的。 好了,话不多说,我们直接进入正题。
66 0
MyBatis 解析运行原理
提供一个接口 package com.ming.MyBatis; import com.ming.MyBatis.POJO.Role; import com.ming.MyBatis.POJO.Student; import com.
990 0
MyBatis实战系列之(2)
点击打开链接
613 0
[LeetCode] Missing Number
Given an array containing n distinct numbers taken from 0, 1, 2, ..., n, find the one that is missing from the array. For example, Given nums = [0, 1, 3] return 2. Note: Your algorithm
974 0
获得View在布局和屏幕上的位置(getLeft()以及getLocationOnScreen())
在一个布局中有一个控件View v. 可以通过以下方法可得到其在布局中的位置: v.getLeft(); v.getRight(); v.getBottom(); v.
842 0
+关注
芷沁
https://www.alibabacloud.com/blog/
文章
问答
文章排行榜
最热
最新
相关电子书
更多
Three steps to clustering your MySQL Environment——MNC、MGC与MIC
立即下载
MariaDB ColumnStore Product Training
立即下载
Bringing MySQL Compatibility to HBase using Database Virtualization
立即下载