Weekly Community Newsletter: MySQL Leads DB‑Engines May Ranking, DBLE & TXLE Updates, and MySQL Tips

Newsletter Overview The weekly summary is compiled by the community reporter, providing curated technical news and updates for the DBLE, DTLE, and TXLE open‑source middleware projects.

DB‑Engines May Ranking According to DB‑Engines, the May 2024 Top‑10 list remains unchanged from the previous month, with MySQL achieving the highest month‑over‑month increase of 14.29 %, narrowing the gap with Oracle, while SQL Server’s share continues to decline. The ranking is based on five metrics: search keyword volume on Google/Bing, Google Trends searches, Indeed job postings, LinkedIn profile mentions, and Stack Overflow question/interest counts.

Community Resources Featured links include a deep dive into DBLE 3.0 planning, free Mycat issue diagnostics, a MySQL tips collection, a SQL tuning article on column CHECK constraints, a case study of a “Bad handshake” issue caused by upgrading to MySQL 5.7.28, and a guide on monitoring long‑running UPDATE statements on large tables.

DBLE Weekly Report New feature development focuses on trace design, post‑1687 optimizations, online DDL design, and a revised configuration file draft. Bug fixes address XA refactoring (#1854) and a potential DDL hang (#1856). Community questions answered this week cover memory configuration, port conflicts when running Mycat and DBLE together, image corruption when storing BLOBs via JDBC, and startup failures caused by outdated backend MySQL versions.

TXLE Weekly Report The financial‑grade distributed transaction framework saw functional optimizations and refactoring, including a cache design document, preliminary pre‑sales documentation, an automatic compensation principle analysis, default expiration settings for system and transaction caches, consolidation of timers into SchedulerUtil.java , and performance testing that reached over 2,900 TPS.

Upcoming Plans For DBLE, the next release (2.20.04.0) is scheduled, along with continued trace design and online DDL work. TXLE will focus on further functional optimizations and preparation of pre‑sales documentation.

Community Call‑to‑Action Readers are invited to submit suggestions or questions about DBLE, DTLE, and TXLE in the public comments, with the promise of professional answers and a small token of appreciation.