Mycat2 Versions Save

1.add config forcedPushDownBroadcast = false 2.impr mycat ui 3.fix global table push down

1.fix mycat ui 2.support

SET SESSION TRANSACTION READ WRITE

SELECT @@session.transaction_read_only

SET SESSION TRANSACTION READ ONLY

fix mycat ui

1.fix normal table : wrong table mapping 2.fix insert blob 3.fix PartitionByFileMap support BigInteger 4.improve readXARecoveryLog with instanceType(WRITE) 5.push down count/sum... cease to be effective 6.fix create table to create physical table 7.config:shading =>sharding

1.support back connection connects timeout 2.only MySQL type datasources can create tables automatically 3.R/W support update/delete join 4.remove mapdb 5.add SQLCreateFunctionHandler/SQLDropFunctionHandler 6.fix prepare statement execute wrong long value 7.fix alter table statement #558 8.service unavailable due to repair exception 864b86417479568391d464bce19a97297ced5e61 9.support heidisql 10.fix PartitionByMonth,PartitionByHotDate 11.allow nested transactions

fix MycatTableLookupSemiJoinRule occurs null exception(BKAJOIN)

1.fix Colocated Push Down occurs null exception 2.two layer mapping cannot be used in the same field slicing algorithm 3.support replace statement

1.When the delete update statement is used, it points to the slave node 2.Fix explain insert update 3.Showdatasources show duplicates

https://github.com/MyCATApache/mycat2 1.19-2021-6-18

Support HINT Compared with the previous version, some rule-based SQL update technology has been upgraded to cost-based SQL update technology, and LocalRel represents the operation of the storage node while MycatRel represents the operation in Mycat, which is the next step of calculation and storage (separation/storage) Mixed) Use senior analysis to prepare. Simple support for MySQL index comments, and MySQL comments can be attached to the SQL that generates the index node Fix kill COMMAND Improve sharding (on-site sub-database and table with the same algorithm Fix resultset cache failure Upgrade connection scheduler Fix the connection problem of deleting the X log in the XA transaction, and the A connection cannot be released Fix the problem that the thread pool cannot handle multiple tasks at the same time (performance is greatly improved) Re-support colocate pushdown, that is, as long as SQL in some cases, such as involving a mysql, an ER group, push down the entire SQL completely, and no longer combine operations in mycat Fix MycatUnion error Fix the problem that the execution plan management compiles the SQL template in parallel while compiling repeatedly for the first time

https://github.com/MyCATApache/mycat2 1.19-2021-6-18 schema配置中单表,全局表,分片表的datanode配置名字变更 https://www.yuque.com/ccazhw/ml3nkf/00d1d4fc145edf34b2d13fcd95908722

支持路由注释(读写分离,透传SQL下发,分区剪裁) 与上一个版本对比,部分基于规则的SQL重写技术升级为使用基于代价的SQL重写技术,并引入LocalRel表示存储节点的运算而MycatRel表示Mycat中的运算,为下一步计算与存储(分离/混合)使用代价分析做准备 简单支持MySQL index 注释,可以在生成存储节点的SQL中带有MySQL的索引注释 修复kill命令 完善分片算法(对于相同字段的分库分表,表名默认使用全局物理表下标表示),修复日期类型报错,从旧版本升级的mycat2需要检查配置的数据分布与mysql中的数据分布是否对应 修复结果集缓存失效 升级连接调度器 修复XA事务中删除XA日志的连接偶然出现阻塞导致连接不能释放的问题 修复线程池不能同时处理多个请求任务的问题(性能大大提高) 重新支持colocate push down,即只要SQL在一些情况,比如涉及一个mysql,一个ER组,就会把整个SQL完全下推,不再在mycat里合拼运算 修复MycatUnion报错 修复执行计划管理在第一次编译SQL模板的时候存在并行重复编译的问题