Weekly Community Technical Newsletter – MySQL, DBLE, DTLE, and SQLE Updates

This weekly newsletter, authored by the community’s “Gold Medal Broadcaster” Yongzheng, compiles selected technical news, bug reports, and open‑source project updates for developers.

Community News

Mycat issue – [Mycat Issue]

MySQL issue – [MySQL Issue]

Free giveaway – [All Courses]

Technical Articles This Week

MySQL setting terminology_use_previous causing crash – [Details]

MySQL 8.0: Using EXPLAIN ANALYZE to analyze SQL execution – [Details]

Understanding MySQL auto‑increment IDs – [Details]

MySQL database inspection checklist – [Details]

Open‑Source Progress – DBLE Weekly Report

New feature development:

Join query plan continuation (left‑inner, in → subquery).

DDL log / process refactor.

Bug fixes:

Null‑value to CSV conversion issue.

Distributed lock problems.

PS protocol issues under read/write splitting.

Hint handling in read/write splitting.

Vertical sharding view issues.

Community question responses:

DBLE XA configuration (disable, detection mechanisms).

SHOW @@SQL problem.

client_found_rows flag issue.

BTrace runtime errors and multi‑threaded SQL monitoring.

DBLE foreign‑key support.

Next Week Plan – DBLE

Continue thread‑name optimization.

Test other hint execution plans.

Data Transfer Component – DTLE Weekly Report

APIv2 MySQL column query error #861.

MySQL sync now supports WHERE predicate IS [NOT] NULL #347.

SQL Audit Tool – SQLE Weekly Report

Development updates:

Added SQL Server audit plugin for handling audit tickets.

Displayed front‑end and back‑end version info on UI.

Enabled independent remarks for each SQL in audit tickets.

Next week plan:

Add new MySQL audit rules.

Research user system redesign to introduce user groups.

Community Call‑for‑Feedback

If you have suggestions for community development or questions about DBLE, DTLE, or TXLE middleware, please leave a comment below; the team will collect all queries and provide professional answers.

Thank you for reading this week’s roundup – feel free to take the shared resources, and keep supporting the community!