Multi Tenant Database Isolation And Context Switching

via “multi-threaded query execution with thd context isolation”

MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry.

Unique: Uses a unified THD object as the execution context for all SQL operations, enabling consistent state management across parser, optimizer, and storage engines. Implements per-connection memory arenas (sql_alloc) to batch allocations and reduce fragmentation compared to per-query allocations.

vs others: More memory-efficient than connection-per-process models (Apache httpd style); simpler than async/await models (PostgreSQL's async I/O) but requires more memory per connection than event-driven architectures