Release 3.22.11.0

[yanhuqing666]

Release Notes:

We have released a new version 3.22.11.0.
Firstly, we must thanks to the following people for their contributions to our community：@xhailiang, @huashusu, @13611582598, @2779382063, @zeroxxmmbm, @24pawa.

Features:

• [[improvement] support off-heap memory leak monitor #3529] Add monitor for off-heap memory leak. More Detail, see doc.

• [[improvement] Support delay detection under master-slave structure #3549] Support delay detection under master-slave structure. More Detail, see doc.

• [[improvement] support sql_dump log #3431] Support sql_dump log. More Detail,see doc.

• [可否支持分库分表下的读写分离本地读 #3429] Support local read for Read-write separation when using sharding-table. More Detail, see doc.Thanks to @2779382063 for reporting the issue.

• [[Improvement] Multi-table update support #3586] Support some scenes of multi-table update. More Detail, see doc

• [Pseudo support drop dble database #3587] Pseudo support for dropping dble database. More Detail, see doc

• [[Improvement] native support json decode function #3585] Support native json decode function. More Detail, see doc

Bug-fixes:

• [JDBC设置useCursorFetch=true时，DBLE兼容mysql-connector-java-8.0.27问题 #3420] When set useCursorFetch=true in mysql-connector-java-8.0.27 , dble may report ArrayIndexOutOfBoundsException, thanks to @xhailiang for reporting the bug.
• [The java.specification.maintenance.version parameter of the JDK version is not supported #3450] Some parameters of the JDK like The java.specification.maintenance.version is not supported, thanks to @huashusu for reporting the bug.
• [MultiNodeSelectHandler cause hang #3444] MultiNodeSelectHandler may cause dble to hang , thanks to @13611582598 for reporting the bug.
• [项目卡死CPU跑满，日志出现大量exception #3495] CPU usage up to 100% and report lots of exceptions, thanks to @zeroxxmmbm for reporting the bug.
• [load data local infile将数据导入到dble后，不会释放占用的内存 #3427] When load data local infile into dble, the used memory will not be recycled, thanks to @24pawa for reporting the bug.
• Optimize some log problems.
• Optimize some performance problems

Breaking backward compatibility:

• [[compatibility] Change the delayThreshold parameter default unit #3546] Change the default unit of parameter delayThreshold, from second to millssecond. More Detail,seedoc

---

发行说明：

我们发布了新版本 3.22.11.0。
首先，我们必须感谢以下人士对我们社区的贡献：@xhailiang, @huashusu, @13611582598, @2779382063, @zeroxxmmbm, @24pawa .

特性：

• [[improvement] support off-heap memory leak monitor #3529] 添加堆外内存泄漏监视器. 更多详细信息，请参见doc.

• [[improvement] Support delay detection under master-slave structure #3549] 支持主从结构下的延时检测. 更多详细信息，请参见doc.

• [[improvement] support sql_dump log #3431] 支持审计日志. 更多详细信息，请参见doc.

• [可否支持分库分表下的读写分离本地读 #3429] 支持分库分表时候的读写分离本地读功能. 更多详细信息，请参见doc.感谢 @2779382063 贡献此需求.

• [[Improvement] Multi-table update support #3586] 支持部分场景的多表update. 更多详细信息，请参见doc

• [Pseudo support drop dble database #3587] 伪支持删除 dble 数据库. 更多详细信息，请参见doc

• [[Improvement] native support json decode function #3585] 支持本地json函数的计算.更多详细信息，请参见doc

缺陷修复:

• [JDBC设置useCursorFetch=true时，DBLE兼容mysql-connector-java-8.0.27问题 #3420] 当我们在 mysql-connector-java-8.0.27里设置了useCursorFetch=true, dble 可能会报错ArrayIndexOutOfBoundsException, 感谢 @xhailiang 报告此bug.
• [The java.specification.maintenance.version parameter of the JDK version is not supported #3450] 不支持 JDK 的一些参数，例如 The java.specification.maintenance.version, 感谢 @huashusu 报告此bug.
• [MultiNodeSelectHandler cause hang #3444] MultiNodeSelectHandler 可能导致dble 卡死 , 感谢 @13611582598 报告此bug.
• [项目卡死CPU跑满，日志出现大量exception #3495] CPU使用率高达100% 并且报出大量异常, 感谢 @zeroxxmmbm 报告此bug.
• [load data local infile将数据导入到dble后，不会释放占用的内存 #3427] 当使用load data local infile导入dble, 使用过的内存不会被回收, 感谢 @24pawa 报告此bug.
• 优化一些日志问题。
• 优化一些性能问题。

和旧版本的不兼容项：

• [[compatibility] Change the delayThreshold parameter default unit #3546] 将参数“delayThreshold”的默认单位从秒更改为毫秒。更多详细信息，请参见doc

---

This discussion was created from the release Release 3.22.11.0.