DataBaseX -----
Eliminate database lag! Transparently cache SELECT queries in 0ms, detect N+1 loops, hunter RAM leak- INTERACTIVE LIVE SQL EXPLAIN & OPTIMIZER
An absolute game-changer for database optimization! You can now analyze and explain query execution plans directly from your web dashboard:- Click-to-Explain Integration: A new Explain button has been added next to every active query in the "htop SQL" view and every slow query. Clicking it automatically runs a secure DB execution plan analysis.
- Live SQL Oracle Web Console: A brand new standalone textarea allows you to paste any arbitrary SELECT query and test its execution plan dynamically.
- Automated Index Suggestions: The engine parses your query's WHERE clauses, extracts table metrics, and generates target column indexation suggestions (e.g. ALTER TABLE ... ADD INDEX) when a slow Full Table Scan (type ALL) is detected.
- POOLED ASYNCHRONOUS DIAGNOSTICS
- Zero-Overhead Queries: Telemetry analyzes queries asynchronously utilizing active HikariCP connection pools, preventing any performance impact on the Minecraft server thread.
- Secure Execution: The endpoint is protected under the same secure session token validation and filters out non-SELECT queries to prevent unauthorized mutations.
- HIGH-PERFORMANCE AGENT ENGINE OPTIMIZATIONS
Under the hood, we have completely overhauled the agent's performance and stability profile:- Elimination of StackWalker Overhead: A new weak-keyed connection caller cache stores Java package names, eliminating expensive Java StackWalker calls during dynamic prepared statement analysis.
- O(1) Bounded Slow Queries Queue: Telemetry now records slow queries in an ArrayBlockingQueue utilizing an O(1) eviction pattern, avoiding linear list-size lookups and GC pressure.
- WAF Regex Cache Integration: Safely analyzed SQL patterns are cached dynamically to bypass recurring, CPU-intensive security firewall regex validations.
- Isolated Thread-Safe Diagnostics: Asynchronous explain worker threads now lease isolated, dedicated database connections from the active pool, preventing driver race conditions and connection corruption.
- Automated Resource Cleanups: Resolved a ThreadLocal reference leak within the batching manager and added periodic pruning for expired blacklist entries.
THE SMARTEST DATABASE AGENT EVER BUILT. Take back control of your performance with DataBaseX v1.0.5!
- STUNNING WEB DASHBOARD REDESIGN
The built-in Visual SQL Profiler has been entirely rebuilt from the ground up! Experience a breathtaking new UI:- Premium Glassmorphism Aesthetic: A beautiful deep dark theme with frosted glass cards, smooth hover transitions, and cyan/indigo neon accents.
- Animated Live Gauges: Real-time smooth SVG circular ring charts for live JVM CPU and RAM usage monitoring.
- Full English Translation: The web dashboard has been fully translated to English, providing a professional analytics interface for international server networks.
- ENGINE & ARCHITECTURE IMPROVEMENTS
- Externalized Web Resources: The HTTP engine no longer relies on heavy inline Java string concatenations. The dashboard HTML is now a strictly separated, lightweight internal resource file, improving memory footprint and code maintainability.
- Cross-Browser Compatibility: Modernized the CSS rendering (specifically the `background-clip` properties) to ensure flawless visual compatibility across all modern desktop and mobile browsers.
- BUG FIXES
- Frontend Metrics Fix: Fixed a frontend JavaScript payload issue where the Outage Resilience metrics (`savedWrites` and `replayedWrites`) were incorrectly displaying as `undefined` on the web interface. They now track exactly how many queries were saved during a database crash!
THE SMARTEST DATABASE AGENT EVER BUILT. Take back control of your performance with DataBaseX v1.0.4!
- 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!
- CRITICAL: The O(1) Quantum Leap for SQL History
Extreme engineering upgrades to the core JVM interception engine! We have completely re-architected internal queue metrics to support massive, enterprise-grade database loads.- Eradication of the O(N) Bottleneck: The sliding queue limits previously relied on the native `ConcurrentLinkedQueue.size()` method. On high-frequency servers, this triggered thousands of full queue traversals per second. Rewritten to operate on stack-level atomic indices, reducing complexity to true, instant **O(1)**!
- INTRODUCING: Java 9+ Stream-Based StackWalking
- Zero-Allocation Interception: Modernized the plugin detection suite to use the high-performance JDK **`StackWalker`** API instead of generating heavy JVM array allocations via `getStackTrace()`. Locating parent plugins is now practically free for the CPU.
- Deferred Lazy Traces: Heavy debugging stack traces are now generated lazily—**only** if a query actually exceeds your configured lag threshold! 99.9% of normal SQL queries bypass all stack overhead entirely.
SCALE DEFIANTLY. Experience invisible overhead and lightning speeds with DataBaseX v1.0.2!
Resource Information
Author:
----------
Total Downloads: 18
First Release: May 14, 2026
Last Update: May 24, 2026
Category: ---------------
All-Time Rating:
1 ratings
Version -----
Released: --------------------
Downloads: ------
Version Rating:
----------------------
-- ratings