DataBaseX v1.0.3 - The Virtual DBA, Smart-Async Offloader & Great Performance Update
INTRODUCING: Smart-Async Offloader (The Graal Anti-Lag) Say goodbye to server freezes caused by legacy plugins!
Zero-Block Execution: When a third-party plugin attempts to run a blocking SQL write (UPDATE, INSERT, DELETE) directly on the Main Thread, DataBaseX now intercepts the execution bytecode dynamically.
Non-Blocking Relay: The query is instantaneously offloaded to a high-priority asynchronous pool and a successful response is immediately simulated back to the caller. **Your server TPS remains at a flawless 20.0**, completely unaffected by network latencies or disk spikes!
️ INTRODUCING: The Virtual DBA (Index Recommender Engine) Ever wonder why certain SQL queries take 50ms+ on large servers? DataBaseX now analyzes it automatically for you!
Autonomous EXPLAIN Plan: When a slow query is caught, DataBaseX silently executes a background EXPLAIN check on your active database to evaluate its execution cost.
Full Scan Detection: If a Full Table Scan (ALL) is detected due to a missing key, the Virtual DBA prints a beautiful, highlighted recommendation in your console, providing the **exact SQL command** to create the missing index and boost speeds by up to **100x**!
MASSIVE CPU OPTIMIZATION (Zero-Contention Engine)
Caffeine WeakKeys Integration: We completely replaced the legacy `Collections.synchronizedMap` in all SQL Interceptors with highly-concurrent Caffeine Caches. Say goodbye to thread blocking! High-traffic servers with async SQL will see a massive drop in CPU overhead.
O(1) StackWalker Caching: The expensive plugin-caller identification is now cached exactly once upon `PreparedStatement` creation. Execution speed on fast queries is now instantaneous.
️ ZERO-FREEZE RESILIENCE ARCHITECTURE
Full Resilience Integration: Should an offloaded async query fail due to a sudden database crash, DataBaseX automatically re-routes it into the **Local Outage Resilience disk-queue**, ensuring zero data loss even under catastrophic conditions.
Non-Blocking Async Writer: The Outage Resilience engine has been entirely optimized. It now uses an ultra-fast `ConcurrentLinkedQueue` in RAM combined with a background Bulk-Writer daemon. Your Main Thread will **never** freeze waiting for disk I/O again during a database crash!
MEMORY LEAK FIXES & LEAK-HUNTER UPGRADE
LoopDetector Fix: Fixed a critical RAM leak where N+1 query loop trackers would infinitely accumulate in `ThreadLocal` storage. It now uses a strict 1-second auto-expiring Caffeine memory space.
GC-Aware LeakHunter: Upgraded the LeakHunter to hook natively into Java's Garbage Collector. It now safely handles dropped/abandoned native JDBC objects without maintaining dangerous hard references.
THE SMARTEST DATABASE AGENT EVER BUILT. Take back control of your performance with DataBaseX v1.0.3!